Menu

PostgreSQL 19 new features that change your monitoring queries (tested on RC 1)
📰

PostgreSQL 19 new features that change your monitoring queries (tested on RC 1)

DEV Community: postgres·Vladimir Chemeris·11 days ago
#OxEfMxWD
#devtopostgresql#devto#dev#postgresql#enter
Reading 0:00
15s threshold

I build HeapDeck , an iPhone and iPad app for Postgres on call. You won't need it here: the checks below run in psql , and they apply to any script or dashboard that reads pg_stat_* .

PostgreSQL 19 is due November 19. I ran my app's live test matrix against RC 1 ahead of it: 1,208 scenarios across PostgreSQL 13 to 19. Two needed a rewrite, both because of one server change. The change that worries me most for other people's dashboards produces no error.

An alert that goes quiet

PostgreSQL 19 moves buffer pin waits from the wait_event_type BufferPin to Buffer , and the event itself becomes BufferCleanup . A query that filters on the old name still runs and returns no rows.

You can see it in a few minutes.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.