explore | Grilled Cheese

UUIDs often end up in text columns because an ORM or a JSON payload made it the easy path. I measured what that costs on 5M rows.

The text index came out 88% bigger and one level deeper, so every lookup reads one more page. With random v4 keys, inserts went from 47 s to 79 s.

#PostgreSQL

Apache Community Over Code Lakehouse day kicking off! And #PostgreSQL is here too ;)

#Apache #Lakehouse #CommunityOverCode #OpenSource #Postgres

How to Install Concourse CI on #Ubuntu #VPS Here is a detailed step-by-step guide on how to install Concourse CI on Ubuntu VPS, complete with setup instructions for the Concourse web UI, worker, and #PostgreSQL backend database. ...
Continued 👉 #selfhosting #letsencrypt #concourseci #selfhosted

I suppose I should ask a question to hopefully learn more.

Is there a better way to do this:

"SELECT datname FROM pg_database WHERE datistemplate = false AND datname != 'postgres' AND datname NOT SIMILAR TO '%test_%' ORDER BY datname;")

#SQL #PostgreSQL

🎓 Postgres belongs in the classroom!

PG DATA 2027 offers FREE Academic Partnership to colleges and universities teaching CS, IT, or data management—even if they don't teach PostgreSQL yet.

📍 Chicago | June 11–12, 2027

Details: lnkd.in/p/gdxZGrTv

#PostgreSQL #PGDATA2027

Christophe Pettus: All Your GUCs in a Row: parallel_setup_cost and parallel_tuple_cost

https://postgr.es/p/9xy

#postgresql

Christophe Pettus: All Your GUCs in a Row: parallel_leader_participation

https://postgr.es/p/9xz

#postgresql

Chris van Eijk: new row violates row-level security policy: the causes

https://postgr.es/p/9xw

#postgresql

Chris van Eijk: One partition per tenant in PostgreSQL, measured

https://postgr.es/p/9xx

#postgresql

Thank you Harness for your Gold sponsorship! Your generous support makes community events like Postgres Summit US possible!

www.harness.io

#PostgreSQL #postgres #sponsor

Jacksonville, just a few days to go. 🌴

Barrett Chambers will be at @RedHatSummit Connect next week to talk licensing, lock-in, and control across MySQL, MongoDB, PostgreSQL & Redis.

Join us: https://red.ht/4hw1Cyt

#RHSummit #OpenSource #MySQL #MongoDB #PostgreSQL #Redis

Thank you Yugabyte for your Gold sponsorship! Your generous support makes community events like Postgres Summit US possible!

www.yugabyte.com

#PostgreSQL #postgres #sponsor

He creado un canal en Rumble con las partes del tutorial #PostgreSQL y el lenguaje #SQL:

https://rumble.com/c/c-4781052

Suscríbete a mi canal.

#bbdd #Programacion #SiguemeYTeSigo #Followback

Nota: imagen generada con IA.

Álvaro Hernández: Scaling Citus without limits: announcing Query Routers in StackGres

https://postgr.es/p/9xu

#postgresql

Shaun Thomas: PG Phriday: Against the WAL

https://postgr.es/p/9xv

#postgresql

Thirty Years That Shaped #Postgres Architecture-"This insightful interview looks at the foundational architectural choices that have sustained the open source database over its history"
IProgrammer looks into it: dub.sh/z75Woq0
#postgresql #snowflake

In #PostgreSQL, using NOT IN to exclude rows is a mistake. It's the first one in Jimmy Angelakos's book PostgreSQL Mistakes and How to Avoid Them.

Free signed copies at the pgEdge table, PGConf.EU 2026, #Valencia, Tue Oct 20.

📖 www.manning.com/books/postgr...

#Postgres #Tech #Europe #Spain

Thank you Databricks for your Gold sponsorship! Your generous support makes community events like Postgres Summit US possible!

www.databricks.com

#PostgreSQL #postgres #sponsor

📢 In just 4 days we will be presenting “What’s New in Postgres 19” with Christphe Pettus! RSVP today! 🐘

www.meetup.com/postgresql-1...

#PostgreSQL #postgres #meetup