Podcast Episodes

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, 8 months 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, 8 months 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, 8 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, 8 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, 9 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, 9 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, 9 months ago

View Episode

Postgres year in review 2022

Episode 26

Here are links to a few things we mentioned: 

1. Startups building momentum

Aiven raised $210m  Timescale raised $110m  Hasura raised $100m  Supabase r…

3 years, 9 months ago

View Episode

Row estimates

Episode 25

Here are links to a few things we mentioned: 

ANALYZE (docs)Autovacuum config (docs)Statistics used by the planner (docs) CREATE STATISTICS (docs) Row…

3 years, 10 months ago

View Episode

Replication

Episode 24

Here are links to a few things we mentioned: 

Replication (docs) 9.0 release notes (including built-in replication) SlonyLondistepg_is_in_recovery (pg…

3 years, 10 months ago

View Episode