Listen to a podcast, please open Podcast Republic app. Available on Google Play Store and Apple App Store.
Episode | Date |
---|---|
Buffers II (the sequel)
|
Apr 26, 2024 |
Massive DELETEs
|
Apr 19, 2024 |
Logical replication common issues
|
Apr 12, 2024 |
Don't do this
|
Apr 05, 2024 |
Search
|
Mar 29, 2024 |
Health check
|
Mar 22, 2024 |
superuser
|
Mar 15, 2024 |
transaction_timeout
|
Mar 08, 2024 |
Rails + Postgres
|
Mar 01, 2024 |
Why isn't Postgres using my index?
|
Feb 23, 2024 |
Overhead of pg_stat_statements and pg_stat_kcache
|
Feb 16, 2024 |
Modern SQL
|
Feb 02, 2024 |
Bloat
|
Jan 26, 2024 |
pgvector
|
Jan 19, 2024 |
pgBadger
|
Jan 12, 2024 |
EXPLAIN
|
Jan 05, 2024 |
work_mem
|
Dec 31, 2023 |
Partitioning by ULID
|
Dec 22, 2023 |
Hash indexes
|
Dec 15, 2023 |
Constraints
|
Dec 08, 2023 |
Events
|
Dec 01, 2023 |
Subtransactions
|
Nov 24, 2023 |
Companion databases
|
Nov 17, 2023 |
Blue-green deployments
|
Nov 10, 2023 |
Data model trade-offs
|
Nov 03, 2023 |
Under-indexing
|
Oct 27, 2023 |
Over-indexing
|
Oct 20, 2023 |
Query hints
|
Oct 13, 2023 |
Stop and start Postgres faster
|
Oct 07, 2023 |
Backups
|
Sep 29, 2023 |
Postgres 16
|
Sep 22, 2023 |
Logical replication
|
Sep 15, 2023 |
Our favourite v16 feature
|
Sep 08, 2023 |
Connections
|
Sep 01, 2023 |
Decoupled storage and compute
|
Aug 25, 2023 |
Self-managing
|
Aug 18, 2023 |
Sharding
|
Aug 11, 2023 |
Data types
|
Aug 04, 2023 |
High availability
|
Jul 28, 2023 |
Beginner tips
|
Jul 21, 2023 |
Connection poolers
|
Jul 14, 2023 |
Anniversary mailbag
|
Jul 07, 2023 |
pg_upgrade: the tricky and dangerous parts
|
Jun 30, 2023 |
UUID
|
Jun 23, 2023 |
Memory
|
Jun 16, 2023 |
Extensions
|
Jun 09, 2023 |
Zero-downtime migrations
|
Jun 02, 2023 |
Parallelism
|
May 26, 2023 |
Corruption
|
May 19, 2023 |
ChatGPT x
PostgreSQL
|
May 12, 2023 |
pg_stat_statements
|
May 05, 2023 |
auto_explain
|
Apr 28, 2023 |
Queues in Postgres
|
Apr 21, 2023 |
Read-only considerations
|
Apr 14, 2023 |
Partitioning
|
Apr 07, 2023 |
Peter Zaitsev
|
Mar 31, 2023 |
psql vs GUIs
|
Mar 24, 2023 |
Upgrades
|
Mar 17, 2023 |
Wait events
|
Mar 10, 2023 |
TOAST
|
Mar 03, 2023 |
JSON
|
Feb 24, 2023 |
Real-time analytics
|
Feb 17, 2023 |
Benchmarking
|
Feb 10, 2023 |
Default configuration
|
Feb 03, 2023 |
Infra cost optimization
|
Jan 27, 2023 |
Auditing
|
Jan 20, 2023 |
Copying a database
|
Jan 13, 2023 |
Transaction ID wraparound
|
Jan 06, 2023 |
Postgres year in review 2022
|
Dec 30, 2022 |
Row estimates
|
Dec 23, 2022 |
Replication
|
Dec 16, 2022 |
Timestamps
|
Dec 09, 2022 |
PostgREST
|
Dec 02, 2022 |
Materialized views
|
Nov 25, 2022 |
HOT updates
|
Nov 18, 2022 |
Database branching
|
Nov 11, 2022 |
Version control for databases
|
Nov 04, 2022 |
Contributing to Postgres
|
Oct 28, 2022 |
Stored procedures
|
Oct 21, 2022 |
PostgreSQL 15
|
Oct 14, 2022 |
102 Query optimization
|
Oct 07, 2022 |
Why is Postgres popular?
|
Sep 30, 2022 |
Index maintenance
|
Sep 23, 2022 |
Query macro analysis intro
|
Sep 16, 2022 |
WAL and checkpoint tuning
|
Sep 09, 2022 |
Intro to query optimization
|
Sep 02, 2022 |
How to become a DBA
|
Aug 26, 2022 |
Monitoring checklist
|
Aug 19, 2022 |
Vacuum
|
Aug 12, 2022 |
NULLs: the good, the bad, the ugly, and the unknown
|
Aug 05, 2022 |
BUFFERS by default
|
Jul 29, 2022 |
BRIN indexes
|
Jul 21, 2022 |
Managed services vs. DIY
|
Jul 14, 2022 |
Slow queries and slow transactions
|
Jul 05, 2022 |