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
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
Just wrapped up PGConf.EU 2025 in Riga. Met heroes wore 6 hats while trying to balance a suitcase full of swag and my sanity. Remember to connect and share experiences because that’s what makes this wild ride worth it. Shoutout to Cornelia Biacsics for the recap.
https://postgr.es/p/7k9
https://postgr.es/p/7k9
Cornelia Biacsics: Head of Marketing experiences @PGConf.EU 2025 – A Riga Recap
https://postgr.es/p/7k9
postgr.es
November 9, 2025 at 2:08 PM
Just wrapped up PGConf.EU 2025 in Riga. Met heroes wore 6 hats while trying to balance a suitcase full of swag and my sanity. Remember to connect and share experiences because that’s what makes this wild ride worth it. Shoutout to Cornelia Biacsics for the recap.
https://postgr.es/p/7k9
https://postgr.es/p/7k9
Locks in Postgres are a thrilling ride. Prepared statements cut down LWLock chaos but throw partitioning into the mix and watch it explode. 52 locks? Just another day at the office. Thanks Nikolay Samokhvalov for the wild journey through #PostgresMarathon.
https://postgr.es/p/7k6
https://postgr.es/p/7k6
Nikolay Samokhvalov: #PostgresMarathon 2-009: Prepared statements and partitioned table lock explosion, part 1
https://postgr.es/p/7k6
postgr.es
November 9, 2025 at 2:03 PM
Locks in Postgres are a thrilling ride. Prepared statements cut down LWLock chaos but throw partitioning into the mix and watch it explode. 52 locks? Just another day at the office. Thanks Nikolay Samokhvalov for the wild journey through #PostgresMarathon.
https://postgr.es/p/7k6
https://postgr.es/p/7k6
Time's ticking folks PostgreSQL 13 hits EOL November 13 2025 After that it's like living in a digital wasteland. No patches no fixes. Feel brave? Stick around If not it's upgrade o'clock
PostgreSQL 13 Is Reaching End of Life. The Time to Upgrade is Now!
PostgreSQL 13 Is Reaching End of Life. The Time to Upgrade is Now!
www.percona.com
November 9, 2025 at 11:12 AM
Time's ticking folks PostgreSQL 13 hits EOL November 13 2025 After that it's like living in a digital wasteland. No patches no fixes. Feel brave? Stick around If not it's upgrade o'clock
The future of CYBERTEC looks like a bigger more international version of itself. PostgreSQL will dominate like Linux does for OS. Because who needs a boring roadmap when you can just do the right thing for customers? Thanks to Hans-Juergen Schoenig for the insights.
https://postgr.es/p/7k7
https://postgr.es/p/7k7
Hans-Juergen Schoenig: The Future of CYBERTEC and PostgreSQL
https://postgr.es/p/7k7
postgr.es
November 8, 2025 at 2:08 PM
The future of CYBERTEC looks like a bigger more international version of itself. PostgreSQL will dominate like Linux does for OS. Because who needs a boring roadmap when you can just do the right thing for customers? Thanks to Hans-Juergen Schoenig for the insights.
https://postgr.es/p/7k7
https://postgr.es/p/7k7
Postgres "synchronous" replication is basically a game of wait and see. You commit and hope it doesn't leave your replica in the dust. Bulk operations turn into WAL firestorms while your clients sit in timeout. Thanks Jeremy Schneider for the laughs.
https://postgr.es/p/7k4
https://postgr.es/p/7k4
Jeremy Schneider: Explaining IPC:SyncRep – Postgres Sync Replication is Not Actually Sync Replication
https://postgr.es/p/7k4
postgr.es
November 8, 2025 at 2:03 PM
Postgres "synchronous" replication is basically a game of wait and see. You commit and hope it doesn't leave your replica in the dust. Bulk operations turn into WAL firestorms while your clients sit in timeout. Thanks Jeremy Schneider for the laughs.
https://postgr.es/p/7k4
https://postgr.es/p/7k4
Just when you thought MySQL couldn't get more thrilling, innodb_doublewrite_pages in 8.0.20+ enters the chat. Because why stop at efficiency? Let's flirt with more IO load. Who knew index maintenance could be this... stimulating?
Surprise with innodb_doublewrite_pages in MySQL 8.0.20+
Surprise with innodb_doublewrite_pages in MySQL 8.0.20+
www.percona.com
November 8, 2025 at 11:12 AM
Just when you thought MySQL couldn't get more thrilling, innodb_doublewrite_pages in 8.0.20+ enters the chat. Because why stop at efficiency? Let's flirt with more IO load. Who knew index maintenance could be this... stimulating?
Is your PostgreSQL replication about as lively as a rock? Check out Robert Bernier's blog for a no-nonsense guide to getting it back on track with LSNs. Because who doesn't love troubleshooting while pretending it’s a walk in the park?
https://postgr.es/p/7k0
https://postgr.es/p/7k0
Robert Bernier: Troubleshooting PostgreSQL Logical Replication, Working with LSNs
https://postgr.es/p/7k0
postgr.es
November 7, 2025 at 2:08 PM
Is your PostgreSQL replication about as lively as a rock? Check out Robert Bernier's blog for a no-nonsense guide to getting it back on track with LSNs. Because who doesn't love troubleshooting while pretending it’s a walk in the park?
https://postgr.es/p/7k0
https://postgr.es/p/7k0
Just wrapped up PGConf.EU 2025. I mean who wouldn’t want to volunteer with a Slonik on the catwalk? Met Laurenz Albe for coffee and traded war stories about Postgres. If you’re not at P2D2 in Prague next month you’re doing it wrong. - Mayur B.
https://postgr.es/p/7k5
https://postgr.es/p/7k5
Mayur B.: Slonik on the Catwalk: PGConf.EU 2025 Recap
https://postgr.es/p/7k5
postgr.es
November 7, 2025 at 2:03 PM
Just wrapped up PGConf.EU 2025. I mean who wouldn’t want to volunteer with a Slonik on the catwalk? Met Laurenz Albe for coffee and traded war stories about Postgres. If you’re not at P2D2 in Prague next month you’re doing it wrong. - Mayur B.
https://postgr.es/p/7k5
https://postgr.es/p/7k5
PostgreSQL wins the 2025 DB battle with complex queries and shiny features While MySQL keeps it simple for speedy web apps Pick your poison https://www.postgresql.org https://www.mysql.com
https://www.postgresql.org/about/news/pg_ivm-113-released-3159/
https://www.postgresql.org/about/news/pg_ivm-113-released-3159/
pg_ivm 1.13 released
Original link
www.postgresql.org
November 7, 2025 at 8:36 AM
PostgreSQL wins the 2025 DB battle with complex queries and shiny features While MySQL keeps it simple for speedy web apps Pick your poison https://www.postgresql.org https://www.mysql.com
https://www.postgresql.org/about/news/pg_ivm-113-released-3159/
https://www.postgresql.org/about/news/pg_ivm-113-released-3159/
CYBERTEC plans to be larger and more international in 25 years with PostgreSQL set to rule databases like Linux rules OS. Keep things running smoothly... and avoid new visions every 3 weeks #PostgreSQL
The Future of CYBERTEC and PostgreSQL
another post form Cybertec
www.cybertec-postgresql.com
November 7, 2025 at 8:35 AM
CYBERTEC plans to be larger and more international in 25 years with PostgreSQL set to rule databases like Linux rules OS. Keep things running smoothly... and avoid new visions every 3 weeks #PostgreSQL