Podcast Episodes

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

Episode 97

In this episode of Scaling Postgres, we discuss tips & tricks, how to get faster APIs, full text search considerations and pgbouncer_fdw.

To get the show notes as well as get notified of new episodes…

Published on 5 years, 11 months ago

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

Episode 96

In this episode of Scaling Postgres, we discuss user account configuration, pricing, the system identifier and the HyperLogLog extension.

To get the show notes as well as get notified of new episodes…

Published on 5 years, 11 months ago

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

Episode 95

In this episode of Scaling Postgres, we discuss max_locks_per_transaction, logical replication, managing backup & recovery and pgbouncer connection pooling.

To get the show notes as well as get notif…

Published on 5 years, 11 months ago

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

Episode 94

In this episode of Scaling Postgres, we discuss the State of Postgres, how best to dump your database, setting configuration parameters and managing partial WAL files.

To get the show notes as well a…

Published on 6 years ago

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

Episode 93

In this episode of Scaling Postgres, we discuss logical replication aspects, how to monitor queries, investigating a SQL beautifier and removing incomplete startup packet.

To get the show notes as we…

Published on 6 years ago

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

Episode 92

In this episode of Scaling Postgres, we discuss book sales, boosts to b-tree indexes, more Postgres 12 features and how to setup and use pgBackRest.

To get the show notes as well as get notified of n…

Published on 6 years ago

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

Episode 91

In this episode of Scaling Postgres, we discuss global indexes, ways to cache aggregates, how vacuum processing works and the purpose of effective cache size.

To get the show notes as well as get not…

Published on 6 years ago

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

Episode 90

In this episode of Scaling Postgres, we discuss chaos order, pub sub, petabyte scale analytics and PgBouncer connections.

To get the show notes as well as get notified of new episodes, visit: 

https:…

Published on 6 years, 1 month ago

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

Episode 89

In this episode of Scaling Postgres, we discuss Postgres 12 performance impressions, mystery solving, GiST and SP-GiST performance and k-anonymity.

To get the show notes as well as get notified of ne…

Published on 6 years, 1 month ago

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

Episode 88

In this episode of Scaling Postgres, we discuss partitioning, logical replication upgrades, columnar compression and HAProxy connections.

To get the show notes as well as get notified of new episodes…

Published on 6 years, 1 month ago