Scaling Postgres

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/

In this episode of Scaling Postgres, we discuss arm64 package support for apt, annual Postgres contributors, backup manifests & verifications and different now functions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/113-arm64-with-apt-contributors-backup-manifest-now-functions/

In this episode of Scaling Postgres, we discuss how to use explain analyze, the problem with counting sequences, the best books to learn Postgres and how to migrate to declarative partitioning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/112-explain-analyze-sequence-counts-best-books-partition-migration/

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 as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/111-insert-only-vacuum-settings-sequence-replication-improvements/

In this episode of Scaling Postgres, we discuss tuning max connections, different SQL tricks, setting up fast text search and handling security & compliance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/110-max-connections-sql-tricks-fast-text-search-security-compliance/

In this episode of Scaling Postgres, we discuss how to show live plans, how Postgres 13 allows WAL monitoring, how to use UUIDs in your app and how logging is setup by default. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/109-show-plans-wal-monitoring-using-uuids-default-logging/

In this episode of Scaling Postgres, we discuss ten things to hate about Postgres, audit trigger performance, designing a schema and the future of high availability. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/108-ten-things-audit-triggers-schema-design-high-availability/

In this episode of Scaling Postgres, we discuss how to show live query plans, the importance of atomic operations for scaling out, configuration options and DBaaS migrations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/107-showing-plans-atomic-configuration-migrations/

In this episode of Scaling Postgres, we discuss how to use recursive CTEs, database access patterns, using dates and times and how to cluster your data. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/106-recursive-cte-db-access-patterns-dates-times-cluster/

In this episode of Scaling Postgres, we discuss how Postgres is the world's best database, performance ramifications of subtransactions, the current state of sharding and safe schema changes. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/105-worlds-best-subtransactions-sharding-schema-changes/

In this episode of Scaling Postgres, we discuss how to reduce the size of your WAL files, what is null, how to better understand SQL and exploring TPC-H benchmarks. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/104-reducing-wal-what-is-null-understanding-sql-tpc-h-benchmarking/

In this episode of Scaling Postgres, we discuss how to scale out, how the planner estimates, uses of create statistics and investigating PostgreSQL run time environments. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/103-scaling-out-planner-estimation-create-statistics-stay-curious/

In this episode of Scaling Postgres, we discuss the use cases for UUIDs, using pg_settings, setting up an automated restore and the future of parallelism. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/102-uuid-use-cases-pg-settings-automated-restore-parallel-future/

In this episode of Scaling Postgres, we discuss new postgres releases, useless vacuuming, isolation differences between databases, and different ways to compress WAL files. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/101-postgres-releases-useless-vacuum-isolation-differences-wal-compression/

In this episode of Scaling Postgres, we discuss full text search, a process for query optimization, caution with exception blocks and adding a procedural language. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/100-full-text-search-query-optimization-exception-blocks-procedural-language/

In this episode of Scaling Postgres, we discuss the "Ballad of Bloat", options for auditing, a configuration help resource and determining when a vacuum is needed. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/99-ballad-of-bloat-auditing-options-configuration-options-need-vacuum/

In this episode of Scaling Postgres, we discuss storing non-relational data, recognizing contributors, Postgres security features and implementing high availability. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/98-non-relational-data-contributors-security-features-high-availability/

In this episode of Scaling Postgres, we discuss tips & tricks, how to get faster APIs, full text search considerations and pgbouncer_fdw. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/97-tips-tricks-faster-apis-full-text-search-pgbouncer-fdw/

In this episode of Scaling Postgres, we discuss user account configuration, pricing, the system identifier and the HyperLogLog extension. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/96-account-configuration-pricing-system-identifier-hyperloglog/

In this episode of Scaling Postgres, we discuss max_locks_per_transaction, logical replication, managing backup & recovery and pgbouncer connection pooling. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/95-max_locks_per_transaction-logical-replication-backup-recovery-pgbouncer/

In this episode of Scaling Postgres, we discuss the State of Postgres, how best to dump your database, setting configuration parameters and managing partial WAL files. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/94-state-of-postgres-dumping-dbs-configuration-parameters-partial-wal/

In this episode of Scaling Postgres, we discuss logical replication aspects, how to monitor queries, investigating a SQL beautifier and removing incomplete startup packet. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/93-logical-replication-monitoring-queries-sql-beautifier-incomplete-startup-packet/

In this episode of Scaling Postgres, we discuss book sales, boosts to b-tree indexes, more Postgres 12 features and how to setup and use pgBackRest. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/92-book-sales-btree-boost-more-postgres-12-using-pgbackrest/

In this episode of Scaling Postgres, we discuss global indexes, ways to cache aggregates, how vacuum processing works and the purpose of effective cache size. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/91-global-indexes-caching-aggregates-vacuum-processing-effective-cache-size/

In this episode of Scaling Postgres, we discuss chaos order, pub sub, petabyte scale analytics and PgBouncer connections. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/90-chaos-order-pub-sub-petabyte-scale-pgbouncer-connections/

In this episode of Scaling Postgres, we discuss Postgres 12 performance impressions, mystery solving, GiST and SP-GiST performance and k-anonymity. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/89-performance-impressions-mystery-solving-gist-performance-k-anonymity/

In this episode of Scaling Postgres, we discuss partitioning, logical replication upgrades, columnar compression and HAProxy connections. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/88-partitioning-logical-replication-upgrade-columnar-compression-haproxy-connections/

In this episode of Scaling Postgres, we discuss the benefits of pg_receivewal, how to setup simple application failover, new pg_checksums and setting up pgBouncer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/87-pg_receivewal-application-failover-pg_checksums-pgbouncer/

In this episode of Scaling Postgres, we discuss prewarming your cache, working with nondeterministic collations, generated column performance and foreign keys with partitions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/86-prewarming-nondeterministic-collations-generated-column-performance-foreign-keys/

In this episode of Scaling Postgres, we discuss changes to recovery configuration, the alter system command, transaction isolation and vacuum for temp tables. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/85-recovery-configuration-alter-system-transaction-isolation-temp-table-vacuum/

In this episode of Scaling Postgres, we discuss the release features of Postgres 12, generated columns, parallel estimates and change data capture. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/84-postgres-12-released-generated-columns-parallel-estimates-change-data-capture/

In this episode of Scaling Postgres, we discuss the release of Postgres 12, how to use window frames, the different index types, and when to use synchronous replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/83-postgres-12-window-frames-index-types-synchronous-replication/

In this episode of Scaling Postgres, we discuss faster partition performance, count speed, extensions and Postgres education. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/82-faster-partitions-count-speed-extensions-education/

In this episode of Scaling Postgres, we discuss data loading speeds, view dependencies, users & roles and high availability clusters. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/81-data-loading-speed-view-dependencies-users-roles-high-availability-clusters/

In this episode of Scaling Postgres, we discuss why you should just upgrade, vacuum updates in Postgres 12, psql connection strings and a Postgres showcase. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/80-just-upgrade-vacuum-updates-connection-strings-postgres-showcase/

In this episode of Scaling Postgres, we discuss PgBouncer SCRAM support, The Art of PostgreSQL, making Postgres a distributed time-series DB and window functions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/79-pgbouncer-scram-art-of-postgresql-distributed-time-series-window-functions/

In this episode of Scaling Postgres, we discuss efficient pagination, how to rotate passwords, BRIN benefits and Row Level Security. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/78-efficient-pagination-rotating-passwords-brin-row-level-security/

In this episode of Scaling Postgres, we discuss timeseries queries, using arrays with queries, range use cases and developing triggers in C. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/77-timeseries-queries-arrays-ranges-c-triggers/

In this episode of Scaling Postgres, we discuss new CVEs, programming Postgres, JSONB comparison and using advisory locks. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/76-new-cves-postgres-programming-jsonb-advisory-locks/

In this episode of Scaling Postgres, we discuss combining indexes, regular expressions, parallelism in Postgres and PostGIS content. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/75-combining-indexes-regular-expressions-parallelism-postgis/

In this episode of Scaling Postgres, we discuss vacuum through pictures, upcoming recovery changes, certification authentication and how functions get replicated. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/74-picturing-vacuum-recovery-changes-certificate-authentication-function-replication/

In this episode of Scaling Postgres, we discuss BRIN indexes, partition enhancements, general tips and standby scaling. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/73-brin-indexes-partition-enhancements-tips-standbys/https://www.scalingpostgres.com/episodes/73-brin-indexes-partition-enhancements-tips-standbys/

In this episode of Scaling Postgres, we discuss collation issues, how to load data quickly, recovery changes in Postgres 12 and moving to SCRAM authentication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/72-collation-issues-fast-loading-recovery-scram-authentication/

In this episode of Scaling Postgres, we discuss indexing documents, how GIN indexes work, using Postgres for Data Science and generated columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/71-indexing-documents-gin-indexes-data-science-generated-columns/