Latest Episodes
57

Checking Vacuum, Fast Distinct Count, Group By Speed Up, Health Check | Scaling Postgres 57
In this episode of Scaling Postgres, we review articles covering checking on vacuum, how to get a fast distinct count and speed up group...
56

Practical Indexing, Vertical Scaling, Partition Migration, FDW Performance | Scaling Postgres 56
In this episode of Scaling Postgres, we review articles covering practical indexing, vertical scalability, migrating to partitions and foreign data wrapper performance. To get...
55

Replicating Data, SQL Functions, High Availability, Locking Issues | Scaling Postgres 55
In this episode of Scaling Postgres, we review articles covering methods to replicate data, SQL functions, tools for high availability and locking issues. To...
54

Index-Only Scans, Lock Table, Hot Standby Feedback, Large Backups | Scaling Postgres 54
In this episode of Scaling Postgres, we review articles covering index-only scans, locking tables, hot standby feedback and handling very large backups. To get...
53

Query Planner, BRIN Indexes, Approximate Algorithms, Delayed Replication | Scaling Postgres 53
In this episode of Scaling Postgres, we review articles covering the Postgres query planner, BRIN indexes, approximate algorithms, and the uses of delayed replication....
52

fsync Stopgap, CTE Changes, autovacuum_naptime, Postgres Community | Scaling Postgres 52
In this episode of Scaling Postgres, we review articles covering a fsync stopgap, tuning autovacuum_naptime, upcoming CTE / WITH clause changes and the Postgres...