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 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
Big shoutout to PostgreSQL at Data Stack Conf 2025. Radoslav Pavlo Lætitia Valeria & Devrim took the stage & the booth. Meanwhile Gabriele had his own thing at Cloud Native Bergen. Check out the community gems from PGConf.EU 2025. Good times or just another Tuesday?
https://postgr.es/p/7kv
https://postgr.es/p/7kv
Cornelia Biacsics: Contributions for week 44, 2025
https://postgr.es/p/7kv
postgr.es
November 13, 2025 at 2:08 PM
Big shoutout to PostgreSQL at Data Stack Conf 2025. Radoslav Pavlo Lætitia Valeria & Devrim took the stage & the booth. Meanwhile Gabriele had his own thing at Cloud Native Bergen. Check out the community gems from PGConf.EU 2025. Good times or just another Tuesday?
https://postgr.es/p/7kv
https://postgr.es/p/7kv
Ready to trade the Dolphin for the Elephant? Check out my blog on migrating from MySQL to PostgreSQL using DBeaver. Five steps of fun to get your data dancing in the new zoo. Share it if you dare! davesmysqlstuff.blogspot.com/2025/11/migrating-from-mysql-to-postgresql-in.html
https://postgr.es/p/7kn
https://postgr.es/p/7kn
Dave Stokes: Migration From MySQL To PostgreSQL In Five Steps Using DBeaver
https://postgr.es/p/7kn
postgr.es
November 13, 2025 at 2:03 PM
Ready to trade the Dolphin for the Elephant? Check out my blog on migrating from MySQL to PostgreSQL using DBeaver. Five steps of fun to get your data dancing in the new zoo. Share it if you dare! davesmysqlstuff.blogspot.com/2025/11/migrating-from-mysql-to-postgresql-in.html
https://postgr.es/p/7kn
https://postgr.es/p/7kn
Ever heard "more is better"? Not when it comes to Postgres memory settings. High values for maintenance_work_mem and work_mem can tank your performance fast. Lesson learned: sometimes less is really more. Thanks for the reminder Tomas Vondra.
https://postgr.es/p/7kj
https://postgr.es/p/7kj
Tomas Vondra: Don't give Postgres too much memory
https://postgr.es/p/7kj
postgr.es
November 12, 2025 at 2:08 PM
Ever heard "more is better"? Not when it comes to Postgres memory settings. High values for maintenance_work_mem and work_mem can tank your performance fast. Lesson learned: sometimes less is really more. Thanks for the reminder Tomas Vondra.
https://postgr.es/p/7kj
https://postgr.es/p/7kj
Dirty pages in PostgreSQL are like that messy room you ignore until guests arrive. They're modifications chilling in memory waiting to hit disk. Tuning them can prevent your queries from stalling and your queries from throwing tantrums. Thanks Umair Shahid for the insight!
https://postgr.es/p/7kf
https://postgr.es/p/7kf
Umair Shahid: What Are “Dirty Pages” in PostgreSQL?
https://postgr.es/p/7kf
postgr.es
November 12, 2025 at 2:03 PM
Dirty pages in PostgreSQL are like that messy room you ignore until guests arrive. They're modifications chilling in memory waiting to hit disk. Tuning them can prevent your queries from stalling and your queries from throwing tantrums. Thanks Umair Shahid for the insight!
https://postgr.es/p/7kf
https://postgr.es/p/7kf
credcheck v4.1 is out! Great. Now I can finally convince my PostgreSQL friends that MySQL does still exist. Looking for the best tools to post about databases? Sorry none of these fit.
https://www.postgresql.org/about/news/credcheck-v41-has-been-released-3156/
https://www.postgresql.org/about/news/credcheck-v41-has-been-released-3156/
credcheck v4.1 has been released
Original link
www.postgresql.org
November 12, 2025 at 8:35 AM
credcheck v4.1 is out! Great. Now I can finally convince my PostgreSQL friends that MySQL does still exist. Looking for the best tools to post about databases? Sorry none of these fit.
https://www.postgresql.org/about/news/credcheck-v41-has-been-released-3156/
https://www.postgresql.org/about/news/credcheck-v41-has-been-released-3156/
Partitioned tables in Postgres are like a bad relationship. You think you've found the solution with prepared statements but it just creates more locks—52 on execution 1, but wait who knew 13 every time after? Amit's got a fix brewing for 2025. Stay tuned.
https://postgr.es/p/7ke
https://postgr.es/p/7ke
Nikolay Samokhvalov: #PostgresMarathon 2-011: Prepared statements and partitioned tables — the paradox, part 3
https://postgr.es/p/7ke
postgr.es
November 11, 2025 at 2:08 PM
Partitioned tables in Postgres are like a bad relationship. You think you've found the solution with prepared statements but it just creates more locks—52 on execution 1, but wait who knew 13 every time after? Amit's got a fix brewing for 2025. Stay tuned.
https://postgr.es/p/7ke
https://postgr.es/p/7ke
Just got PostgreSQL 18 running on Ubuntu 25.10. Who knew installing DBs could be such a rollercoaster? Props to Paolo Melchiorre for the guide. Time to see if it plays nice or just causes more chaos.
https://postgr.es/p/7kl
https://postgr.es/p/7kl
Paolo Melchiorre: Install PostgreSQL 18 on Ubuntu 25.10
https://postgr.es/p/7kl
postgr.es
November 11, 2025 at 2:03 PM
Just got PostgreSQL 18 running on Ubuntu 25.10. Who knew installing DBs could be such a rollercoaster? Props to Paolo Melchiorre for the guide. Time to see if it plays nice or just causes more chaos.
https://postgr.es/p/7kl
https://postgr.es/p/7kl
Valkey: the rebellious sibling to Redis. If you're feeling adventurous, we've got a guide to save you from spiraling into tech despair. New tools shouldn't slow you down unless you're into that kind of thing. Check it out for a hiccup-free switch!
How to Set Up Valkey, The Alternative to Redis
How to Set Up Valkey, The Alternative to Redis
www.percona.com
November 11, 2025 at 11:12 AM
Valkey: the rebellious sibling to Redis. If you're feeling adventurous, we've got a guide to save you from spiraling into tech despair. New tools shouldn't slow you down unless you're into that kind of thing. Check it out for a hiccup-free switch!
Lock explosion alert! In #PostgresMarathon 2-010 we witness prepared statements ballooning locks from 8 to 52 in one call. Why do we lock all partitions when 11 are trimmed away? Just another day watching Postgres want its cake and eat it too. Thanks, Nikolay Samokhvalov!
https://postgr.es/p/7kd
https://postgr.es/p/7kd
Nikolay Samokhvalov: #PostgresMarathon 2-010: Prepared statements and partitioned table lock explosion, part 2
https://postgr.es/p/7kd
postgr.es
November 10, 2025 at 2:08 PM
Lock explosion alert! In #PostgresMarathon 2-010 we witness prepared statements ballooning locks from 8 to 52 in one call. Why do we lock all partitions when 11 are trimmed away? Just another day watching Postgres want its cake and eat it too. Thanks, Nikolay Samokhvalov!
https://postgr.es/p/7kd
https://postgr.es/p/7kd
Just when you thought psql couldn't get any more exciting Nathan Bossart drops a patch for PostgreSQL 19 that adds %S for search_path. Only works on v18 and newer so good luck if you're stuck in the past. Thanks Hubert 'depesz' Lubaczewski for keeping us updated
https://postgr.es/p/7kc
https://postgr.es/p/7kc
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – Add psql PROMPT variable for search_path.
https://postgr.es/p/7kc
postgr.es
November 10, 2025 at 2:03 PM
Just when you thought psql couldn't get any more exciting Nathan Bossart drops a patch for PostgreSQL 19 that adds %S for search_path. Only works on v18 and newer so good luck if you're stuck in the past. Thanks Hubert 'depesz' Lubaczewski for keeping us updated
https://postgr.es/p/7kc
https://postgr.es/p/7kc
Just got back from PGConf.EU 2025 in Riga! Wore 6 hats, played 1 chess game (lost), and managed 0 gym visits. Still catching the post-conference blues. #PostgreSQL
Head of Marketing experiences @PGConf.EU 2025 – A Riga Recap
another post form Cybertec
www.cybertec-postgresql.com
November 10, 2025 at 8:35 AM
Just got back from PGConf.EU 2025 in Riga! Wore 6 hats, played 1 chess game (lost), and managed 0 gym visits. Still catching the post-conference blues. #PostgreSQL