All Episodes

Bloat vs zHeap, Composite Indexes, Unsafe Operations | Scaling Postgres 39

Parallel Query, Real Time Analytics, Killed Index Tuples | Scaling Postgres 38

Postgres Goodies, Materialized vs Rollup, Column Oriented | Scaling Postgres 37

Sharding, Giving Back, SCRAM, Partitioning Evolution | Scaling Postgres 36

Terabyte Scaling, Postgres 11, Connections, Backup | Scaling Postgres 35

Inserts, Nearest Neighbor, Freezing, Comment | Scaling Postgres 34

Per-Table Autovacuum, FDW Synchronization, Distinct On | Scaling Postgres 33

Sysadmin Concerns, Power of Indexing, pgbouncer Monitoring | Scaling Postgres 32

CTE Warning, PG 11 Features, Death by DB, Correlation | Scaling Postgres 31

Parallelism, JIT Compiling, Indexes, Administration | Scaling Postgres 30

Parallel Indexing, SQL vs. ORM, Logical Replication Upgrades | Scaling Postgres 29

Watch, Fast Text Search, Column Defaults, Import CSVs | Scaling Postgres 28

Multiple Databases, Slow Queries, Sorting Performance | Scaling Postgres 27

Join Costs, zHeap, Autovacuum Tuning | Scaling Postgres 26

generate_series, PG11 Partitioning, GPU Queries | Scaling Postgres 25

Full Text Search, JSONB_AGG, Upgrades, CIS | Scaling Postgres 24

UUIDs, Write Spikes, Distinct, SQL Standard | Scaling Postgres 23

Concurrency, Listen & Notify, ZFS, pg_rewind | Scaling Postgres 22

Using JSON, Procedures, Concurrency, Kubernetes | Scaling Postgres 21

Declarative Partitioning, Permissions, Trigger Speed | Scaling Postgres 20

100K Tenants, Extensions, Query Planning, Crosstabs | Scaling Postgres 19

Impact of Virtualization, Compressing Data, Parallelism | Scaling Postgres 18

Real Time Analytics, Index Decrease Performance, work_mem | Scaling Postgres 17

Storing Bits, Autovacuum, Assertions, Logical Recovery | Scaling Postgres 16

Leveraging Postgres, Tuning Autovacuum, Slow Queries | Scaling Postgres 15

Postgres 11, Multi-tenant Scale, Trigger Speed, Full Text Search | Scaling Postgres 14

Sharding Future, Query Optimization, Replication Read Performance, PostGIS | Scaling Postgres 13

The Future, Slow Counts, Avoid Or, Replication | Scaling Postgres 12

Serializable, JSON & JSONB, Fast Data Loading, PG11 Features | Scaling Postgres 11

ANSI Schmansi, Split-Brain, Performance Scenarios, Parallelism | Scaling Postgres 10

High Volume Processing, pg_wal Issues, Restore with pg_receivewal | Scaling Postgres 9

Scaling Real-Time Analytics, Covering Indexes, 1,500 Upgrades | Scaling Postgres 8

Any Scale, Monitoring Vacuum, Copy, Annotated Config | Scaling Postgres 7

Terabyte Scale, Permissions, Fast Column Adds, pgBouncer | Scaling Postgres 6

Constraints, User Order, PG Terrible, Logical Upgrades | Scaling Postgres 5

50TB Upgrade, Vacuum, DB Security | Scaling Postgres 4

Modeling, Query Performance, Statistics, pgmetrics | Scaling Postgres 3

Analytical DBs, Recursive Queries, Replication | Scaling Postgres 2

Petabyte Scale and Locking | Scaling Postgres 1