Scaling Postgres

In this episode of Scaling Postgres, we discuss the default security, max_connections and pooling, progress reporting and migrating to Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/70-default-security-max-connections-progress-reporting-migration/

In this episode of Scaling Postgres, we discuss performance training, SQL/JSON path support, hypothetical indexes and linear interpolation of data. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/69-performance-training-json-path-hypothetical-indexes-interpolation/

In this episode of Scaling Postgres, we discuss prepared plans, materialization, recursive CTEs and how to run safe database migrations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/68-prepared-plans-materialization-recursive-cte-safe-migrations/

In this episode of Scaling Postgres, we discuss videos from PGCon, Postgres tips & tricks, PostGIS parallel performance and using strings. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/67-pgcon-tips-postgis-strings/

In this episode of Scaling Postgres, we discuss different query optimizations, normalizing to save space, visualizing vacuum and shardings future. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/66-query-optimization-normalization-visualizing-vacuum-sharding/

In this episode of Scaling Postgres, we discuss multi-column indexes, using multiple databases, Postgres dos & don'ts as well as using RUM indexes. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/65-multi-column-multi-db-dos-and-donts-rum-indexes/

In this episode of Scaling Postgres, we discuss leveraging indexes, a slug function, addresses and security definer in functions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/64-leveraging-indexes-slugs-addresses-security-definer/

In this episode of Scaling Postgres, we review articles covering how to identify slow queries, the pg_auto_failover utility, working with roles and Hyperscale. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/63-slow-queries-pg_auto_failover-roles-hyperscale/

In this episode of Scaling Postgres, we review articles covering the index include clause, exporting data to CSV, using JSON in Postgres and Zedstore. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/62-index-include-clause-exporting-csv-json-zedstore/

In this episode of Scaling Postgres, we review articles covering constraint triggers, simple shards, data streams and OIDs. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/61-constraint-triggers-simple-shards-data-streams-oids/

In this episode of Scaling Postgres, we review articles covering pluggable storage, gotchas for developers, using cursors and new PG12 features. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/60-pluggable-storage-developer-gotchas-cursors-pg12/

In this episode of Scaling Postgres, we review articles covering Posgres' popularity, conducting load testing, checksums in PG12 and pg_hba configuration. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/59-popularity-load-testing-checksums-pg_hba/https://www.scalingpostgres.com/episodes/59-popularity-load-testing-checksums-pg_hba/

In this episode of Scaling Postgres, we review articles covering security concerns, fast counting tables, indexing basics and PostgreSQL trends. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/58-security-concerns-fast-counting-indexing-trends/

In this episode of Scaling Postgres, we review articles covering checking on vacuum, how to get a fast distinct count and speed up group by and a health check playbook. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/57-checking-vacuum-fast-distinct-count-group-by-speed-up-health-check/

In this episode of Scaling Postgres, we review articles covering practical indexing, vertical scalability, migrating to partitions and foreign data wrapper performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/56-practical-indexing-vertical-scaling-partition-migration-fdw-performance/

In this episode of Scaling Postgres, we review articles covering methods to replicate data, SQL functions, tools for high availability and locking issues. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/55-replicating-data-sql-functions-high-availability-locking-issues/

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 the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/54-index-only-scans-lock-table-hot-standby-feedback-large-backups/

In this episode of Scaling Postgres, we review articles covering the Postgres query planner, BRIN indexes, approximate algorithms, and the uses of delayed replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/53-query-planner-brin-indexes-approximate-algorithms-delayed-replication/

In this episode of Scaling Postgres, we review articles covering a fsync stopgap, tuning autovacuum_naptime, upcoming CTE / WITH clause changes and the Postgres community. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/52-fsync-stopgap-autovacuum_naptime-cte-changes-postgres-community/

In this episode of Scaling Postgres, we review articles covering the value of SQL, window functions, scaling database migrations and efficient data storage. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/51-sql-value-window-functions-db-migrations-data-storage/

In this episode of Scaling Postgres, we review articles covering an outage from running out of TXIDs, breaking scale, that PG fsync issue and pg_stat_statements. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/50-outage-txids-breaking-scale-fsync-gate-pg_stat_statements/

In this episode of Scaling Postgres, we review articles covering over one billion records per month, schema changes with no downtime, the life of a SQL query and throughput tracking. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/49-over-one-billion-monthly-records-no-downtime-schema-changes-sql-life-throughput-tracking/

In this episode of Scaling Postgres, we review articles covering Microsoft acquiring Citus Data, split WAL files, maintenance_work_mem and logical replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/48-microsoft-acquires-citus-data-split-wal-maintenance-work-memory-logical-replication/

In this episode of Scaling Postgres, we review articles covering pgBouncer, Postgres 11 gems, DocumentDB similarities and JSON capabilities. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/47-pgbouncer-postgres-11-gems-documentdb-json/

In this episode of Scaling Postgres, we review articles covering stuck transaction ids, pgBouncer authentication, sequential UUIDs, and monitoring. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/46-stuck-transaction-ids-pgbouncer-authentication-uuids-monitoring/

In this episode of Scaling Postgres, we review articles covering Postgres as DBMS of 2018, data anonymization, implementing JIT and reserved keywords. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/45-dmbs-2018-data-anonymization-jit-reserved-keywords/

In this episode of Scaling Postgres, we review articles covering the rise of Postgres, row count estimates, nulls and linux configuration. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/44-postgres-rise-row-count-estimates-nulls-linux-config/

In this episode of Scaling Postgres, we review articles covering logical replication, prepared transactions, Ansible Postgres deployment Ansible and tidy partitions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/43-logical-replication-prepared-transactions-ansible-tidy-partitions/

In this episode of Scaling Postgres, we review articles covering multi-terabyte scaling, building a kubernetes DBaaS, encryption and building high availability. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/42-multi-terabyte-scaling-kubernetes-dbaas-encryption-high-availability/

In this episode of Scaling Postgres, we review articles covering sequential UUIDs, running totals with window functions, read committed vs repeatable read and TOAST. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/41-sequential-uuids-running-totals-read-commmitted-toast/

In this episode of Scaling Postgres, we review articles covering materialized views in Rails, pgbouncer auth_user, implicit vs explicit joins and JIT. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/40-materialized-pgbouncer-auth-implicit-explicit-jit/

In this episode of Scaling Postgres, we review articles covering bloat vs. zheap, composite indexes, unsafe operations, and being a better developer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/39-bloat-vs-zheap-composite-indexes-unsafe-operations-better-developers/

In this episode of Scaling Postgres, we review articles covering parallel queries, real time analytics, killed index tuples and unexpected downtime. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/38-parallel-query-real-time-analytics-killed-index-tuples-downtime/

In this episode of Scaling Postgres, we review articles covering Postgres goodies, materialized vs. rollup, column oriented data and parallel scans. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/37-postgres-goodies-materialized-vs-rollup-column-oriented-parallel-scan/

In this episode of Scaling Postgres, we review articles covering PG11 sharding, giving back, SCRAM authentication and the evolution of partitioning. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/36-sharding-giving-back-scram-partitioning-evolution/

In this episode of Scaling Postgres, we review articles covering terabyte scaling, PostgreSQL 11, managing connections and backup of terabyte databases. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/35-terabyte-scaling-postgres-11-connections-backup/

In this episode of Scaling Postgres, we review articles covering all about inserts, how to handle nearest neighbor, freezing confirmation and Comment. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/34-inserts-nearest-neighbor-freezing-comment/

In this episode of Scaling Postgres, we review articles covering per-table autovacuum, FDW for data synchronization, distinct on and Postgres Open. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/33-per-table-autovacuum-fdw-synchronization-distinct-on-postgres-open/

In this episode of Scaling Postgres, we review articles covering sysadmin concerns, the power of indexing, pgbouncer monitoring and pg_prewarm. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/32-sysadmin-concerns-power-of-indexing-pgbouncer-monitoring/

In this episode of Scaling Postgres, we review articles covering a CTE warning, Postgres 11 new features, death by database and column correlation. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/31-cte-warning-pg11-features-death-by-db-column-correlation/

In this episode of Scaling Postgres, we review articles covering parallellism in Postgres 11, JIT compiling, indexes in depth and administration. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/30-parallelism-jit-compiling-indexes-administration/

In this episode of Scaling Postgres, we review articles covering parallel indexing, SQL vs. ORM, logical replication upgrades and development DBs. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/29-parallel-indexing-sql-vs-orm-logical-replication-upgrades/

In this episode of Scaling Postgres, we review articles covering watching Star Wars, fast text search, column defaults and importing large CSVs. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/28-watch-fast-text-search-column-defaults-import-csv/

In this episode of Scaling Postgres, we review articles covering scaling with multiple databases, detecting slow queries, and sorting performance. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/27-multiple-databases-slow-queries-sorting-performance/

In this episode of Scaling Postgres, we review articles covering join costs, zHeap, autovacuum tuning and Postgres configuration for humans. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/26-join-costs-zheap-autovacuum-tuning/

In this episode of Scaling Postgres, we review articles covering graphing with generate_series, partitioning in Postgres 11 and GPUs for queries. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/25-generate_series-pg11-partitioning-gpu-queries/

In this episode of Scaling Postgres, we review articles covering full text search, aggregating JSON with jsonb_agg, upgrades and CIS benchmarks. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/24-full-text-search-jsonb_agg-upgrades-cis/

In this episode of Scaling Postgres, we review articles covering UUIDs, the source of write spikes, uses of distinct and SQL standards support. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/23-uuids-write-spikes-distinct-sql-standard/

In this episode of Scaling Postgres, we review articles covering concurrency, how to use listen & notify, zfs, caution regarding pg_rewind. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/22-concurrency-listen-notify-zfs-pg_rewind/

In this episode of Scaling Postgres, we review articles covering how to use JSON & JSONB, procedures, deal with concurrency issues and Kubernetes. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/21-using-json-procedures-concurrency-kubernetes/