Creston Jamison

Scaling Postgres

Technology EN ↓ 424 episodes

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.

Author

Creston Jamison

Episodes

Over One Billion, No Downtime, SQL Life, Throughput | Scaling Postgres 49 04.02.2019 14:20

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/

Microsoft Acquires Citus Data, Split WAL, Maintenance Work Mem | Scaling Postgres 48 27.01.2019 14:41

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/

pgBouncer, Postgres 11 Gems, DocumentDB, JSON | Scaling Postgres 47 20.01.2019 11:16

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/

Stuck Transaction IDs, pgBouncer Auth, UUIDs, Monitoring | Scaling Postgres 46 13.01.2019 11:41

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/

DBMS of 2018, Data Anonymization, JIT, Reserved Keywords | Scaling Postgres 45 07.01.2019 7:01

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/

Postgres Rise, Row Count Estimates, Nulls, Linux Config | Scaling Postgres 44 31.12.2018 8:15

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/

Logical Replication, Prepared Transactions, Ansible, Partitions | Scaling Postgres 43 17.12.2018 9:49

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/

Multi-Terabyte Scaling, Kubernetes DBaaS, Encryption, High Availability | Scaling Postgres 42 09.12.2018 12:14

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/

Sequential UUIDs, Runnning Totals, Read Committed, TOAST | Scaling Postgres 41 03.12.2018 14:26

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/

Materialized, PgBouncer Auth, Implicit vs Explicit, JIT | Scaling Postgres 40 25.11.2018 8:37

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/

Bloat vs zHeap, Composite Indexes, Unsafe Operations | Scaling Postgres 39 19.11.2018 17:45

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/

Parallel Query, Real Time Analytics, Killed Index Tuples | Scaling Postgres 38 12.11.2018 9:53

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/

Postgres Goodies, Materialized vs Rollup, Column Oriented | Scaling Postgres 37 05.11.2018 17:35

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/

Sharding, Giving Back, SCRAM, Partitioning Evolution | Scaling Postgres 36 29.10.2018 10:51

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/

Terabyte Scaling, Postgres 11, Connections, Backup | Scaling Postgres 35 22.10.2018 17:07

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/

Inserts, Nearest Neighbor, Freezing, Comment | Scaling Postgres 34 15.10.2018 11:46

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/

Per-Table Autovacuum, FDW Synchronization, Distinct On | Scaling Postgres 33 08.10.2018 9:12

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/

Sysadmin Concerns, Power of Indexing, pgbouncer Monitoring | Scaling Postgres 32 01.10.2018 11:58

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/

CTE Warning, PG 11 Features, Death by DB, Correlation | Scaling Postgres 31 24.09.2018 15:45

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/

Parallelism, JIT Compiling, Indexes, Administration | Scaling Postgres 30 17.09.2018 9:45

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/

Parallel Indexing, SQL vs. ORM, Logical Replication Upgrades | Scaling Postgres 29 10.09.2018 13:27

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/

Watch, Fast Text Search, Column Defaults, Import CSVs | Scaling Postgres 28 03.09.2018 17:05

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/

Multiple Databases, Slow Queries, Sorting Performance | Scaling Postgres 27 27.08.2018 18:04

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/

Join Costs, zHeap, Autovacuum Tuning | Scaling Postgres 26 20.08.2018 9:39

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/

generate_series, PG11 Partitioning, GPU Queries | Scaling Postgres 25 13.08.2018 13:14

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/