iiinova — where your digital self keeps evolving

Marco Slot

@marcoslot.com

1.1K followers 356 following 95 posts

Mostly posts about PostgreSQL, Snowflake Postgres, and PostgreSQL extensions. Formerly Crunchy Data, Microsoft, Citus Data, AWS, TCD, VU

Posts Replies Media

Marco Slot @marcoslot.com · 04/11/2025

pg_lake just went open source! (Apache 2.0) pg_lake is a set of extensions (from Crunchy Data Warehouse) that add comprehensive Iceberg support and data lake access to Postgres, with @duckdb.org transparently integrated into the query engine. Announcement blog: www.snowflake.com/en/engineeri...

1273

Marco Slot @marcoslot.com · 04/05/2025

Generative AI comes up with details that would be hilarious, if it wasn't so mind boggling that it can come up with these details.

010

Marco Slot @marcoslot.com · 22/04/2025

And there it is: Native logical replication from any Postgres server to Iceberg managed by Crunchy Data Warehouse. Speed up Postgres analytical queries 100x with 2 commands.

2202

Marco Slot @marcoslot.com · 11/03/2025

Auto-vacuum for #Iceberg tables is now available in Crunchy Data Warehouse! We're always aiming for a 0-touch experience where possible, so we went out of our way to make Iceberg compaction & cleanup fully automatic without any configuration. Still pretty interesting to see a manual vacuum:

060

Marco Slot @marcoslot.com · 07/02/2025

Postgres is increasingly becoming a versatile data platform, instead of just an operational database. Using pg_parquet you can trivially export data to S3, and using Crunchy Data Warehouse you can just as easily query or import Parquet files from PostgreSQL.

0102

Marco Slot @marcoslot.com · 28/01/2025

Deepseek R1 in an ollama "container app" on a managed Postgres server, because... why not?

050

Marco Slot @marcoslot.com · 17/12/2024

End-to-end demo of the new pg_incremental extension. There's raw events table and a summary table containing view counts. You then define a pipeline using an insert..select command, and keeps running that to do fast, reliable, incremental processing in the background.

162

Marco Slot @marcoslot.com · 04/12/2024

It's also not so easy to get started right now, with only Spark supporting the catalog and no way to create tables without a query engine. Presumably that will improve quickly. Still, I think this is what getting started with Iceberg should look like:

121

Marco Slot @marcoslot.com · 22/11/2024

The promise of Apache Iceberg. It's like pong for databases. #databs

0204

Marco Slot @marcoslot.com · 20/11/2024

The performance difference between Iceberg and heap tables for analytical operations in Crunchy Data Warehouse can be pretty big. But you really start noticing the difference when you run through several steps.

052

Marco Slot @marcoslot.com · 20/11/2024

Quick demo of Iceberg in PostgreSQL with Crunchy Data Warehouse. Create an Iceberg table from a file, load some more data, and run fast queries.

041

Marco Slot @marcoslot.com · 14/11/2024

Playing with @pwramsey.bsky.social 's OpenAI extension on Crunchy Bridge 🤯

133