background

Scaling Postgres Episodes

Episodes on how best to scale your PostgreSQL relational database.

132 small

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

In this episode of Scaling Postgres, we discuss the release of Postgres 13 RC1, how to upgrade Postgres at scale, using limit with ties and understanding Heap Only Tuple (HOT) updates.
131 small

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

In this episode of Scaling Postgres, we discuss slow WAL archival, index improvements coming for Postgres 13, accessing node metrics via SQL and deciding between a join or subquery.
130 small

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

In this episode of Scaling Postgres, we discuss external compression, vacuuming in parallel, working with JSON Aggregates and the JSON & Array datatypes.
129 small

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

In this episode of Scaling Postgres, we discuss 28 tips & tricks, Postgres 13 is lucky, autovacuum tuning and logical replication pitfalls.
128 small

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

In this episode of Scaling Postgres, we discuss speeding up performance with statistics, setting synchronous_commit, updates to TLS settings and how to avoid cursors.
127 small

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

In this episode of Scaling Postgres, we discuss recursive queries, using lateral joins, paging through a data sets efficiently and working with JSONB arrays.
126 small

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.
125 small

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.
124 small

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.
123 small

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.
Next Page