Latest Episodes
114
Data Directory, Vacuum Features, Binary Performance, Network Latency | Scaling Postgres 114
In this episode of Scaling Postgres, we discuss the Postgres data directory, new vacuum features, binary storage performance and the impact of network latency....
113
arm64 with apt, Contributors, Backup Manifest, Now Functions | Scaling Postgres 113
In this episode of Scaling Postgres, we discuss arm64 package support for apt, annual Postgres contributors, backup manifests & verifications and different now functions....
112
Explain Analyze, Sequence Counts, Best Books, Partition Migration | Scaling Postgres 112
In this episode of Scaling Postgres, we discuss how to use explain analyze, the problem with counting sequences, the best books to learn Postgres...
111
Insert-Only Vacuum, Settings, Sequence Replication, Improvements | Scaling Postgres 111
In this episode of Scaling Postgres, we discuss insert-only vacuums, the Postgres settings hierarchy, sequence replication and desired improvements. To get the show notes...
110
Max Connections, SQL Tricks, Fast Text Search, Security & Compliance | Scaling Postgres 110
In this episode of Scaling Postgres, we discuss tuning max connections, different SQL tricks, setting up fast text search and handling security & compliance....
109
Show Plans, WAL Monitoring, Using UUIDs, Default Logging | Scaling Postgres 109
In this episode of Scaling Postgres, we discuss how to show live plans, how Postgres 13 allows WAL monitoring, how to use UUIDs in...