Scaling Postgres Episodes

Episodes on how best to scale your PostgreSQL relational database.

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

In this episode of Scaling Postgres, we discuss BRIN pitfalls, using pg_stat_statements for troubleshooting, natural joins to detect duplicates and the geography type.

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

In this episode of Scaling Postgres, we discuss suggestions for scaling postgres, replication slots safety, implementing scram password authentication with channel binding and setting effective_cache_size.

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

In this episode of Scaling Postgres, we discuss how best to migrate to using partitions, like & ilike performance, determining the best fillfactor and the work towards in-memory tables.

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

In this episode of Scaling Postgres, we discuss working with JSONB types, calculating earth distance, utilizing dates, times & intervals and Postgres authentication.

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

In this episode of Scaling Postgres, we discuss determining if Postgres is fine, generated columns vs. triggers, insert features and synchronous replication usage.

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

In this episode of Scaling Postgres, we discuss fantastic data types, custom domain data types, improving insert performance and how to query row differences.

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

In this episode of Scaling Postgres, we discuss Postgres 13 Beta 2, a system stats extension, tuning your operating systems for Postgres and different join strategies.

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

In this episode of Scaling Postgres, we discuss replication complications, adding one word to boost performance, handling pgbouncer users and serializable isolation testing.

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

In this episode of Scaling Postgres, we discuss safety systems, the purpose and existence of failover slots, complications with transaction IDs and how to repartition without downtime.

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

In this episode of Scaling Postgres, we discuss index deduplication in Postgres 13, fast hierarchical access, more essential monitoring and cloud native Postgres.

Next Page