Podcast Episodes
Back to SearchAuditing
Episode 29
Here are links to a few things we mentioned:
Crunchy Data PostgreSQL Security Technical Implementation Guide (STIG)pgAudit (site)pgAudit (repo)noset …2 years, 11 months ago
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 ago
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 ago
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 ago
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 ago
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, 1 month ago
Timestamps
Episode 23
Here are links to a few things we mentioned:
Date/Time Types (docs) Don’t use timestamp without time zone (wiki) Date/Time functions and operators (…3 years, 1 month ago
PostgREST
Episode 22
Here are links to a few things we mentioned:
PostgREST documentationSupabaseNo offset (blog post by Markus Winand)JSON functions and operators (Postg…3 years, 1 month ago
Materialized views
Episode 21
Apologies, Michael's audio is not great in this, we'll hopefully be back to normal next week!
Here are links to a few things we mentioned:
Materialize…3 years, 1 month ago
HOT updates
Episode 20
Here are links to a few things we mentioned:
Heap-only tuple updates (docs)README file (source code)Heap Only Tuple chapter (Internals of PostgreSQL …3 years, 1 month ago