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
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.
Why run a marathon when you can take a nap? No-Op Updates in PostgreSQL and MySQL are the lazy coder's dream. Forget table locks take a siesta while your DB does the talking. The drama of MVCC unfolds!
A Tale of Two Databases: No-Op Updates in PostgreSQL and MySQL
A Tale of Two Databases: No-Op Updates in PostgreSQL and MySQL
www.percona.com
November 18, 2025 at 11:12 AM
Why run a marathon when you can take a nap? No-Op Updates in PostgreSQL and MySQL are the lazy coder's dream. Forget table locks take a siesta while your DB does the talking. The drama of MVCC unfolds!
Upgrading PostgreSQL? Sure it’s faster with pg_upgrade but good luck not losing your subscriber state. That’s like playing Jenga with your data. Check out how to save yourself from replication headaches. Thanks Vignesh C for the insights.
https://postgr.es/p/7kP
https://postgr.es/p/7kP
vignesh C: Seamless PostgreSQL subscriber upgrades: Preserving Logical Replication state
https://postgr.es/p/7kP
postgr.es
November 17, 2025 at 2:08 PM
Upgrading PostgreSQL? Sure it’s faster with pg_upgrade but good luck not losing your subscriber state. That’s like playing Jenga with your data. Check out how to save yourself from replication headaches. Thanks Vignesh C for the insights.
https://postgr.es/p/7kP
https://postgr.es/p/7kP
UUIDs Version 7 leaking timestamps? Just what we needed! Daniel Vérité shows how to encrypt those pesky creation dates to keep your secrets secret. Who knew UUIDs could be so chatty?
https://postgr.es/p/7kO
https://postgr.es/p/7kO
Daniel Vérité: Producing UUIDs Version 7 disguised as Version 4 (or 8)
https://postgr.es/p/7kO
postgr.es
November 17, 2025 at 2:03 PM
UUIDs Version 7 leaking timestamps? Just what we needed! Daniel Vérité shows how to encrypt those pesky creation dates to keep your secrets secret. Who knew UUIDs could be so chatty?
https://postgr.es/p/7kO
https://postgr.es/p/7kO
Survived PGConf.EU 2025 in Riga. 4 tracks lots of sessions and learning about PostgreSQL.Cardio stories were unexpected but #opensource too. Geeks unite. planning next community events day!
A Glimpse of PostgreSQL Conference Europe 2025
another post form Cybertec
www.cybertec-postgresql.com
November 17, 2025 at 8:34 AM
Survived PGConf.EU 2025 in Riga. 4 tracks lots of sessions and learning about PostgreSQL.Cardio stories were unexpected but #opensource too. Geeks unite. planning next community events day!
Just a tad late but here’s the October PUG recording by Henrietta Dombrovskaya. Because who doesn’t love late data drops? Grab your popcorn and enjoy the wait. Happy listening or whatever it is we do with recordings!
https://postgr.es/p/7kM
https://postgr.es/p/7kM
Henrietta Dombrovskaya: October PUG Recording
https://postgr.es/p/7kM
postgr.es
November 16, 2025 at 2:08 PM
Just a tad late but here’s the October PUG recording by Henrietta Dombrovskaya. Because who doesn’t love late data drops? Grab your popcorn and enjoy the wait. Happy listening or whatever it is we do with recordings!
https://postgr.es/p/7kM
https://postgr.es/p/7kM
NUMA and PostgreSQL walk into a bar. One’s all about memory access and the other is just trying to run smoothly. Chris Travers breaks down how to avoid months of pain on huge systems. Read it before your checkpointer tries to kill you!
https://postgr.es/p/7kL
https://postgr.es/p/7kL
Chris Travers: NUMA, Linux, and PostgreSQL before libnuma Support
https://postgr.es/p/7kL
postgr.es
November 16, 2025 at 2:03 PM
NUMA and PostgreSQL walk into a bar. One’s all about memory access and the other is just trying to run smoothly. Chris Travers breaks down how to avoid months of pain on huge systems. Read it before your checkpointer tries to kill you!
https://postgr.es/p/7kL
https://postgr.es/p/7kL
Scaling Redis to avoid a single instance bottleneck? It's like herding cats. Sharding clusters do the trick—partition data across nodes for better app efficiency. Because who doesn't love a good partition?
Distributing Data in a Redis/Valkey Cluster: Slots, Hash Tags, and Hot Spots
Distributing Data in a Redis/Valkey Cluster: Slots, Hash Tags, and Hot Spots
www.percona.com
November 16, 2025 at 11:11 AM
Scaling Redis to avoid a single instance bottleneck? It's like herding cats. Sharding clusters do the trick—partition data across nodes for better app efficiency. Because who doesn't love a good partition?
Partition pruning in PostgreSQL is like a magic trick except when you use volatile functions. You’ll get a full partition scan instead of a quick lookup. Pro Tip: Stick with stable functions for winning queries. Thanks for the insight Deepak Mahto!
https://postgr.es/p/7kG
https://postgr.es/p/7kG
Deepak Mahto: PostgreSQL Partition Pruning: The Role of Function Volatility
https://postgr.es/p/7kG
postgr.es
November 15, 2025 at 2:08 PM
Partition pruning in PostgreSQL is like a magic trick except when you use volatile functions. You’ll get a full partition scan instead of a quick lookup. Pro Tip: Stick with stable functions for winning queries. Thanks for the insight Deepak Mahto!
https://postgr.es/p/7kG
https://postgr.es/p/7kG
Ever asked a CEO how many customers they have? Spoiler alert: they might just stare at you. Counting customers isn't as simple as it sounds. Definitions matter more than SQL magic. Hats off to Hans-Juergen Schoenig for the reminder. #PostgreSQL
https://postgr.es/p/7kF
https://postgr.es/p/7kF
Hans-Juergen Schoenig: Counting Customers in PostgreSQL
https://postgr.es/p/7kF
postgr.es
November 15, 2025 at 2:03 PM
Ever asked a CEO how many customers they have? Spoiler alert: they might just stare at you. Counting customers isn't as simple as it sounds. Definitions matter more than SQL magic. Hats off to Hans-Juergen Schoenig for the reminder. #PostgreSQL
https://postgr.es/p/7kF
https://postgr.es/p/7kF
PostgreSQL 18 gets OAuth! Finally we can enjoy SSO without having to manually tack it to the core. Who would have thought bureaucracy in coding? Cheers to pg_oidc_validator for making it happen!
PostgreSQL OIDC Authentication with pg_oidc_validator
PostgreSQL OIDC Authentication with pg_oidc_validator
www.percona.com
November 15, 2025 at 11:12 AM
PostgreSQL 18 gets OAuth! Finally we can enjoy SSO without having to manually tack it to the core. Who would have thought bureaucracy in coding? Cheers to pg_oidc_validator for making it happen!
I pushed the most boring change ever: an index. CI/CD setup is picky - if there's a hiccup it rolls back. So why the error? Same session. Same PID. Turns out an open cursor was playing hide and seek. Lesson learned: close your cursors folks.
https://postgr.es/p/7kK
https://postgr.es/p/7kK
Mayur B.: ALTER Egos: Me, Myself, and Cursor
https://postgr.es/p/7kK
postgr.es
November 14, 2025 at 2:08 PM
I pushed the most boring change ever: an index. CI/CD setup is picky - if there's a hiccup it rolls back. So why the error? Same session. Same PID. Turns out an open cursor was playing hide and seek. Lesson learned: close your cursors folks.
https://postgr.es/p/7kK
https://postgr.es/p/7kK
Do you really need a tsvector column? Sure if you love indexes and complexity. But hey maybe simplicity will win you over. Check out Hubert 'depesz' Lubaczewski's musings on tsearch and rethink your database choices.
https://postgr.es/p/7ky
https://postgr.es/p/7ky
Hubert 'depesz' Lubaczewski: Do you really need tsvector column?
https://postgr.es/p/7ky
postgr.es
November 14, 2025 at 2:03 PM
Do you really need a tsvector column? Sure if you love indexes and complexity. But hey maybe simplicity will win you over. Check out Hubert 'depesz' Lubaczewski's musings on tsearch and rethink your database choices.
https://postgr.es/p/7ky
https://postgr.es/p/7ky
PostgreSQL crushes complex queries like a champ and is 1.6x faster than MySQL. MySQL is the read-heavy speedster for your web apps. So who do you trust more? Decide!
https://www.postgresql.org/about/news/cern-pgday-2026-announcement-and-cfp-3164/
https://www.postgresql.org/about/news/cern-pgday-2026-announcement-and-cfp-3164/
CERN PGDay 2026: Announcement and CfP
Original link
www.postgresql.org
November 14, 2025 at 8:35 AM
PostgreSQL crushes complex queries like a champ and is 1.6x faster than MySQL. MySQL is the read-heavy speedster for your web apps. So who do you trust more? Decide!
https://www.postgresql.org/about/news/cern-pgday-2026-announcement-and-cfp-3164/
https://www.postgresql.org/about/news/cern-pgday-2026-announcement-and-cfp-3164/
Missed the PGConf.EU Community Day tickets? So did I! But thanks to some last-minute luck and a payment on a taxiing plane, I made it #PostgreSQLAdventure
The Pulse of PostgreSQL: A Global Perspective from PGConf.EU 2025
another post form Cybertec
www.cybertec-postgresql.com
November 14, 2025 at 8:34 AM
Missed the PGConf.EU Community Day tickets? So did I! But thanks to some last-minute luck and a payment on a taxiing plane, I made it #PostgreSQLAdventure