Sign in

Crunchy Data

@crunchydata.com
2.1K followers 269 following 96 posts

Just Postgres www.crunchydata.com

PostsRepliesMedia
Crunchy Data @crunchydata.com · 16/04/2025
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...
050
Crunchy Data @crunchydata.com · 21/01/2025
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.
0140
Crunchy Data @crunchydata.com · 03/12/2024
>> 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.
071
Crunchy Data @crunchydata.com · 13/11/2024
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.
000
Crunchy Data @crunchydata.com · 04/11/2024
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.
040
Crunchy Data @crunchydata.com · 01/11/2024
Analytics with Postgres Extending that idea of “Just Use Postgres for Everything”.
000