Broadcasts.com - browse "Technology" podcasts

Scaling Postgres

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.

Episode 150 Scaling Advice | Vicious Cycle | Improve Observability | Addressing Corruption

Published: Jan. 31, 2021, 10:05 p.m.
Duration: 16 minutes 57 seconds

Listed in: Technology

Episode 149 ARM Tests | Tips & Tricks | Hierarchical Structures | Benchmarking Framework

Published: Jan. 24, 2021, 10:41 p.m.
Duration: 12 minutes 24 seconds

Listed in: Technology

Episode 148 Hash Indexes | Int Float Numeric Types | Postgres 14 Features | Data Science

Published: Jan. 17, 2021, 10 p.m.
Duration: 11 minutes 55 seconds

Listed in: Technology

Episode 147 DBMS of the Year | Better Data Migrations | Idle Connection Impact | Security Implementation Guide

Published: Jan. 10, 2021, 10:44 p.m.
Duration: 20 minutes 29 seconds

Listed in: Technology

Episode 146 Active-Active & Federated | Memory Speed | Table Rewrite Causes | PostgreSQL Shibboleth

Published: Jan. 4, 2021, 12:22 a.m.
Duration: 14 minutes 46 seconds

Listed in: Technology

Episode 145 PgMiner Botnet | Collation Index Corruption | postgresql.conf | Custom Data Types

Published: Dec. 20, 2020, 10:18 p.m.
Duration: 14 minutes 7 seconds

Listed in: Technology

Episode 144 Postgres Migration | Bulk Data Loading | Updates vs. Upgrades | UUID Benchmarks

Published: Dec. 13, 2020, 10:17 p.m.
Duration: 12 minutes 10 seconds

Listed in: Technology

Episode 143 Microsoft SQL Server Compatible | Time Series Performance | Feature Casualties | BLOB Cleanup

Published: Dec. 7, 2020, 1:41 a.m.
Duration: 18 minutes 43 seconds

Listed in: Technology

Episode 142 Insert vs. Update | Select * Performance | Debezium Set Up | Standardizing Data

Published: Nov. 29, 2020, 10:19 p.m.
Duration: 13 minutes 35 seconds

Listed in: Technology

Episode 141 Unattended Upgrade | ARM Benchmarks | Exploration | PostGIS Performance

Published: Nov. 23, 2020, 12:20 a.m.
Duration: 10 minutes 32 seconds

Listed in: Technology

Episode 140 Replication Conflicts | Postgres Governance | pg_crash | MobilityDB

Published: Nov. 15, 2020, 10:28 p.m.
Duration: 11 minutes 28 seconds

Listed in: Technology

Episode 139 Weekly News | Full-Text Search Performance | pg_cron | Bulk Data Loading

Published: Nov. 8, 2020, 10:16 p.m.
Duration: 12 minutes 38 seconds

Listed in: Technology

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

Published: Nov. 1, 2020, 10:47 p.m.
Duration: 16 minutes 57 seconds

Listed in: Technology

Episode 137 Toast Impact | zheap Storage | More Performance | pg_rewind Changes

Published: Oct. 26, 2020, 12:07 a.m.
Duration: 21 minutes 15 seconds

Listed in: Technology

Episode 136 Stat Tracking | Temporary Tables | pg_squeeze | pg_auto_failover

Published: Oct. 19, 2020, 12:07 a.m.
Duration: 13 minutes 9 seconds

Listed in: Technology

Episode 135 Connection Scalability | Benchmarking Performance | Community Impact | zheap Progress

Published: Oct. 11, 2020, 11:56 p.m.
Duration: 19 minutes 43 seconds

Listed in: Technology

Episode 134 Community Acquisition | Space Saving Terabytes | WAL Archiving | Vacuum Analyze Tips

Published: Oct. 4, 2020, 11:45 p.m.
Duration: 14 minutes 11 seconds

Listed in: Technology

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

Published: Sept. 27, 2020, 10:16 p.m.
Duration: 13 minutes 54 seconds

Listed in: Technology

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

Published: Sept. 21, 2020, 7:12 p.m.
Duration: 17 minutes 40 seconds

Listed in: Technology

Episode 131 Slow Archival | Index Improvements | Node Metrics | Join or Subquery

Published: Sept. 13, 2020, 11:49 p.m.
Duration: 15 minutes 59 seconds

Listed in: Technology

Episode 130 External Compression | Parallel Vacuum | JSON Aggregates | JSON & Arrays

Published: Sept. 6, 2020, 11:46 p.m.
Duration: 15 minutes 16 seconds

Listed in: Technology

Episode 129 28 Tips | Lucky 13 | Autovacuum Tuning | Logical Pitfalls

Published: Aug. 30, 2020, 11:21 p.m.
Duration: 15 minutes 59 seconds

Listed in: Technology

Episode 128 Statistics Speed Up | Synchronous Commits | TLS Updates | Avoiding Cursors

Published: Aug. 24, 2020, 12:09 a.m.
Duration: 16 minutes 57 seconds

Listed in: Technology

Episode 127 Recursive Queries | Lateral Joins | Pagination | JSONB Arrays

Published: Aug. 17, 2020, 12:21 a.m.
Duration: 14 minutes 38 seconds

Listed in: Technology

Episode 126 BRIN Pitfalls | pg_stat_statement Troubleshooting | Natural Join | Geography Type

Published: Aug. 9, 2020, 11:22 p.m.
Duration: 14 minutes 14 seconds

Listed in: Technology

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

Published: Aug. 3, 2020, 12:16 a.m.
Duration: 15 minutes 1 second

Listed in: Technology

Episode 124 Partition Migration | Like Performance | Best Fillfactor | In-Memory Tables

Published: July 27, 2020, 12:05 a.m.
Duration: 15 minutes 57 seconds

Listed in: Technology

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

Published: July 19, 2020, 10:36 p.m.
Duration: 13 minutes 29 seconds

Listed in: Technology

Episode 122 Postgres is Fine | Generated Columns | Postgres Inserts | Synchronous Replication

Published: July 13, 2020, 1:23 a.m.
Duration: 10 minutes 15 seconds

Listed in: Technology

Episode 121 Fantastic Data Types | Domain Data Types | Insert Performance | Row Differences

Published: July 6, 2020, 12:22 a.m.
Duration: 16 minutes 34 seconds

Listed in: Technology

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

Published: June 28, 2020, 11:27 p.m.
Duration: 12 minutes 13 seconds

Listed in: Technology

Episode 119 Replication Complications | One Word Performance | Pgbouncer Users | Serializable Isolation

Published: June 22, 2020, 1:32 a.m.
Duration: 15 minutes 6 seconds

Listed in: Technology

Episode 118 Safety Systems | Failover Slots | Transaction ID Complications | Repartitioning

Published: June 14, 2020, 11:39 p.m.
Duration: 15 minutes 52 seconds

Listed in: Technology

Episode 117 Index Deduplication | Fast Hierarchy | More Monitoring | Cloud-Native

Published: June 8, 2020, 12:12 a.m.
Duration: 17 minutes 36 seconds

Listed in: Technology

Episode 116 Observer Effect | Partition Management | Tuple Freezing | Hung Transactions

Published: June 1, 2020, 12:15 a.m.
Duration: 14 minutes 2 seconds

Listed in: Technology

Episode 115 PGCon Online | Performance Tips | Tracking Counts | Essential Monitoring

Published: May 25, 2020, 4:12 a.m.
Duration: 12 minutes 51 seconds

Listed in: Technology

Episode 114 Data Directory | Vacuum Features | Binary Performance | Network Latency

Published: May 18, 2020, 5:17 a.m.
Duration: 20 minutes 29 seconds

Listed in: Technology

Episode 113 arm64 with apt | Contributors | Backup Manifest | Now Functions

Published: May 11, 2020, 12:18 a.m.
Duration: 13 minutes 7 seconds

Listed in: Technology

Episode 112 Explain Analyze | Sequence Counts | Best Books | Partition Migration

Published: May 4, 2020, 2:51 a.m.
Duration: 16 minutes 45 seconds

Listed in: Technology

Episode 111 Insert-Only Vacuum | Settings | Sequence Replication | Improvements

Published: April 26, 2020, 11:47 p.m.
Duration: 16 minutes 49 seconds

Listed in: Technology

Episode 110 Max Connections | SQL Tricks | Fast Text Search | Security & Compliance

Published: April 20, 2020, 12:01 a.m.
Duration: 13 minutes 34 seconds

Listed in: Technology

Episode 109 Show Plans | WAL Monitoring | Using UUIDs | Default Logging

Published: April 13, 2020, 12:06 a.m.
Duration: 12 minutes 36 seconds

Listed in: Technology

Episode 108 Ten Things | Audit Triggers | Schema Design | High Availability

Published: April 6, 2020, 12:26 a.m.
Duration: 20 minutes 44 seconds

Listed in: Technology

Episode 107 Showing Plans | Atomic | Configuration | Migrations

Published: March 30, 2020, 12:28 a.m.
Duration: 10 minutes 49 seconds

Listed in: Technology

Episode 106 Recursive CTEs | DB Access Patterns | Dates & Times | Cluster

Published: March 23, 2020, 12:12 a.m.
Duration: 14 minutes 59 seconds

Listed in: Technology

Episode 105 World's Best | Subtransactions | Sharding | Schema Changes

Published: March 16, 2020, 12:55 a.m.
Duration: 19 minutes 23 seconds

Listed in: Technology

Episode 104 Reducing WAL | What is Null? | Understanding SQL | TPC-H Benchmarking

Published: March 9, 2020, 12:21 a.m.
Duration: 15 minutes 21 seconds

Listed in: Technology

Episode 103 Scaling Out | Planner Estimation | Create Statistics | Stay Curious

Published: March 2, 2020, 1:09 a.m.
Duration: 13 minutes 58 seconds

Listed in: Technology

Episode 102 UUID Use Cases | pg_settings | Automated Restore | Parallel Future

Published: Feb. 24, 2020, 1:17 a.m.
Duration: 12 minutes 45 seconds

Listed in: Technology

Episode 101 Postgres Releases | Useless Vacuum | Isolation Differences | WAL Compression

Published: Feb. 17, 2020, 3:18 a.m.
Duration: 17 minutes 47 seconds

Listed in: Technology

Episode 100 Full Text Search | Query Optimization | Exception Blocks | Procedural Language

Published: Feb. 10, 2020, 2:02 a.m.
Duration: 15 minutes 13 seconds

Listed in: Technology

Episode 99 Ballad of Bloat | Auditing Options | Configuration Options | Need Vacuum?

Published: Feb. 3, 2020, 1:54 a.m.
Duration: 15 minutes 12 seconds

Listed in: Technology

Episode 98 Non-Relational Data | Contributers | Security Features | High Availability

Published: Jan. 26, 2020, 10:16 p.m.
Duration: 13 minutes 1 second

Listed in: Technology

Episode 97 Tips & Tricks | Faster APIs | Full Text Search | pgbouncer_fdw

Published: Jan. 20, 2020, 2:39 a.m.
Duration: 13 minutes 12 seconds

Listed in: Technology

Episode 96 Account Configuration | Pricing | System Identifier | HyperLogLog

Published: Jan. 13, 2020, 2 a.m.
Duration: 12 minutes 12 seconds

Listed in: Technology

Episode 95 max_locks_per_transaction | Logical Replication | Backup & Recovery | Pgbouncer

Published: Jan. 6, 2020, 2:17 a.m.
Duration: 11 minutes 52 seconds

Listed in: Technology

Episode 94 State of Postgres | Dumping DBs | Configuration Parameters | Partial WAL

Published: Dec. 16, 2019, 4:55 a.m.
Duration: 12 minutes 30 seconds

Listed in: Technology

Episode 93 Logical Replication | Monitoring Queries | SQL Beautifier | Incomplete Startup Packet

Published: Dec. 9, 2019, 1:36 a.m.
Duration: 9 minutes 5 seconds

Listed in: Technology

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

Published: Dec. 2, 2019, 2:41 a.m.
Duration: 13 minutes 18 seconds

Listed in: Technology

Episode 91 Global Indexes | Caching Aggregates | Vacuum Processing | Effective Cache Size

Published: Nov. 25, 2019, 1:17 a.m.
Duration: 13 minutes 23 seconds

Listed in: Technology

Episode 90 Chaos Order | Pub Sub | Petabyte Scale | PgBouncer Connections

Published: Nov. 18, 2019, 1:56 a.m.
Duration: 12 minutes 2 seconds

Listed in: Technology

Episode 89 Performance Impressions | Mystery Solving | GiST Performance | K-Anonymity

Published: Nov. 11, 2019, 1:50 a.m.
Duration: 15 minutes 43 seconds

Listed in: Technology

Episode 88 Partitioning | Logical Replication Upgrade | Columnar Compression | HAProxy Connections

Published: Nov. 4, 2019, 12:45 a.m.
Duration: 14 minutes 35 seconds

Listed in: Technology

Episode 87 pg_receivewal | Application Failover | pg_checksums | pgBouncer

Published: Oct. 28, 2019, 12:17 a.m.
Duration: 12 minutes 40 seconds

Listed in: Technology

Episode 86 Prewarming | Nondeterministic Collations | Generated Column Performance | Foreign Keys

Published: Oct. 20, 2019, 11:40 p.m.
Duration: 15 minutes 35 seconds

Listed in: Technology

Episode 85 Recovery Configuration | Alter System | Transaction Isolation | Temp Table Vacuum

Published: Oct. 14, 2019, 12:34 a.m.
Duration: 15 minutes 1 second

Listed in: Technology

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

Published: Oct. 7, 2019, 12:11 a.m.
Duration: 12 minutes 38 seconds

Listed in: Technology

Episode 83 Postgres 12 | Window Frames | Index Types | Synchronous Replication

Published: Sept. 30, 2019, 12:38 a.m.
Duration: 13 minutes 15 seconds

Listed in: Technology

Episode 82 Faster Partitions | Count Speed | Extensions | Education

Published: Sept. 23, 2019, 12:19 a.m.
Duration: 12 minutes 57 seconds

Listed in: Technology

Episode 81 Data Loading Speed | View Dependencies | Users & Roles | H/A Clusters

Published: Sept. 16, 2019, 12:42 a.m.
Duration: 12 minutes 45 seconds

Listed in: Technology

Episode 80 Just Upgrade | Vacuum Updates | Connection Strings | Postgres Showcase

Published: Sept. 9, 2019, 1:53 a.m.
Duration: 13 minutes 48 seconds

Listed in: Technology

Episode 79 PgBouncer SCRAM | Art of PostgreSQL | Distributed Time-Series | Window Functions

Published: Sept. 2, 2019, 2:08 p.m.
Duration: 10 minutes 7 seconds

Listed in: Technology

Episode 78 Efficient Pagination | Rotating Passwords | BRIN | Row Level Security

Published: Aug. 25, 2019, 11:43 p.m.
Duration: 17 minutes 37 seconds

Listed in: Technology

Episode 77 | Timeseries Queries | Arrays | Ranges | C Triggers

Published: Aug. 19, 2019, 12:20 a.m.
Duration: 12 minutes 15 seconds

Listed in: Technology

Episode 76 | New CVEs | Postgres Programming | JSONB | Advisory Locks

Published: Aug. 12, 2019, 2:09 a.m.
Duration: 12 minutes 55 seconds

Listed in: Technology

Episode 75 | Combining Indexes | Regular Expressions | Parallelism | PostGIS

Published: Aug. 5, 2019, 1:02 a.m.
Duration: 15 minutes 41 seconds

Listed in: Technology

Episode 74 | Picturing Vacuum | Recovery Changes | Cert Authentication | Function Replication

Published: July 29, 2019, 12:35 a.m.
Duration: 11 minutes 12 seconds

Listed in: Technology

Episode 73 | BRIN Indexes | Partition Enhancements | Tips | Standbys

Published: July 22, 2019, 12:21 a.m.
Duration: 14 minutes 14 seconds

Listed in: Technology

Episode 72 | Collation Issues | Fast Loading | Recovery | SCRAM Authentication

Published: July 15, 2019, 1:02 a.m.
Duration: 17 minutes 11 seconds

Listed in: Technology

Episode 71 | Indexing Documents | GIN Indexes | Data Science | Generated Columns

Published: July 8, 2019, 12:23 a.m.
Duration: 13 minutes 23 seconds

Listed in: Technology

Episode 70 | Default Security | Max Connections | Progress Reporting | Migration

Published: July 1, 2019, 12:26 a.m.
Duration: 12 minutes 58 seconds

Listed in: Technology

Episode 69 | Performance Training | JSON Path | Hypothetical Indexes | Interpolation

Published: June 24, 2019, 12:25 a.m.
Duration: 15 minutes 14 seconds

Listed in: Technology

Episode 68 | Prepared Plans | Materialization | Recursive CTEs | Safe Migrations

Published: June 16, 2019, 11:54 p.m.
Duration: 16 minutes 3 seconds

Listed in: Technology

Episode 67 | PGCon | Tips | PostGIS | Strings

Published: June 9, 2019, 10 p.m.
Duration: 9 minutes 50 seconds

Listed in: Technology

Episode 66 | Query Optimization | Normalization | Visualizing Vacuum | Sharding

Published: June 3, 2019, 2:12 a.m.
Duration: 17 minutes 10 seconds

Listed in: Technology

Episode 65 | Multi Column | Multi DB | Dos & Don'ts | RUM Indexes

Published: May 26, 2019, 11:43 p.m.
Duration: 14 minutes 9 seconds

Listed in: Technology

Episode 64 | Leveraging Indexes | Slugs | Addresses | Security Definer

Published: May 20, 2019, 12:05 a.m.
Duration: 13 minutes 13 seconds

Listed in: Technology

Episode 63 | Slow Queries | pg_auto_failover | Roles | Hyperscale

Published: May 12, 2019, 10:44 p.m.
Duration: 12 minutes 8 seconds

Listed in: Technology

Episode 62 | Index Include Clause | Exporting CSV | JSON | Zedstore

Published: May 5, 2019, 10:24 p.m.
Duration: 15 minutes 40 seconds

Listed in: Technology

Episode 61 | Constraint Triggers | Simple Shards | Data Streams | OIDs

Published: April 29, 2019, 12:22 a.m.
Duration: 10 minutes 16 seconds

Listed in: Technology

Episode 60 | Pluggable Storage | Developer Gotchas | Cursors | PG12

Published: April 21, 2019, 11:47 p.m.
Duration: 14 minutes 52 seconds

Listed in: Technology

Episode 59 | Popularity | Load Testing | Checksums | pg_hba

Published: April 14, 2019, 10:05 p.m.
Duration: 12 minutes 21 seconds

Listed in: Technology

Episode 58 | Security Concerns | Fast Counting | Indexing | Trends

Published: April 8, 2019, 12:44 a.m.
Duration: 19 minutes 1 second

Listed in: Technology

Episode 57 | Checking Vacuum | Fast Distinct Count | Group By Speed Up | Health Check

Published: March 31, 2019, 11:53 p.m.
Duration: 14 minutes 25 seconds

Listed in: Technology

Episode 56 | Practical Indexing | Vertical Scaling | Partition Migration | FDW Performance

Published: March 24, 2019, 10:42 p.m.
Duration: 10 minutes 36 seconds

Listed in: Technology

Episode 55 | Replicating Data | SQL Functions | High Availability | Locking Issues

Published: March 18, 2019, 1:32 a.m.
Duration: 7 minutes 22 seconds

Listed in: Technology

Episode 54 | Index-Only Scans | Lock Table | Hot Standby Feedback | Large Backups

Published: March 11, 2019, 1:09 a.m.
Duration: 15 minutes 30 seconds

Listed in: Technology

Episode 53 | Query Planner | BRIN Indexes | Approximate Algorithms | Delayed Replication

Published: March 4, 2019, 3:58 a.m.
Duration: 19 minutes 12 seconds

Listed in: Technology

Episode 52 | fsync Stopgap | CTE Changes | autovacuum_naptime | Postgres Community

Published: Feb. 25, 2019, 12:43 a.m.
Duration: 9 minutes 49 seconds

Listed in: Technology

Episode 51 | Value of SQL | Window Functions | DB Migrations | Data Storage

Published: Feb. 18, 2019, 2:10 a.m.
Duration: 15 minutes 59 seconds

Listed in: Technology

Episode 50 | Outage from TXIDs | Breaking Scale | fsync Gate | pg_stat_statements

Published: Feb. 11, 2019, 12:13 a.m.
Duration: 14 minutes 24 seconds

Listed in: Technology

Episode 49 | Over One Billion | No Downtime | SQL Life | Throughput

Published: Feb. 4, 2019, 2:05 a.m.
Duration: 14 minutes 21 seconds

Listed in: Technology

Episode 48 | Microsoft Acquires Citus Data | Split WAL | Maintenance Work Mem

Published: Jan. 27, 2019, 11:16 p.m.
Duration: 14 minutes 42 seconds

Listed in: Technology

Episode 47 | pgBouncer | Postgres 11 Gems | DocumentDB | JSON

Published: Jan. 20, 2019, 11:11 p.m.
Duration: 11 minutes 17 seconds

Listed in: Technology

Episode 46 | Stuck Transaction IDs | pgBouncer Auth | UUIDs | Monitoring

Published: Jan. 13, 2019, 11:25 p.m.
Duration: 11 minutes 42 seconds

Listed in: Technology

Episode 45 | DBMS of 2018 | Data Anonymization | JIT | Reserved Keywords

Published: Jan. 7, 2019, 4:38 a.m.
Duration: 7 minutes 2 seconds

Listed in: Technology

Episode 44 | Postgres Rise | Row Count Estimates | Nulls | Linux Config

Published: Dec. 31, 2018, 12:45 a.m.
Duration: 8 minutes 16 seconds

Listed in: Technology

Episode 43 | Logical Replication | Prepared Transactions | Ansible | Partitions

Published: Dec. 17, 2018, 12:43 a.m.
Duration: 9 minutes 50 seconds

Listed in: Technology

Episode 42 | Multi-Terabyte Scaling | Kubernetes DBaaS | Encryption | High Availability

Published: Dec. 9, 2018, 11:12 p.m.
Duration: 12 minutes 15 seconds

Listed in: Technology

Episode 41 | Sequential UUIDs | Runnning Totals | Read Committed | TOAST

Published: Dec. 3, 2018, 1:19 a.m.
Duration: 14 minutes 27 seconds

Listed in: Technology

Episode 40 | Materialized | PgBouncer Auth | Implicit vs Explicit | JIT

Published: Nov. 25, 2018, 11:07 p.m.
Duration: 8 minutes 38 seconds

Listed in: Technology

Episode 39 | Bloat vs zHeap | Composite Indexes | Unsafe Operations

Published: Nov. 19, 2018, 3:40 a.m.
Duration: 17 minutes 46 seconds

Listed in: Technology

Episode 38 | Parallel Query | Real Time Analytics | Killed Index Tuples

Published: Nov. 12, 2018, 1:10 a.m.
Duration: 9 minutes 54 seconds

Listed in: Technology

Episode 37 | Postgres Goodies | Materialized vs Rollup | Column Oriented

Published: Nov. 5, 2018, 1:33 a.m.
Duration: 17 minutes 36 seconds

Listed in: Technology

Episode 36 | Sharding | Giving Back | SCRAM | Partitioning Evolution

Published: Oct. 29, 2018, 2:49 a.m.
Duration: 10 minutes 52 seconds

Listed in: Technology

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

Published: Oct. 22, 2018, 12:19 a.m.
Duration: 17 minutes 8 seconds

Listed in: Technology

Episode 34 | Inserts | Nearest Neighbor | Freezing | Comment

Published: Oct. 15, 2018, 2:54 a.m.
Duration: 11 minutes 47 seconds

Listed in: Technology

Episode 33 | Per-Table Autovacuum | FDW Synchronization | Distinct On

Published: Oct. 8, 2018, 2:21 p.m.
Duration: 9 minutes 13 seconds

Listed in: Technology

Episode 32 | Sysadmin Concerns | Power of Indexing | pgbouncer Monitoring

Published: Oct. 1, 2018, 3:29 a.m.
Duration: 11 minutes 59 seconds

Listed in: Technology

Episode 31 | CTE Warning | PG 11 Features | Death by DB | Correlation

Published: Sept. 24, 2018, 3:13 a.m.
Duration: 15 minutes 46 seconds

Listed in: Technology

Episode 30 | Parallelism | JIT Compiling | Indexes | Administration

Published: Sept. 17, 2018, 3:08 a.m.
Duration: 9 minutes 46 seconds

Listed in: Technology

Episode 29 | Parallel Indexing | SQL vs. ORM | Logical Replication Upgrades

Published: Sept. 10, 2018, 3:04 a.m.
Duration: 13 minutes 28 seconds

Listed in: Technology

Episode 28 | Watch | Fast Text Search | Column Defaults | Import CSVs

Published: Sept. 3, 2018, 3:12 a.m.
Duration: 17 minutes 6 seconds

Listed in: Technology

Episode 27 | Multiple Databases | Slow Queries | Sorting Performance

Published: Aug. 27, 2018, 2:54 a.m.
Duration: 18 minutes 5 seconds

Listed in: Technology

Episode 26 | Join Costs | zHeap | Autovacuum Tuning

Published: Aug. 20, 2018, 3:06 a.m.
Duration: 9 minutes 40 seconds

Listed in: Technology

Episode 25 | generate_series | PG11 Partitioning | GPU Queries

Published: Aug. 13, 2018, 3:11 a.m.
Duration: 13 minutes 15 seconds

Listed in: Technology

Episode 24 | Full Text Search | JSONB_AGG | Upgrades | CIS

Published: Aug. 6, 2018, 3:04 a.m.
Duration: 12 minutes 32 seconds

Listed in: Technology

Episode 23 | UUIDs | Write Spikes | Distinct | SQL Standard

Published: July 30, 2018, 3:31 a.m.
Duration: 14 minutes 41 seconds

Listed in: Technology

Episode 22 | Concurrency | Listen & Notify | ZFS | pg_rewind

Published: July 23, 2018, 2:57 a.m.
Duration: 11 minutes 44 seconds

Listed in: Technology

Episode 21 | Using JSON | Procedures | Concurrency | Kubernetes

Published: July 16, 2018, 2:44 a.m.
Duration: 19 minutes 42 seconds

Listed in: Technology

Episode 20 | Declarative Partitioning | Permissions | Trigger Speed

Published: July 9, 2018, 3:22 a.m.
Duration: 14 minutes 41 seconds

Listed in: Technology

Episode 19 | 100K Tenants | Extensions | Query Planning | Crosstabs

Published: July 2, 2018, 5:11 a.m.
Duration: 17 minutes 43 seconds

Listed in: Technology

Episode 18 | Impact of Virtualization | Compressing Data | Parallelism

Published: June 25, 2018, 2:49 a.m.
Duration: 17 minutes 32 seconds

Listed in: Technology

Episode 17 | Real Time Analytics | Index Decrease Performance | work_mem

Published: June 18, 2018, 2:10 a.m.
Duration: 19 minutes 41 seconds

Listed in: Technology

Episode 16 | Storing Bits | Autovacuum | Assertions | Logical Recovery

Published: June 11, 2018, 3:48 a.m.
Duration: 11 minutes 58 seconds

Listed in: Technology

Episode 15 | Leveraging Postgres | Tuning Autovacuum | Slow Queries

Published: June 4, 2018, 3:10 a.m.
Duration: 12 minutes 3 seconds

Listed in: Technology

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

Published: May 28, 2018, 3:12 a.m.
Duration: 13 minutes 5 seconds

Listed in: Technology

Episode 13 | Sharding Future | Query Optimization | Replication Read Performance | PostGIS

Published: May 21, 2018, 3:26 a.m.
Duration: 16 minutes 1 second

Listed in: Technology

Episode 12 | The Future | Slow Counts | Avoid Or | Replication

Published: May 14, 2018, 3:22 a.m.
Duration: 11 minutes 13 seconds

Listed in: Technology

Episode 11 | Serializable | JSON & JSONB | Fast Data Loading | PG11 Features

Published: May 7, 2018, 3:55 a.m.
Duration: 12 minutes 14 seconds

Listed in: Technology

Episode 10 | ANSI Schmansi | Split-Brain | Performance Scenarios | Parallelism

Published: April 30, 2018, 3:24 a.m.
Duration: 12 minutes 13 seconds

Listed in: Technology

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

Published: April 23, 2018, 3:41 a.m.
Duration: 11 minutes 2 seconds

Listed in: Technology

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

Published: April 16, 2018, 3:27 a.m.
Duration: 15 minutes 7 seconds

Listed in: Technology

Episode 7 | Any Scale | Monitoring Vacuum | Copy | Annotated Config

Published: April 9, 2018, 3:10 a.m.
Duration: 11 minutes 10 seconds

Listed in: Technology