Creston Jamison

Scaling Postgres

Technology EN ↓ 438 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.

Be sure to visit the podcast's website and support the creator: www.scalingpostgres.com

Author

Creston Jamison

Episodes

Slow Queries, pg_auto_failover, Roles, Hyperscale | Scaling Postgres 63 12.05.2019 12:07

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/

Index Include Clause, Exporting CSV, JSON, Zedstore | Scaling Postgres 62 05.05.2019 15:39

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/

Constraint Triggers, Simple Shards, Data Streams, OIDs | Scaling Postgres 61 29.04.2019 10:15

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/

Pluggable Storage, Developer Gotchas, Cursors, PG12 | Scaling Postgres 60 21.04.2019 14:51

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/

Popularity, Load Testing, Checksums, pg_hba | Scaling Postgres 59 14.04.2019 12:20

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/

Security Concerns, Fast Counting, Indexing, Trends | Scaling Postgres 58 08.04.2019 19:00

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/

Checking Vacuum, Fast Distinct Count, Group By Speed Up, Health Check | Scaling Postgres 57 31.03.2019 14:24

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/

Practical Indexing, Vertical Scaling, Partition Migration, FDW Performance | Scaling Postgres 56 24.03.2019 10:35

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/

Replicating Data, SQL Functions, High Availability, Locking Issues | Scaling Postgres 55 18.03.2019 7:21

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/

Index-Only Scans, Lock Table, Hot Standby Feedback, Large Backups | Scaling Postgres 54 11.03.2019 15:29

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/

Query Planner, BRIN Indexes, Approximate Algorithms, Delayed Replication | Scaling Postgres 53 04.03.2019 19:11

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/

fsync Stopgap, CTE Changes, autovacuum_naptime, Postgres Community | Scaling Postgres 52 25.02.2019 9:48

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/

Value of SQL, Window Functions, DB Migrations, Data Storage | Scaling Postgres 51 18.02.2019 15:58

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/

Outage from TXIDs, Breaking Scale, fsync Gate, pg_stat_statements | Scaling Postgres 50 11.02.2019 14:23

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/

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/