Podcast Episodes

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

Episode 127

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

To get the show notes as well as get noti…

Published on 5 years, 4 months ago

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

Episode 126

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.

To get the show notes as well a…

Published on 5 years, 4 months ago

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

Episode 125

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…

Published on 5 years, 4 months ago

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

Episode 124

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.

To get the sh…

Published on 5 years, 4 months ago

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

Episode 123

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

To get the show notes as well as …

Published on 5 years, 5 months ago

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

Episode 122

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

To get the show notes as well as ge…

Published on 5 years, 5 months ago

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

Episode 121

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

To get the show notes as well as get not…

Published on 5 years, 5 months ago

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

Episode 120

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.

To get the show notes as well a…

Published on 5 years, 5 months ago

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

Episode 119

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

To get the show notes as …

Published on 5 years, 6 months ago

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

Episode 118

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.

To get the sho…

Published on 5 years, 6 months ago