#postgres19 — Public Fediverse posts

🎉 Ah yes, Postgres 19, the mythical creature we have all been waiting for, like a database unicorn. Apparently, we need it to answer burning questions like "What was your data wearing last Tuesday?" 🕵️‍♂️ With cutting-edge features from 2011, we'll finally be able to relive the thrilling days of yore, one SQL query at a time! 🚀
https://www.pgedge.com/blog/looking-forward-to-postgres-19-its-about-time #Postgres19 #DatabaseUnicorn #SQLQueries #TechHumor #CuttingEdgeFeatures #HackerNews #ngated

🎉 Ah yes, Postgres 19, the mythical creature we have all been waiting for, like a database unicorn. Apparently, we need it to answer burning questions like "What was your data wearing last Tuesday?" 🕵️‍♂️ With cutting-edge features from 2011, we'll finally be able to relive the thrilling days of yore, one SQL query at a time! 🚀
https://www.pgedge.com/blog/looking-forward-to-postgres-19-its-about-time #Postgres19 #DatabaseUnicorn #SQLQueries #TechHumor #CuttingEdgeFeatures #HackerNews #ngated

Looking Forward to Postgres 19: It's About Time

https://www.pgedge.com/blog/looking-forward-to-postgres-19-its-about-time

#HackerNews #Postgres19 #DatabaseUpdates #TechTrends #OpenSource #DataManagement

Looking Forward to Postgres 19: It's About Time

https://www.pgedge.com/blog/looking-forward-to-postgres-19-its-about-time

#HackerNews #Postgres19 #DatabaseUpdates #TechTrends #OpenSource #DataManagement

🎉 Hold onto your keyboards, folks! Postgres 19 is here with "not-really-hints" query hints 😂. Apparently, calling them hints would be too mainstream for the oh-so-elite Postgres community 🙄. Prepare for the "mass hysteria" of developers pretending this is groundbreaking 🚀.
https://www.pgedge.com/blog/looking-forward-to-postgres-19-query-hints #Postgres19 #queryhints #developerhumor #databaseupdates #technews #HackerNews #ngated

🎉 Hold onto your keyboards, folks! Postgres 19 is here with "not-really-hints" query hints 😂. Apparently, calling them hints would be too mainstream for the oh-so-elite Postgres community 🙄. Prepare for the "mass hysteria" of developers pretending this is groundbreaking 🚀.
https://www.pgedge.com/blog/looking-forward-to-postgres-19-query-hints #Postgres19 #queryhints #developerhumor #databaseupdates #technews #HackerNews #ngated

Looking Forward to Postgres 19: Query Hints

https://www.pgedge.com/blog/looking-forward-to-postgres-19-query-hints

#HackerNews #Postgres19 #QueryHints #DatabaseUpdates #SQLTech

Looking Forward to Postgres 19: Query Hints

https://www.pgedge.com/blog/looking-forward-to-postgres-19-query-hints

#HackerNews #Postgres19 #QueryHints #DatabaseUpdates #SQLTech

Postgres marks dead tuples reusable after VACUUM - it doesn't free them to the OS. VACUUM FULL does, but holds an ACCESS EXCLUSIVE lock the whole time. On a large #PostgreSQL table in production, that's a non-starter.

#Postgres19 introduces REPACK CONCURRENTLY 🔧 In-core rewrites, lock held only during the final swap. Demo: 138 MB → 52 MB, returned to OS.

REPACK USING INDEX physically reorders rows: 3,300 buffer reads → 49, 3ms → 0.6ms. Shaun Thomas walks through both.

https://www.pgedge.com/blog/looking-forward-to-postgres-19-the-new-repack-command

Postgres marks dead tuples reusable after VACUUM - it doesn't free them to the OS. VACUUM FULL does, but holds an ACCESS EXCLUSIVE lock the whole time. On a large #PostgreSQL table in production, that's a non-starter.

#Postgres19 introduces REPACK CONCURRENTLY 🔧 In-core rewrites, lock held only during the final swap. Demo: 138 MB → 52 MB, returned to OS.

REPACK USING INDEX physically reorders rows: 3,300 buffer reads → 49, 3ms → 0.6ms. Shaun Thomas walks through both.

https://www.pgedge.com/blog/looking-forward-to-postgres-19-the-new-repack-command