Postgres + Iceberg side-by-side next to the same query with a Postgres HEAP table.

Half a millisecond for the optimized 🔥 . 10 seconds for the long method.

www.crunchydata.com/products/war...

SQL output can be messy. Psql options for formatting output. A handy option is

\pset border 2

This will add top and bottom borders with double lines (╔, ╚, ╤, ╧, etc.). A Header row bordered with a double-line separator . Each row is separated by single lines. Each column is clearly separated.

>> This combination leverages the simplicity of flat files, the scalability and transactional capabilities of Iceberg, and the structured query efficiency of Postgres to create a robust, flexible medallion architecture.

We've got several team members out at #Kubecon this week. If you're there we'd love to say hi, stop by and grab an activity book or other swag from our booth.

Did you know when using psql \e will open your default $EDITOR to edit the last run query?

Save and close and it'll execute that query.

Analytics with Postgres Extending that idea of “Just Use Postgres for Everything”.