Podcast Episodes
Back to Search
Toast Impact, zheap Storage, More Performance, pg_rewind Changes | Scaling Postgres 137
Episode 137
In this episode of Scaling Postgres, we discuss the impact of toast, zheap storage results, more Postgres 13 performance data and changes to pg_rewind.
To get the show notes as well as get notified o…
Published on 5 years, 1 month ago
Stat Tracking, Temporary Tables, pg_squeeze, pg_auto_failover | Scaling Postgres 136
Episode 136
In this episode of Scaling Postgres, we discuss stat tracking, temporary tables, a new utility called pg_squeeze and an update to pg_auto_failover.
To get the show notes as well as get notified of ne…
Published on 5 years, 2 months ago
Connection Scalability, Benchmarking Performance, Community Impact, zheap Progress | Scaling Postgres 135
Episode 135
In this episode of Scaling Postgres, we discuss connection scalability, benchmarking Postgres performance, the community impact of an acquisition and the progress of zheap.
To get the show notes as w…
Published on 5 years, 2 months ago
Community Acquisition, Space Saving Terabytes, WAL Archiving, Vacuum Analyze Tips | Scaling Postgres 134
Episode 134
In this episode of Scaling Postgres, we discuss a company acquisition within the Postgres community, how to save terabytes of space, setting up WAL archiving and vacuum/analyze tips.
To get the show …
Published on 5 years, 2 months ago
Postgres 13 Released, What's New In Postgres 13, Debugging PL/PGSQL, Monitoring | Scaling Postgres 133
Episode 133
In this episode of Scaling Postgres, we discuss the release of Postgres 13, what is new in Postgres 13, how to debug PL/PGSQL and Postgres monitoring best practices.
To get the show notes as well as …
Published on 5 years, 2 months ago
Postgres 13 RC1, Upgrading at Scale, With Ties, HOT Updates | Scaling Postgres 132
Episode 132
In this episode of Scaling Postgres, we discuss the release of Postgres 13 RC1, how to upgrade Postgres at scale, using limit with ties and understanding Heap Only Tuple (HOT) updates.
To get the sho…
Published on 5 years, 3 months ago
Slow Archival, Index Improvements, Node Metrics, Join or Subquery | Scaling Postgres 131
Episode 131
In this episode of Scaling Postgres, we discuss slow WAL archival, index improvements coming for Postgres 13, accessing node metrics via SQL and deciding between a join or subquery.
To get the show n…
Published on 5 years, 3 months ago
External Compression, Parallel Vacuum, JSON Aggregates, JSON & Arrays | Scaling Postgres 130
Episode 130
In this episode of Scaling Postgres, we discuss external compression, vacuuming in parallel, working with JSON Aggregates and the JSON & Array datatypes.
To get the show notes as well as get notified…
Published on 5 years, 3 months ago
28 Tips, Lucky 13, Autovacuum Tuning, Logical Pitfalls | Scaling Postgres 129
Episode 129
In this episode of Scaling Postgres, we discuss 28 tips & tricks, Postgres 13 is lucky, autovacuum tuning and logical replication pitfalls.
To get the show notes as well as get notified of new episod…
Published on 5 years, 3 months ago
Statistics Speed Up, Synchronous Commits, TLS Updates, Avoiding Cursors | Scaling Postgres 128
Episode 128
In this episode of Scaling Postgres, we discuss speeding up performance with statistics, setting synchronous_commit, updates to TLS settings and how to avoid cursors.
To get the show notes as well as…
Published on 5 years, 3 months ago