Killing PostgreSQL By 50,000 Parameters & A PostgreSQL 19 Whirlwind Tour

On 12 November we will be gathering again for some Postgres and a pint. We'll have the following folks presenting:

• Greg Clough from DRW with Death by 50,000 Parameters
• Jonathan Katz from Databricks with A PostgreSQL 19 Whirlwind Tour

Block your calendars and come!

We are a very informal bunch, so hoping to see you and your colleagues there!
We do need to know the numbers, so please register if you are planning on coming.

WHERE
The Star of Kings
126 York Wy, London N1 0AX
on Thursday, 12 November from 18:30.

PROGRAMME
18:30 Welcome
19:00-19:45 Greg Clough from DRW
19:45-20:00 Food and bar snacks
20:00-20:30 Jonathan Katz from Databricks
20:30 It's a pub, so we'll stay and hang out a bit longer — but feel free to leave whenever you prefer!

ABSTRACTS

Death by 50,000 Parameters: How pg_stat_statements Can Knock Over Your Patroni Cluster

Think an observability extension can’t take down high availability? Think again. We’ll break down an edge-case production post-mortem where dynamic queries with tens of thousands of parameters caused pg_stat_statements hash table saturation, exclusive lock stalls, and cascading health check timeouts in Patroni (pre-4.1.4). Learn the mechanics behind the stall and how to protect your HA topology against similar blind spots.
***
What's new in PostgreSQL 19? Quite a bit, and there's features for everyone who uses Postgres - app developers, DBAs, administrators, and more. In this presentation, we'll review new features in PostgreSQL 19, including new performance improvements that speedup reads from storage, better support property graph and bitemporal, and jsonpath queries, more OAuth capabilities, new monitoring data, and much more. We'll explore how these new capabilities build on previous PostgreSQL features, helping you understand how they fit into your daily usage.
***
THE OFFICIAL BITS
The meet-up abides by PostgreSQL Code of Conduct.
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.