Scaling Postgres Episodes

Episodes on how best to scale your PostgreSQL relational database.

Scaling Postgres Episode 193 Entity-Attribute-Value Design | JSON Subscripting | mysql-fdw Push-down | New Regex

In this episode of Scaling Postgres, we discuss using entity-attribute-value designs, new JSON subscripting capabilities, the mysql-fdw support for aggregate pushdowns and new regex functions in PG 15.

Scaling Postgres Episode 192 Foreign Key Indexes | Graph Queries | Linux Huge Pages | Text Column Size

In this episode of Scaling Postgres, we discuss if foreign keys should have indexes, how to run graph queries, how to configure Linux huge pages and the benefits as well as text size similarities.

Scaling Postgres Episode 191 Man-In-The-Middle | pg_auto_failover | Lesser Known Features | LZ4 Compression

In this episode of Scaling Postgres, we discuss new releases of Postgres due to a man-in-the-middle vulnerability, the high availability solution pg_auto_failover, lesser known Postgres features and LZ4 compression.

Scaling Postgres Episode 190 Hello Babelfish | Planner Deconstruction | Exist & Not Exist | Fun With SQL

In this episode of Scaling Postgres, we discuss the open sourcing of Babelfish, deconstructing the Postgres planner, when to avoid exist & not exist and having fun with SQL.

Scaling Postgres Episode 189 Index Downsides | TCP Keep Alive | Development with Postgres | Learning PL/pgSQL

In this episode of Scaling Postgres, we discuss the downsides of indexes, TCP keep alive options, developing with Postgres as your DB and learning PL/pgSQL.

Scaling Postgres Episode 188 Automatic Indexing | Function Pipelines | With Hold Cursors | Query Scans

In this episode of Scaling Postgres, we discuss automatic indexing, function pipelines, with hold cursors and the different query scans.

Scaling Postgres Episode 187 Sharding | Federation | Linux HugePages | Performance Tuning

In this episode of Scaling Postgres, we discuss one method to shard a database, federating your database, the benefits of configuring linux HugePages and performance tuning.

Scaling Postgres Episode 186 Select For Update | PGx Framework | Cool Additions | Full-Text Search

In this episode of Scaling Postgres, we discuss select for update, the pgx framework to generate extensions, cool additions to Postgres 14 and full-text search.

Scaling Postgres Episode 185 Postgres 14 Released | Using JSON | Not Using Indexes | Sequence Gaps

In this episode of Scaling Postgres, we discuss the release of Postgres 14, how best to use JSON, why are your indexes not being used and sequence gaps.

Scaling Postgres Episode 184 Postgres 14 RC1 | Little Things | Index Advisor | Million Inserts

In this episode of Scaling Postgres, we discuss Postgres 14 RC1, little improvements in PG14, an index advisor and how to handle 1 million insert statements.

Next Page