Postgres FM

Slow queries and slow transactions

Jul 5, 2022
The hosts discuss the importance of performance in Postgres, including slow queries and slow transactions. They emphasize the need for monitoring long transactions and transaction ID wraparound, as well as setting timeouts to prevent issues and degradation. They also highlight the benefits of setting statement timeouts in PostgreSQL for operations like big data migration or schema changes.
Ask episode
Chapters
Transcript
Episode notes