Podcast Episodes

Under-indexing

Episode 69

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. 
 
Here …

2 years, 2 months ago

View Episode

Over-indexing

Episode 68

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 has come a…

2 years, 2 months ago

View Episode

Query hints

Episode 67

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 ecosystem t…

2 years, 3 months ago

View Episode

Stop and start Postgres faster

Episode 66

In this episode (recorded live on YouTube), Nikolay discusses Postgres shutdown and startup times – how to troubleshoot them and, when needed, optimi…

2 years, 3 months ago

View Episode

Backups

Episode 65

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

2 years, 3 months ago

View Episode

Postgres 16

Episode 64

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

2 years, 3 months ago

View Episode

Logical replication

Episode 63

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

2 years, 4 months ago

View Episode

Our favourite v16 feature

Episode 62

Nikolay and Michael discuss their favourite feature each from the upcoming PostgreSQL 16 release.
 
Here are some links to some things they mentioned:

v…

2 years, 4 months ago

View Episode

Connections

Episode 61

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

2 years, 4 months ago

View Episode

Decoupled storage and compute

Episode 60

Nikolay and Michael discuss a listener question — about products that take Postgres and transform it to something that decouples compute from storage…

2 years, 4 months ago

View Episode