Podcast Episodes

Wait events

Episode 36

Nikolay and Michael discuss wait events — what they are, why we have them, and how to use them to help diagnose performance issues.
 
Here are links to…

3 years ago

View Episode

TOAST

Episode 35

Nikolay and Michael discuss TOAST (The Oversized-Attribute Storage Technique) — what it is, how it works, and some general things to be aware of.
 
Her…

3 years, 1 month ago

View Episode

JSON

Episode 34

Nikolay and Michael discuss JSON — our options for storing it in Postgres, whether or when we should, as well as a brief intro and some tips for JSON…

3 years, 1 month ago

View Episode

Real-time analytics

Episode 33

Nikolay and Michael discuss real-time analytics — what it means, what the options are, and some tips if you're trying to implement it within Postgres…

3 years, 1 month ago

View Episode

Benchmarking

Episode 32

Nikolay and Michael discuss benchmarking — reasons to do it, and some approaches, tools, and resources that can help.
 
Here are links to a few things …

3 years, 1 month ago

View Episode

Default configuration

Episode 31

Nikolay and Michael discuss the default config — some tools and principles you can use to customise it, as well as several parameters you probably al…

3 years, 2 months ago

View Episode

Infra cost optimization

Episode 30

Here are links to a few things we mentioned: 

The Cost of Cloud, a Trillion Dollar Paradox (blog post from Andreessen Horowitz)OVHHetznerpostgresql_cl…

3 years, 2 months ago

View Episode

Auditing

Episode 29

Here are links to a few things we mentioned: 

Crunchy Data PostgreSQL Security Technical Implementation Guide (STIG)pgAudit (site)pgAudit (repo)noset …

3 years, 2 months ago

View Episode

Copying a database

Episode 28

Here are links to a few things we mentioned: 

pg_dump pg_restore  pgcopydb (tool by Dimitri Fontaine)  pg_dump and external snapshots (blog post by Mi…

3 years, 2 months ago

View Episode

Transaction ID wraparound

Episode 27

Here are links to a few things we mentioned: 

The Internals of PostgreSQL chapter 5 (book by Hironobu SUZUKI) PostgreSQL 14 internals chapter 7 (book …

3 years, 2 months ago

View Episode