All Episodes

Weekly News, Full-Text Search Performance, pg_cron, Bulk Data Loading | Scaling Postgres 139

Scaling Connections, TimescaleDB, Time-series Gaps, Red & Golden Signals | Scaling Postgres 138

Toast Impact, zheap Storage, More Performance, pg_rewind Changes | Scaling Postgres 137

Stat Tracking, Temporary Tables, pg_squeeze, pg_auto_failover | Scaling Postgres 136

Connection Scalability, Benchmarking Performance, Community Impact, zheap Progress | Scaling Postgres 135

Community Acquisition, Space Saving Terabytes, WAL Archiving, Vacuum Analyze Tips | Scaling Postgres 134

Postgres 13 Released, What's New In Postgres 13, Debugging PL/PGSQL, Monitoring | Scaling Postgres 133

Postgres 13 RC1, Upgrading at Scale, With Ties, HOT Updates | Scaling Postgres 132

Slow Archival, Index Improvements, Node Metrics, Join or Subquery | Scaling Postgres 131

External Compression, Parallel Vacuum, JSON Aggregates, JSON & Arrays | Scaling Postgres 130

28 Tips, Lucky 13, Autovacuum Tuning, Logical Pitfalls | Scaling Postgres 129

Statistics Speed Up, Synchronous Commits, TLS Updates, Avoiding Cursors | Scaling Postgres 128

Recursive Queries, Lateral Joins, Pagination, JSONB Arrays | Scaling Postgres 127

BRIN Pitfalls, pg_stat_statement Troubleshooting, Natural Join, Geography Type | Scaling Postgres 126

Scaling Suggestions, Slot Safety, SCRAM Channel Binding, Effective Cache Size | Scaling Postgres 125

Partition Migration, Like Performance, Best Fillfactor, In-Memory Tables | Scaling Postgres 124

JSONB Types, Earth Distance, Dates, Times & Intervals, Authentication | Scaling Postgres 123

Postgres is Fine, Generated Columns, Postgres Inserts, Synchronous Replication | Scaling Postgres 122

Fantastic Data Types, Domain Data Types, Insert Performance, Row Differences | Scaling Postgres 121

Postgres 13 Beta 2, System Stats Extension, Tuned, Join Strategy | Scaling Postgres 120

Replication Complications, One Word Performance, Pgbouncer Users, Serializable Isolation | Scaling Postgres 119

Safety Systems, Failover Slots, Transaction ID Complications, Repartitioning | Scaling Postgres 118

Index Deduplication, Fast Hierarchy, More Monitoring, Cloud-Native | Scaling Postgres 117

Observer Effect, Partition Management, Tuple Freezing, Hung Transactions | Scaling Postgres 116

PGCon Online, Performance Tips, Tracking Counts, Essential Monitoring | Scaling Postgres 115

Data Directory, Vacuum Features, Binary Performance, Network Latency | Scaling Postgres 114

arm64 with apt, Contributors, Backup Manifest, Now Functions | Scaling Postgres 113

Explain Analyze, Sequence Counts, Best Books, Partition Migration | Scaling Postgres 112

Insert-Only Vacuum, Settings, Sequence Replication, Improvements | Scaling Postgres 111

Max Connections, SQL Tricks, Fast Text Search, Security & Compliance | Scaling Postgres 110

Show Plans, WAL Monitoring, Using UUIDs, Default Logging | Scaling Postgres 109

Ten Things, Audit Triggers, Schema Design, High Availability | Scaling Postgres 108

Showing Plans, Atomic, Configuration, Migrations | Scaling Postgres 107

Recursive CTEs, DB Access Patterns, Dates & Times, Cluster | Scaling Postgres 106

World's Best, Subtransactions, Sharding, Schema Changes | Scaling Postgres 105

Reducing WAL, What is Null?, Understanding SQL, TPC-H Benchmarking | Scaling Postgres 104

Scaling Out, Planner Estimation, Create Statistics, Stay Curious | Scaling Postgres 103

UUID Use Cases, pg_settings, Automated Restore, Parallel Future | Scaling Postgres 102

Postgres Releases, Useless Vacuum, Isolation Differences, WAL Compression | Scaling Postgres 101

Full Text Search, Query Optimization, Exception Blocks, Procedural Language | Scaling Postgres 100

Ballad of Bloat, Auditing Options, Configuration Options, Need Vacuum? | Scaling Postgres 99

Non-Relational Data, Contributers, Security Features, High Availability | Scaling Postgres 98

Tips & Tricks, Faster APIs, Full Text Search, pgbouncer_fdw | Scaling Postgres 97

Account Configuration, Pricing, System Identifier, HyperLogLog | Scaling Postgres 96

max_locks_per_transaction, Logical Replication, Backup & Recovery, Pgbouncer | Scaling Postgres 95

State of Postgres, Dumping DBs, Configuration Parameters, Partial WAL | Scaling Postgres 94

Logical Replication, Monitoring Queries, SQL Beautifier, Incomplete Startup Packet | Scaling Postgres 93

Book Sales, B-tree Boost, More Postgres 12, Using pgBackRest | Scaling Postgres 92

Global Indexes, Caching Aggregates, Vacuum Processing, Effective Cache Size | Scaling Postgres 91

Chaos Order, Pub Sub, Petabyte Scale, PgBouncer Connections | Scaling Postgres 90

Performance Impressions, Mystery Solving, GiST Performance, K-Anonymity | Scaling Postgres 89

Partitioning, Logical Replication Upgrade, Columnar Compression, HAProxy Connections | Scaling Postgres 88

pg_receivewal, Application Failover, pg_checksums, pgBouncer | Scaling Postgres 87

Prewarming, Nondeterministic Collations, Generated Column Performance, Foreign Keys | Scaling Postgres 86

Recovery Configuration, Alter System, Transaction Isolation, Temp Table Vacuum | Scaling Postgres 85

Postgres 12 Released, Generated Columns, Parallel Estimates, Change Data Capture | Scaling Postgres 84

Postgres 12, Window Frames, Index Types, Synchronous Replication | Scaling Postgres 83

Faster Partitions, Count Speed, Extensions, Education | Scaling Postgres 82

Data Loading Speed, View Dependencies, Users & Roles, H/A Clusters | Scaling Postgres 81

Just Upgrade, Vacuum Updates, Connection Strings, Postgres Showcase | Scaling Postgres 80

PgBouncer SCRAM, Art of PostgreSQL, Distributed Time-Series, Window Functions | Scaling Postgres 79

Efficient Pagination, Rotating Passwords, BRIN, Row Level Security | Scaling Postgres 78

Timeseries Queries, Arrays, Ranges, C Triggers | Scaling Postgres 77

New CVEs, Postgres Programming, JSONB, Advisory Locks | Scaling Postgres 76

Combining Indexes, Regular Expressions, Parallelism, PostGIS | Scaling Postgres 75

Picturing Vacuum, Recovery Changes, Cert Authentication, Function Replication | Scaling Postgres 74

BRIN Indexes, Partition Enhancements, Tips, Standbys | Scaling Postgres 73

Collation Issues, Fast Loading, Recovery, SCRAM Authentication | Scaling Postgres 72

Indexing Documents, GIN Indexes, Data Science, Generated Columns | Scaling Postgres 71

Default Security, Max Connections, Progress Reporting, Migration | Scaling Postgres 70

Performance Training, JSON Path, Hypothetical Indexes, Interpolation | Scaling Postgres 69

Prepared Plans, Materialization, Recursive CTEs, Safe Migrations | Scaling Postgres 68

PGCon, Tips, PostGIS, Strings | Scaling Postgres 67

Query Optimization, Normalization, Visualizing Vacuum, Sharding | Scaling Postgres 66

Multi Column, Multi DB, Dos & Don'ts, RUM Indexes | Scaling Postgres 65

Leveraging Indexes, Slugs, Addresses, Security Definer | Scaling Postgres 64

Slow Queries, pg_auto_failover, Roles, Hyperscale | Scaling Postgres 63

Index Include Clause, Exporting CSV, JSON, Zedstore | Scaling Postgres 62

Constraint Triggers, Simple Shards, Data Streams, OIDs | Scaling Postgres 61

Pluggable Storage, Developer Gotchas, Cursors, PG12 | Scaling Postgres 60

Popularity, Load Testing, Checksums, pg_hba | Scaling Postgres 59

Security Concerns, Fast Counting, Indexing, Trends | Scaling Postgres 58

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

Practical Indexing, Vertical Scaling, Partition Migration, FDW Performance | Scaling Postgres 56

Replicating Data, SQL Functions, High Availability, Locking Issues | Scaling Postgres 55

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

Query Planner, BRIN Indexes, Approximate Algorithms, Delayed Replication | Scaling Postgres 53

fsync Stopgap, CTE Changes, autovacuum_naptime, Postgres Community | Scaling Postgres 52

Value of SQL, Window Functions, DB Migrations, Data Storage | Scaling Postgres 51

Outage from TXIDs, Breaking Scale, fsync Gate, pg_stat_statements | Scaling Postgres 50

Over One Billion, No Downtime, SQL Life, Throughput | Scaling Postgres 49

Microsoft Acquires Citus Data, Split WAL, Maintenance Work Mem | Scaling Postgres 48

pgBouncer, Postgres 11 Gems, DocumentDB, JSON | Scaling Postgres 47

Stuck Transaction IDs, pgBouncer Auth, UUIDs, Monitoring | Scaling Postgres 46

DBMS of 2018, Data Anonymization, JIT, Reserved Keywords | Scaling Postgres 45

Postgres Rise, Row Count Estimates, Nulls, Linux Config | Scaling Postgres 44

Logical Replication, Prepared Transactions, Ansible, Partitions | Scaling Postgres 43

Multi-Terabyte Scaling, Kubernetes DBaaS, Encryption, High Availability | Scaling Postgres 42

Sequential UUIDs, Runnning Totals, Read Committed, TOAST | Scaling Postgres 41

Materialized, PgBouncer Auth, Implicit vs Explicit, JIT | Scaling Postgres 40