Postgres FM

The podcast discusses the importance of BRIN indexes in Postgres and compares their performance to B-tree indexes. The concept of correlation in indexes is explored, along with the use of hidden column CTID to determine correlation. The podcast also emphasizes the need for indexes to reduce I/O operations and highlights the potential of the improved BRIN index for UID versions data. Additionally, the importance of row numbers and upgrade recommendations are discussed.

A well as discussing pros and cons, we mentioned a LOT of different providers and tools, and a few good articles/videos too. 😅Here are links to most of them, roughly in the order they came up: How Auto Trader migrated its on-prem databases to Cloud SQLPostgreSQL Community Panel: UpgradabilityPostgres TV Open TalksPostgreSQL Conference EuropeHannu Krosing — excellent vacuum talkpg_docs_bot — browser extension for getting to the current docsAmazon RDS for PostgreSQLGoogle Cloud SQL for PostgreSQLHeroku PostgresCrunchy BridgeSpilo: HA PostgreSQL Clusters with DockerAiven for PostgreSQLAlloyDB for PostgreSQLNeonYugabyteScaleGrid PostgreSQL HostingStackGresTimescaleOrioleDBCitusSupabasePlanetScalepg_stat_kcachepg_wait_samplingEDB BigAnimalAzure Database for PostgreSQL------------------------What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov and @michristofidesIf you would like to share this episode, here's a good link (and thank you!)Postgres FM is brought to you by:Nikolay Samokhvalov, founder of Postgres.aiMichael Christofides, founder of pgMustardWith special thanks to:Jessie Draws for the elephant artwork

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.