# max_connections vs migrations

Page: https://stenobird.com/podcast/postgres-fm-5565051/max-connections-vs-migrations
Text version: https://stenobird.com/podcast/postgres-fm-5565051/max-connections-vs-migrations.md
Podcast: [Postgres FM](https://stenobird.com/podcast/postgres-fm-5565051)
Published: 2025-12-05T14:00:00+00:00
Episode link: https://share.transistor.fm/s/633a85e4
Audio file: https://media.transistor.fm/633a85e4/df289071.mp3
Processing state: not_requested
JSON: https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/max-connections-vs-migrations
Duration seconds: 2680

## Resource

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

## Actions

- request_transcript: `POST https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/max-connections-vs-migrations/transcription-requests` — Idempotently request low-priority transcript generation for this episode.
- read_markdown: `GET https://stenobird.com/podcast/postgres-fm-5565051/max-connections-vs-migrations.md` — Read the agent-friendly Markdown representation of this episode resource.

A page view does not enqueue transcription. Agents should invoke `request_transcript` explicitly when they need this episode processed.

## Transcript

Full transcripts are not published on public pages unless there is a clear rights basis.