Cover Image for Killing PostgreSQL By 50,000 Parameters & A PostgreSQL 19 Whirlwind Tour
Cover Image for Killing PostgreSQL By 50,000 Parameters & A PostgreSQL 19 Whirlwind Tour
3 Went

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

Hosted by Chris Ellis & 4 others
Registration
Past Event
Welcome! To join the event, please register below.
About Event

​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

​We're proud that ClickHouse is sponsoring and helping make this event happen!

​

​Mark your calendars and come along!

​

​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

​

​WHEN

​Thursday, 12 November from 18:30.

​

​PROGRAMME

​18:30 Welcome

​19:00-19:45 Death by 50,000 Parameters: How pg_stat_statements Can Knock Over Your Patroni Cluster by Greg Clough from DRW

​19:45-20:00 Food and bar snacks

​20:00-20:30 A PostgreSQL 19 Whirlwind Tour by 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!

​

​TALKS

​

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

​Greg Clough, DRW

​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.

​

​A PostgreSQL 19 Whirlwind Tour

​Jonathan Katz, Databricks

​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.

​

​***

​

​Thanks again to ClickHouse for making this event possible.

​

​***

​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.

Location
The Star of Kings
126 York Wy, London N1 0AX, UK
We'll be in the Green Room, up the stairs to thr right of the bar.
3 Went