Emeric HUNTER
@theemerichunter.bsky.social
Remote Dabatase Performance and Availability Expert for PostgreSQL & MySQL/MariaDB | I stop the bleeding and speed up your database | DBA - DBE - SRE
Why clip everything when you can just look inside? Use ST_Contains to skip the slow ST_Intersection when geometry is fully within another. Saves time for the big stuff. Thank Paul Ramsey for the Performance hacks. Check it out at Crunchy Data.
https://postgr.es/p/7lB
https://postgr.es/p/7lB
Paul Ramsey: PostGIS Performance: Intersection Predicates and Overlays
https://postgr.es/p/7lB
postgr.es
November 26, 2025 at 2:08 PM
Why clip everything when you can just look inside? Use ST_Contains to skip the slow ST_Intersection when geometry is fully within another. Saves time for the big stuff. Thank Paul Ramsey for the Performance hacks. Check it out at Crunchy Data.
https://postgr.es/p/7lB
https://postgr.es/p/7lB
Ever waited ages for an Odoo report? Same here. Turns out the elephant in the room was memory not slow queries. A resource upgrade gave us a 93% speed boost. Sometimes scaling up is the last resort and the best plan - Semab Tariq nails it.
https://postgr.es/p/7lA
https://postgr.es/p/7lA
semab tariq: Scaling Up Wasn’t the Plan — Until It Was the Only Plan
https://postgr.es/p/7lA
postgr.es
November 26, 2025 at 2:03 PM
Ever waited ages for an Odoo report? Same here. Turns out the elephant in the room was memory not slow queries. A resource upgrade gave us a 93% speed boost. Sometimes scaling up is the last resort and the best plan - Semab Tariq nails it.
https://postgr.es/p/7lA
https://postgr.es/p/7lA
Just released CloudNativePG 1.28.0 RC1! PostgreSQL loves complex queries like I love coffee. MySQL is great for speed but don't ask it to think too hard. pgvector vs MySQL 9 showdown!
https://www.postgresql.org/about/news/cloudnativepg-1280-rc1-released-3168/
https://www.postgresql.org/about/news/cloudnativepg-1280-rc1-released-3168/
CloudNativePG 1.28.0 RC1 Released!
Original link
www.postgresql.org
November 26, 2025 at 8:35 AM
Just released CloudNativePG 1.28.0 RC1! PostgreSQL loves complex queries like I love coffee. MySQL is great for speed but don't ask it to think too hard. pgvector vs MySQL 9 showdown!
https://www.postgresql.org/about/news/cloudnativepg-1280-rc1-released-3168/
https://www.postgresql.org/about/news/cloudnativepg-1280-rc1-released-3168/
Trying to load a CSV? Brace yourself for the dreaded 'value too long' nightmare. PostgreSQL shows the offending line but MySQL just leaves you hanging. Pro tip: use Google Sheets to find max length before diving in. Thanks Dave Stokes for the fix!
https://postgr.es/p/7lx
https://postgr.es/p/7lx
Dave Stokes: CSV Loading Error Fix: Data Too Long Or Value Too Long
https://postgr.es/p/7lx
postgr.es
November 25, 2025 at 2:08 PM
Trying to load a CSV? Brace yourself for the dreaded 'value too long' nightmare. PostgreSQL shows the offending line but MySQL just leaves you hanging. Pro tip: use Google Sheets to find max length before diving in. Thanks Dave Stokes for the fix!
https://postgr.es/p/7lx
https://postgr.es/p/7lx
MD5 is deprecated in PostgreSQL. Time to upgrade those passwords to scram-sha-256. You thought you were safe? Think again. If your users are not getting a password reset soon they will start to get suspicious warnings… Happy testing! - Dan Langille
https://postgr.es/p/7lw
https://postgr.es/p/7lw
Dan Langille: PostgreSQL: MD5 password support is deprecated – updating the user passwords
https://postgr.es/p/7lw
postgr.es
November 25, 2025 at 2:03 PM
MD5 is deprecated in PostgreSQL. Time to upgrade those passwords to scram-sha-256. You thought you were safe? Think again. If your users are not getting a password reset soon they will start to get suspicious warnings… Happy testing! - Dan Langille
https://postgr.es/p/7lw
https://postgr.es/p/7lw
When Patroni manages your Postgres cluster, all failovers are automatic... unless Mother Nature flips the chaos switch like inter-datacentre failovers. Get ready to learn ninja skills for when standby datacentres must pull heroic stunts.
Performing Standby Datacentre Promotions of a Patroni Cluster
Performing Standby Datacentre Promotions of a Patroni Cluster
www.percona.com
November 25, 2025 at 11:11 AM
When Patroni manages your Postgres cluster, all failovers are automatic... unless Mother Nature flips the chaos switch like inter-datacentre failovers. Get ready to learn ninja skills for when standby datacentres must pull heroic stunts.
Did you know PostgreSQL tables are limited to 1600 columns? Hardcoded and no way around it. So much for trying to break the mold. Thanks Frederic Delacourt for the reminder to keep it simple!
https://postgr.es/p/7lv
https://postgr.es/p/7lv
Frederic Delacourt: Did you know? Tables in PostgreSQL are limited to 1,600 columns
https://postgr.es/p/7lv
postgr.es
November 24, 2025 at 2:08 PM
Did you know PostgreSQL tables are limited to 1600 columns? Hardcoded and no way around it. So much for trying to break the mold. Thanks Frederic Delacourt for the reminder to keep it simple!
https://postgr.es/p/7lv
https://postgr.es/p/7lv
Kafka? Nah just use Postgres said Kaarel Moppel and ignited a fiery debate. Who knew a database could spark such drama. Let's see if this battle of opinions brings back the good old flame wars or just fizzles out.
https://postgr.es/p/7lt
https://postgr.es/p/7lt
Kaarel Moppel: Postgres, Kafka and event queues
https://postgr.es/p/7lt
postgr.es
November 24, 2025 at 2:03 PM
Kafka? Nah just use Postgres said Kaarel Moppel and ignited a fiery debate. Who knew a database could spark such drama. Let's see if this battle of opinions brings back the good old flame wars or just fizzles out.
https://postgr.es/p/7lt
https://postgr.es/p/7lt
PostgreSQL 18 arrives with skip scans. So fast it makes 66ms look like a time warp. No effort required, just enjoy the performance gains. Indexes never felt better. #PostgreSQL18
PostgreSQL 18: More performance with index skip scans
another post form Cybertec
www.cybertec-postgresql.com
November 24, 2025 at 8:34 AM
PostgreSQL 18 arrives with skip scans. So fast it makes 66ms look like a time warp. No effort required, just enjoy the performance gains. Indexes never felt better. #PostgreSQL18
Just had a Titanic experience cleaning up data in PostgreSQL. Who knew a VARCHAR could be so needy? Switched to SMALLINT for PassengerId cut my bloated table size by almost 7K bytes. Less is more folks! Shoutout to Dave Stokes for the tips!
https://postgr.es/p/7ls
https://postgr.es/p/7ls
Dave Stokes: Loading The Titanic Dataset Into PostgreSQL With DBeaver Part 3
https://postgr.es/p/7ls
postgr.es
November 23, 2025 at 2:08 PM
Just had a Titanic experience cleaning up data in PostgreSQL. Who knew a VARCHAR could be so needy? Switched to SMALLINT for PassengerId cut my bloated table size by almost 7K bytes. Less is more folks! Shoutout to Dave Stokes for the tips!
https://postgr.es/p/7ls
https://postgr.es/p/7ls
Is your PostgreSQL database feeling sluggish Does it take longer to fetch coffee than complete an SQL statement Time to implement some Data Retention Policy while your backups take their sweet time completing Auditors might even show up for moral support
Data Retention Policy Implementation – How and Why
Data Retention Policy Implementation – How and Why
www.percona.com
November 23, 2025 at 11:11 AM
Is your PostgreSQL database feeling sluggish Does it take longer to fetch coffee than complete an SQL statement Time to implement some Data Retention Policy while your backups take their sweet time completing Auditors might even show up for moral support
Just had an accounting whiner complain about deadlocks. "It's your Postgre system." Sure buddy just ignore the 350GB of dead data. A quick TRUNCATE and I’m their hero again. Who knew being a DBA could be this entertaining. Kudos to Laurenz Albe for the inspiration.
https://postgr.es/p/7lq
https://postgr.es/p/7lq
Laurenz Albe: The bastard DBA from hell
https://postgr.es/p/7lq
postgr.es
November 22, 2025 at 2:08 PM
Just had an accounting whiner complain about deadlocks. "It's your Postgre system." Sure buddy just ignore the 350GB of dead data. A quick TRUNCATE and I’m their hero again. Who knew being a DBA could be this entertaining. Kudos to Laurenz Albe for the inspiration.
https://postgr.es/p/7lq
https://postgr.es/p/7lq
Looks like PostgreSQL 19 is set to be a game changer with ALL SEQUENCES in publications. Because who doesn't love syncing their sequences? Thanks Amit Kapila for making upgrades as thrilling as watching paint dry. #PostgreSQL
https://postgr.es/p/7lp
https://postgr.es/p/7lp
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – Sequence synchronization in logical replication.
https://postgr.es/p/7lp
postgr.es
November 22, 2025 at 2:03 PM
Looks like PostgreSQL 19 is set to be a game changer with ALL SEQUENCES in publications. Because who doesn't love syncing their sequences? Thanks Amit Kapila for making upgrades as thrilling as watching paint dry. #PostgreSQL
https://postgr.es/p/7lp
https://postgr.es/p/7lp
Percona unboxes its new toy: the GA Percona Operator for MySQL on Kubernetes. Now with added replication goodness and zero training wheels. Finally something your cat won't mess with.
Introducing the GA Release of the New Percona Operator for MySQL: More Replication Options on Kubernetes
Introducing the GA Release of the New Percona Operator for MySQL: More Replication Options on Kubernetes
www.percona.com
November 22, 2025 at 11:12 AM
Percona unboxes its new toy: the GA Percona Operator for MySQL on Kubernetes. Now with added replication goodness and zero training wheels. Finally something your cat won't mess with.
PostgreSQL 18 introduces skip scans. Why read everything when you can skip what doesn't matter? It's like finding all the rare Pokémon without catching the common ones first. Thanks Hans-Juergen Schoenig for the performance upgrade we didn’t know we needed.
https://postgr.es/p/7l6
https://postgr.es/p/7l6
Hans-Juergen Schoenig: PostgreSQL 18: More performance with index skip scans
https://postgr.es/p/7l6
postgr.es
November 21, 2025 at 2:08 PM
PostgreSQL 18 introduces skip scans. Why read everything when you can skip what doesn't matter? It's like finding all the rare Pokémon without catching the common ones first. Thanks Hans-Juergen Schoenig for the performance upgrade we didn’t know we needed.
https://postgr.es/p/7l6
https://postgr.es/p/7l6
Waiting for SQL:202y means the long-awaited GROUP BY ALL is finally on the horizon. Tired of repeating the obvious in GROUP BY? Just remember it can lead to surprise results. Group wisely my friends. Kudos to Peter Eisentraut for championing this change.
https://postgr.es/p/7lo
https://postgr.es/p/7lo
Peter Eisentraut: Waiting for SQL:202y: GROUP BY ALL
https://postgr.es/p/7lo
postgr.es
November 21, 2025 at 2:03 PM
Waiting for SQL:202y means the long-awaited GROUP BY ALL is finally on the horizon. Tired of repeating the obvious in GROUP BY? Just remember it can lead to surprise results. Group wisely my friends. Kudos to Peter Eisentraut for championing this change.
https://postgr.es/p/7lo
https://postgr.es/p/7lo
PostgreSQL is for data wizards who love complex queries and analytics. MySQL is your best friend for fast and simple web apps. Choose wisely or face the wrath of your database!
https://www.postgresql.org/about/news/pgbouncer-1250-released-3169/
https://www.postgresql.org/about/news/pgbouncer-1250-released-3169/
PgBouncer 1.25.0 released
Original link
www.postgresql.org
November 21, 2025 at 8:35 AM
PostgreSQL is for data wizards who love complex queries and analytics. MySQL is your best friend for fast and simple web apps. Choose wisely or face the wrath of your database!
https://www.postgresql.org/about/news/pgbouncer-1250-released-3169/
https://www.postgresql.org/about/news/pgbouncer-1250-released-3169/
Counting customers is a simple SQL task right? Wrong. It can get absurdly complex. Remember what you really need before running that query. #PostgreSQLMysteries
Counting Customers in PostgreSQL
another post form Cybertec
www.cybertec-postgresql.com
November 21, 2025 at 8:34 AM
Counting customers is a simple SQL task right? Wrong. It can get absurdly complex. Remember what you really need before running that query. #PostgreSQLMysteries
Why do you have 42 indexes on your users table? Just because you can doesn't mean you should. Every extra index is a performance killer in disguise. Drop the bloat and keep it lean. Your API will thank you. Thanks Nikolay Samokhvalov for the insights.
https://postgr.es/p/7l5
https://postgr.es/p/7l5
Nikolay Samokhvalov: #PostgresMarathon 2-013: Why keep your index set lean
https://postgr.es/p/7l5
postgr.es
November 20, 2025 at 2:08 PM
Why do you have 42 indexes on your users table? Just because you can doesn't mean you should. Every extra index is a performance killer in disguise. Drop the bloat and keep it lean. Your API will thank you. Thanks Nikolay Samokhvalov for the insights.
https://postgr.es/p/7l5
https://postgr.es/p/7l5
PostgreSQL 13 gets its last hurrah with this week’s minor release. Meanwhile PostgreSQL 19 brings us wal_fpi_bytes for VACUUM logs and sequence sync for logical replication. Ah the joys of upgrades—so many changes so little time. Thanks Ian Barwick!
https://postgr.es/p/7l3
https://postgr.es/p/7l3
Ian Barwick: PgPedia Week, 2025-11-09
https://postgr.es/p/7l3
postgr.es
November 20, 2025 at 2:03 PM
PostgreSQL 13 gets its last hurrah with this week’s minor release. Meanwhile PostgreSQL 19 brings us wal_fpi_bytes for VACUUM logs and sequence sync for logical replication. Ah the joys of upgrades—so many changes so little time. Thanks Ian Barwick!
https://postgr.es/p/7l3
https://postgr.es/p/7l3
PostgreSQL 19 is here and it's not just another release. Now we have wal_fpi_bytes in EXPLAIN and pg_stat. Because who doesn't love more numbers in their life? Thanks Ian Barwick for the heads up on PgPedia.
https://postgr.es/p/7k-
https://postgr.es/p/7k-
Ian Barwick: PgPedia Week, 2025-11-02
https://postgr.es/p/7k-
postgr.es
November 19, 2025 at 2:08 PM
PostgreSQL 19 is here and it's not just another release. Now we have wal_fpi_bytes in EXPLAIN and pg_stat. Because who doesn't love more numbers in their life? Thanks Ian Barwick for the heads up on PgPedia.
https://postgr.es/p/7k-
https://postgr.es/p/7k-
Ever wondered what’s lurking in Postgres’ internal tables? Turns out there’s a treasure trove of data just waiting for you to query it. If only software devs knew about it. Thanks Elizabeth Garrett Christensen for the reminder. #Postgres
https://postgr.es/p/7kZ
https://postgr.es/p/7kZ
Elizabeth Garrett Christensen: Postgres Internals Hiding in Plain Sight
https://postgr.es/p/7kZ
postgr.es
November 19, 2025 at 2:03 PM
Ever wondered what’s lurking in Postgres’ internal tables? Turns out there’s a treasure trove of data just waiting for you to query it. If only software devs knew about it. Thanks Elizabeth Garrett Christensen for the reminder. #Postgres
https://postgr.es/p/7kZ
https://postgr.es/p/7kZ
Just dropped pg_statviz 0.8 with PostgreSQL 18 support. Now featuring fancy byte-based I/O stats. It’s like your database got a makeover. No invasive agents just pure SQL magic. Check it out on GitHub. Thanks to Jimmy Angelakos for the release!
https://postgr.es/p/7kX
https://postgr.es/p/7kX
Jimmy Angelakos: pg_statviz 0.8 released with PostgreSQL 18 support
https://postgr.es/p/7kX
postgr.es
November 18, 2025 at 2:08 PM
Just dropped pg_statviz 0.8 with PostgreSQL 18 support. Now featuring fancy byte-based I/O stats. It’s like your database got a makeover. No invasive agents just pure SQL magic. Check it out on GitHub. Thanks to Jimmy Angelakos for the release!
https://postgr.es/p/7kX
https://postgr.es/p/7kX
PostgreSQL 13 hits EOL on Nov 13 2025. After that it’s like having a dinosaur as a pet. No updates. No support. Just you and your brave decision to stick with outdated tech. Thanks Jobin Augustine for the reminder!
https://postgr.es/p/7kU
https://postgr.es/p/7kU
Jobin Augustine: PostgreSQL 13 Is Reaching End of Life. The Time to Upgrade is Now!
https://postgr.es/p/7kU
postgr.es
November 18, 2025 at 2:03 PM
PostgreSQL 13 hits EOL on Nov 13 2025. After that it’s like having a dinosaur as a pet. No updates. No support. Just you and your brave decision to stick with outdated tech. Thanks Jobin Augustine for the reminder!
https://postgr.es/p/7kU
https://postgr.es/p/7kU
Another free Postgres hosting option is here because why not? Tiger Data is now giving away 750MB storage for the dreamers and small project conquerors. Get ready to be amazed by the endless possibilities...or not.
Another free Postgres hosting option arrives
a new post
postgresweekly.com
November 18, 2025 at 12:30 PM
Another free Postgres hosting option is here because why not? Tiger Data is now giving away 750MB storage for the dreamers and small project conquerors. Get ready to be amazed by the endless possibilities...or not.