Postgres FM

A weekly podcast about all things PostgreSQL

149 episodes transcribed
0 comments
Technology

Under-indexing

Episode Date: October 27, 2023

Nikolay and Michael discuss under-indexing — how to tell if this applies to you, some general and specific cases, as well as some tricky ones...

0 comments
Technology

Over-indexing

Episode Date: October 20, 2023

Nikolay and Michael discuss over-indexing — what we mean by it, the regular issues people discuss about it, as well as a novel one Nikolay ha...

0 comments
Technology

Query hints

Episode Date: October 13, 2023

Nikolay and Michael discuss query hints — what they are, what we do and don't have in PostgreSQL, and some other things in and around the eco...

0 comments
Technology

Backups

Episode Date: September 29, 2023

Nikolay and Michael discuss Postgres backups — why we need them, what the options are, whether a dump is a backup or not, and some considerat...

0 comments
Technology

Postgres 16

Episode Date: September 22, 2023

Nikolay and Michael discuss the release of PostgreSQL 16 — the most important new features, what they mean for us as users, whether and when...

0 comments
Technology

Logical replication

Episode Date: September 15, 2023

Nikolay and Michael discuss logical replication — some history, initialization, change data capture, how to scale it, some limitiations, and...

0 comments
Technology

Connections

Episode Date: September 1, 2023

Nikolay and Michael discuss connections — the options, security and performance tradeoffs, and a few other things to be aware of. Here are so...

0 comments
Technology

Self-managing

Episode Date: August 18, 2023

Nikolay and Michael discuss self-managing Postgres — both the practicalities of doing so, as well as some managed-service style tooling.  Her...

0 comments
Technology

Sharding

Episode Date: August 11, 2023

Nikolay and Michael discuss sharding Postgres — what it means, why and when it's needed, and the available options right now.  Here are some...

0 comments
Technology

Data types

Episode Date: August 4, 2023

Nikolay and Michael discuss data types in PostgreSQL — including system types, choosing between types, types provided by extensions, and more...

0 comments
Technology

High availability

Episode Date: July 28, 2023

Nikolay and Michael discuss HA (high availability) — what it means, tools and techniques for maximising it, while going through some of the m...

0 comments
Technology

Beginner tips

Episode Date: July 21, 2023

Nikolay and Michael discuss 10 beginner tips Nikolay recently shared — they go into a bit more detail on each, and even disagree a little on...

0 comments
Technology

Connection poolers

Episode Date: July 14, 2023

Nikolay and Michael discuss Postgres connection poolers — when and why we need them, the king that is PgBouncer, and the many new pretenders...

0 comments
Technology

Anniversary mailbag

Episode Date: July 7, 2023

Nikolay and Michael celebrate the podcast's 1 year anniversary by going through several questions and suggestions received over the year. Her...

0 comments
Technology

UUID

Episode Date: June 23, 2023

Lonely Nikolay discusses the performance aspects of using UUID for primary keys. Here are links to a few things I mentioned: "postgresql" pos...

0 comments
Technology

Memory

Episode Date: June 16, 2023

Nikolay and Michael discuss memory in PostgreSQL — how it works, important settings, and how to go about tuning them. Here are links to a few...