Scaling Postgres

In this episode of Scaling Postgres, we discuss scaling connections, the release of TimescaleDB 2.0, how to find time-series gaps and monitoring RED & Golden signals.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/138-scaling-connections-timescaledb-time-series-gaps-red-golden-signals/

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 of new episodes, visit: 

https://www.scalingpostgres.com/episodes/137-toast-impact-zheap-storage-more-performance-pg_rewind_changes/

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 new episodes, visit: 

https://www.scalingpostgres.com/episodes/136-stat-tracking-temporary-tables-pg_squeeze-pg_auto_failover/

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 well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/135-connection-scalability-benchmarking-performance-community-impact-zheap-progress/

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 notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/134-community-acquisition-space-saving-terabytes-wal-archiving-vacuum-analyze-tips/

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 get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/133-postgres-13-released-what-is-new-in-postgres-13-debugging-plpgsql-monitoring/

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 show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/132-postgres-13-rc1-upgrading-at-scale-with-ties-hot-updates/

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 notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/131-slow-archival-index-improvements-node-metrics-join-subquery/

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 of new episodes, visit: 

https://www.scalingpostgres.com/episodes/130-external-compression-parallel-vacuum-json-aggregates-json-arrays/

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 episodes, visit: 

https://www.scalingpostgres.com/episodes/129-28-tips-lucky-13-autovacuum-tuning-logical-pitfalls/