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/

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 get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/128-statistics-speed-up-synchronous-commits-tls-updates-avoiding-cursors/

In this episode of Scaling Postgres, we discuss recursive queries, using lateral joins, paging through a data sets efficiently and working with JSONB arrays. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/127-recursive-queries-lateral-joins-pagination-jsonb-arrays/

In this episode of Scaling Postgres, we discuss BRIN pitfalls, using pg_stat_statements for troubleshooting, natural joins to detect duplicates and the geography type. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/126-brin-pitfalls-pg_stat_statement-troubleshooting-natural-join-geography-type/

In this episode of Scaling Postgres, we discuss suggestions for scaling postgres, replication slots safety, implementing scram password authentication with channel binding and setting effective_cache_size. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/125-scaling-suggestions-slot-safety-scram-channel-binding-effective-cache-size/

In this episode of Scaling Postgres, we discuss how best to migrate to using partitions, like & ilike performance, determining the best fillfactor and the work towards in-memory tables. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/124-partition-migration-like-performance-best-fillfactor-in-memory-tables/

In this episode of Scaling Postgres, we discuss working with JSONB types, calculating earth distance, utilizing dates, times & intervals and Postgres authentication. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/123-jsonb-types-earth-distance-dates-times-intervals-authentication/

In this episode of Scaling Postgres, we discuss determining if Postgres is fine, generated columns vs. triggers, insert features and synchronous replication usage. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/122-postgres-is-fine-generated-columns-postgres-inserts-synchronous-replication/

In this episode of Scaling Postgres, we discuss fantastic data types, custom domain data types, improving insert performance and how to query row differences. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/121-fantastic-data-types-domain-data-types-insert-performance-row-differences/

In this episode of Scaling Postgres, we discuss Postgres 13 Beta 2, a system stats extension, tuning your operating systems for Postgres and different join strategies. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/120-postgres13-beta2-system-stats-extension-tuned-join-strategy/

In this episode of Scaling Postgres, we discuss replication complications, adding one word to boost performance, handling pgbouncer users and serializable isolation testing. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/119-replication-complication-one-word-performance-pgbouncer-users-serializable-isolation/

In this episode of Scaling Postgres, we discuss safety systems, the purpose and existence of failover slots, complications with transaction IDs and how to repartition without downtime. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/118-safety-systems-failover-slots-transaction-id-complications-repartitioning/

In this episode of Scaling Postgres, we discuss index deduplication in Postgres 13, fast hierarchical access, more essential monitoring and cloud native Postgres. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/117-index-deduplication-fast-hierarchy-more-monitoring-cloud-native/

In this episode of Scaling Postgres, we discuss the observer effect with explain analyze, partition management, tuple freezing and sources of hung transactions. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/116-observer-effect-partition-management-tuple-freezing-hung-transactions/

In this episode of Scaling Postgres, we discuss PGCon going online, application performance tips, ways to track counts and essential areas to monitor. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/115-pgcon-online-performance-tips-tracking-counts-essential-monitoring/

In this episode of Scaling Postgres, we discuss the Postgres data directory, new vacuum features, binary storage performance and the impact of network latency. To get the show notes as well as get notified of new episodes, visit:  https://www.scalingpostgres.com/episodes/114-data-directory-vacuum-features-binary-performance-network-latency/