Episode 166
max_connections vs migrations
Postgres FM · Nikolay Samokhvalov and Michael Christofides
December 5, 202544m 40s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!)
Here are some links to things they mentioned:
- max_connections https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-MAX-CONNECTIONS
- Tweet about deployments vs connections issue https://x.com/brankopetric00/status/1991394329886077090
- Nik tweet in response https://x.com/samokhvalov/status/1991465573684027443
- Analyzing the Limits of Connection Scalability in Postgres (blog post by Andres Freund) https://www.citusdata.com/blog/2020/10/08/analyzing-connection-scalability/
- Exponential Backoff And Jitter (blog post by Marc Brooker) https://aws.amazon.com/blogs/architecture/exponential-backoff-and-jitter/
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With credit to:
- Jessie Draws for the elephant artwork
Topics
PostgresPostgreSQLDatabasesSQLtechnology