Author | Lightnews

Emeric HUNTER

Emeric HUNTER

@theemerichunter.bsky.social

10 followers 9 following 670 posts

Remote Dabatase Performance and Availability Expert for PostgreSQL & MySQL/MariaDB | I stop the bleeding and speed up your database | DBA - DBE - SRE

Posts Media Videos Starter Packs

Emeric HUNTER @theemerichunter.bsky.social · 2h

Databases going down is fun until it’s your job. PostgreSQL’s disaster recovery is like your last-minute study session the night before exams: painful but necessary. RPO RTO backups and WAL archiving save your data and sanity. Shoutout to Warda Bibi for the insights!
https://postgr.es/p/7i_

warda bibi: Understanding Disaster Recovery in PostgreSQL

https://postgr.es/p/7i_

Emeric HUNTER @theemerichunter.bsky.social · 2h

AI with Postgres isn't magic it's math folks. If you can write SQL you can build AI apps without API nightmares and Python spaghetti. Watch the webinar by Shaun Thomas to see how it's done. The future is near and it's vectorized!
https://postgr.es/p/7j0

Shaun Thomas: What's Our Vector, Victor? Building AI Apps with Postgres

https://postgr.es/p/7j0

Emeric HUNTER @theemerichunter.bsky.social · 1d

Execution 6: uses generic plan but still locks all indexes. Surprise! Execution 7: free at last just the table. Prepared statements rule but only after the 6th dance with the planner locks. Thanks Nikolay Samokhvalov for the mind-bending Postgres marathon!
https://postgr.es/p/7i-

Nikolay Samokhvalov: #PostgresMarathon 2-008: LWLock:LockManager and prepared statements

https://postgr.es/p/7i-

Emeric HUNTER @theemerichunter.bsky.social · 1d

PostgreSQL JDBC fetch size is like a buffet for your database. You can either pile everything on your plate at once or take small bites and keep your memory happy. Shane Borden proves that fetch size of 5000 is the secret sauce for 25% performance boost! Who knew?
https://postgr.es/p/7iZ

Shane Borden: Understanding and Setting PostgreSQL JDBC Fetch Size

https://postgr.es/p/7iZ

Emeric HUNTER @theemerichunter.bsky.social · 2d

Just had a marathon chat with Edd Mann about Postgres. 3.5 hours of insights on history and how tables are born. Who knew databases could be this thrilling? Check out the interviews if you're into that kind of nerdy fun.
https://postgr.es/p/7iY

Bruce Momjian: Three Interviews

https://postgr.es/p/7iY

Emeric HUNTER @theemerichunter.bsky.social · 2d

PostgreSQL is like a village everyone has a role even if you're not writing code. From DBAs to marketers we all contribute to something bigger. So if you want to go far don't go alone find your place in the PostgreSQL community. Shoutout to Cornelia Biacsics for the insight!
https://postgr.es/p/7iX

Cornelia Biacsics: The PostgreSQL Village

https://postgr.es/p/7iX

Emeric HUNTER @theemerichunter.bsky.social · 3d

PGConf.EU 2025 is next week in Riga and I'm ready to blissfully lose myself in a whirlwind of postgres geekdom. I'll be crocheting and discussing databases. Can't wait to hear Karen Sandler's keynote. Let's grab a coffee or talk about database shenanigans!
https://postgr.es/p/7iS

Karen Jex: Getting Ready for PGConf.EU 2025

https://postgr.es/p/7iS

Emeric HUNTER @theemerichunter.bsky.social · 3d

Waiting for PostgreSQL 19 is like waiting for a bus that never comes. But hey at least they're adding IGNORE NULLS/RESPECT NULLS options to window functions. Because who doesn’t love a good NULL snack? Thanks Tatsuo Ishii for the patch.
https://postgr.es/p/7iR

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 19 – Add IGNORE NULLS/RESPECT NULLS option to Window functions.

https://postgr.es/p/7iR

Emeric HUNTER @theemerichunter.bsky.social · 3d

CYBERTEC turns 25! From fax machine ink predictions to British telescopes on Spanish islands. No big vision at 22, just luck and tech love. See Hans-Jürgen's journey unfold. #PostgreSQL

How it all began - 25 years of CYBERTEC

another post form Cybertec

www.cybertec-postgresql.com

Emeric HUNTER @theemerichunter.bsky.social · 4d

Pacific Northwest? Join us Nov 6 at 6pm for Bohan Zhang from OpenAI discussing how they run Postgres like it's an Olympic sport. Spoiler: it involves scaling for millions of queries. Want to host us? We're looking for spaces. Don't be shy.
https://postgr.es/p/7iQ

Jeremy Schneider: Seattle Postgres User Group Video Library

https://postgr.es/p/7iQ

Emeric HUNTER @theemerichunter.bsky.social · 4d

Should we worry about pg_blocking_pids()'s observer effect? It might only hit you with a 10% latency bump but hey every ms counts. Perfect excuse to blame the locks right? Check out Nikolay Samokhvalov's insights at #PostgresMarathon.
https://postgr.es/p/7iW

Nikolay Samokhvalov: #PostgresMarathon 2-007: Should we worry about pg_blocking_pids()'s observer effect?

https://postgr.es/p/7iW

Emeric HUNTER @theemerichunter.bsky.social · 5d

Ever thought JIT compilers were faster than interpreters? Think again. Modern CPUs play dirty with out-of-order execution and branch prediction. Performance gains? Maybe just a pipedream. Check out Pierre Ducroquet's insights on the PostgreSQL JIT saga.
https://postgr.es/p/7iP

Pierre Ducroquet: JIT: so you want to be faster than an interpreter on modern CPUs…

https://postgr.es/p/7iP

Emeric HUNTER @theemerichunter.bsky.social · 5d

Just tested sparql_fdw with PostgreSQL 18. Surprise surprise it works like a charm. RIP PostgreSQL 12 you’re officially outta here! Time to embrace the future with some solid SPARQL action. Thanks Stefanie Janine for the awesome wrapper
https://postgr.es/p/7iO

Stefanie Janine: sparql_fdw Foreign Data Wrapper Tested Against PostgreSQL 18

https://postgr.es/p/7iO

Emeric HUNTER @theemerichunter.bsky.social · 5d

Postgres 18 is out and it’s not the biggest leap we’ve seen but it has some spicy updates like async I/O and UUIDv7 support. Time to boost your db performance. Grab the release notes and let’s dive in.

Postgres 18 released

postgresweekly.com

Emeric HUNTER @theemerichunter.bsky.social · 5d

Watch out PMM 3.x users there's a vulnerability lurking around and it's not shy. Looks like we've got a CVE mystery on our hands time to patch up before your data takes a dive. Better safe than sorry right

Security Advisory: CVE Affecting Percona Monitoring and Management (PMM)

Security Advisory: CVE Affecting Percona Monitoring and Management (PMM)

www.percona.com

Emeric HUNTER @theemerichunter.bsky.social · 6d

Hungry for connection? Join the Postgres Women Breakfast at PGConf.EU 2025 in Riga. Limited seats so don’t be late to the buffet of networking. Grab your spot now. Thanks Karen Jex for the invite.
https://postgr.es/p/7iL

Karen Jex: PGConf.EU 2025 - Join us for a Postgres Women Breakfast

https://postgr.es/p/7iL

Emeric HUNTER @theemerichunter.bsky.social · 6d

Kicking off a blog series on PostGIS performance. Did you know a spatial join can take 2200ms when a simple index could make it fly at 200ms? Just a little indexing can save you from a million intersection tests! Thanks Paul Ramsey for the insights.
https://postgr.es/p/7iM

Paul Ramsey: PostGIS Performance: Indexing and EXPLAIN

https://postgr.es/p/7iM

Emeric HUNTER @theemerichunter.bsky.social · 6d

PostgreSQL crushes complex queries like a boss while MySQL is chilling in the read-heavy lane. Choose: analytics powerhouse or speedy web-app buddy? Your call!
https://www.postgresql.org/about/news/pg_builder-32-and-pg_wrapper-33-released-with-support-for-postgres-18-3152/

pg_builder 3.2 and pg_wrapper 3.3 released with support for Postgres 18

www.postgresql.org

Emeric HUNTER @theemerichunter.bsky.social · 6d

Rust meets PostgreSQL with a twist of etcd! Dive into the world of Foreign Data Wrappers and turn your tables into distributed key-value ninjas. It’s like Postgres but on, caffeine #etcd

Bringing etcd to the database with Rust and pgrx

another post form Cybertec

www.cybertec-postgresql.com

Emeric HUNTER @theemerichunter.bsky.social · 7d

Just had a PostgreSQL query that took 10 mins finish in 20 sec after running ANALYZE. CPU went from 80% to 10%. Moral of the story: ignoring stats is like skipping cardio – your database will feel the burn. Thanks for the lesson Semab Tariq.
https://postgr.es/p/7iK

semab tariq: Don’t Skip ANALYZE: A Real-World PostgreSQL Story

https://postgr.es/p/7iK

Emeric HUNTER @theemerichunter.bsky.social · 7d

Ever tried to decipher max_locks_per_transaction? One moment you're feeling wise the next you're confronted with an "out of shared memory" error. Thanks PostgreSQL. Just remember you can lock more than you think. Apologies to Socrates for this mess. - Nikolay Samokhvalov
https://postgr.es/p/7iN

Nikolay Samokhvalov: #PostgresMarathon 2-006: Mysterious max_locks_per_transaction

https://postgr.es/p/7iN

Emeric HUNTER @theemerichunter.bsky.social · 8d

PGConf NYC 2025 is a wrap. Thanks to the organizers volunteers and speakers for making it happen. Big shoutout to my fellow lightning talkers. Wait did you see the list of names? Almost as long as my patience during database recovery.
https://postgr.es/p/7iI

Boriss Mejias: Contributions for week 40, 2025

https://postgr.es/p/7iI

Emeric HUNTER @theemerichunter.bsky.social · 8d

Just upgraded PostgreSQL with CloudNativePG. Minor upgrades? Easy peasy just change the image. Major upgrades? Well hold my pints and pray for a good backup. Read more from Umut TEKIN on making upgrades almost fun at Cybertec.
https://postgr.es/p/7iH

Umut TEKIN: Exploration: CNPG PostgreSQL Upgrade

https://postgr.es/p/7iH

Emeric HUNTER @theemerichunter.bsky.social · 8d

Debating between PostgreSQL and MySQL in 2025? PostgreSQL handles complex queries & is built for the big leagues while MySQL is your go-to for speed & simplicity. Do you even lift bro? #DatabaseTalk
https://www.postgresql.org/about/news/prague-postgresql-developer-day-2026-january-27-28-3151/

Prague PostgreSQL Developer Day 2026 / January 27-28

www.postgresql.org

Emeric HUNTER @theemerichunter.bsky.social · 9d

Just discovered Titanic passenger data in a GitHub repo. It's like sailing into a CSV iceberg. Time to show off my ETL skills with DBeaver. Thanks to Ryan Booz for the ELT inspiration. Stay tuned for part 2! Original post by Dave Stokes.
https://postgr.es/p/7iC

Dave Stokes: Loading The Titanic Passenger Data Into PostgreSQL With DBeaver Part 1

https://postgr.es/p/7iC