Crunchy Data
crunchydata.com
Crunchy Data
@crunchydata.com
Just Postgres www.crunchydata.com
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...
April 16, 2025 at 6:36 PM
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.
January 21, 2025 at 3:56 PM
>> 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.
December 3, 2024 at 7:39 PM
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.
November 13, 2024 at 5:15 PM
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.
November 4, 2024 at 6:12 PM
Analytics with Postgres Extending that idea of “Just Use Postgres for Everything”.
November 1, 2024 at 4:27 PM