Himalaya: Listen. Learn. Grow.

4.8K Ratings
Open In App
title

Scaling Postgres

Creston Jamison

0
Followers
5
Plays
Scaling Postgres

Scaling Postgres

Creston Jamison

0
Followers
5
Plays
OVERVIEWEPISODESYOU MAY ALSO LIKE

Details

About Us

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.

Latest Episodes

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.

17 min3 d ago
Comments
Postgres 13 RC1 | Upgrading at Scale | With Ties | HOT Updates

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.

15 min1 w ago
Comments
Slow Archival | Index Improvements | Node Metrics | Join or Subquery

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.

15 min2 w ago
Comments
External Compression | Parallel Vacuum | JSON Aggregates | JSON & Arrays

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.

15 min3 w ago
Comments
28 Tips | Lucky 13 | Autovacuum Tuning | Logical Pitfalls

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.

16 minAUG 24
Comments
Statistics Speed Up | Synchronous Commits | TLS Updates | Avoiding Cursors

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.

14 minAUG 17
Comments
Recursive Queries | Lateral Joins | Pagination | JSONB Arrays

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.

14 minAUG 10
Comments
BRIN Pitfalls | pg_stat_statement Troubleshooting | Natural Join | Geography Type

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.

15 minAUG 3
Comments
Scaling Suggestions | Slot Safety | SCRAM Channel Binding | Effective Cache Size

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.

15 minJUL 27
Comments
Partition Migration | Like Performance | Best Fillfactor | In-Memory Tables

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.

13 minJUL 20
Comments
JSONB Types | Earth Distance | Dates, Times & Intervals | Authentication

Latest Episodes

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.

17 min3 d ago
Comments
Postgres 13 RC1 | Upgrading at Scale | With Ties | HOT Updates

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.

15 min1 w ago
Comments
Slow Archival | Index Improvements | Node Metrics | Join or Subquery

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.

15 min2 w ago
Comments
External Compression | Parallel Vacuum | JSON Aggregates | JSON & Arrays

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.

15 min3 w ago
Comments
28 Tips | Lucky 13 | Autovacuum Tuning | Logical Pitfalls

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.

16 minAUG 24
Comments
Statistics Speed Up | Synchronous Commits | TLS Updates | Avoiding Cursors

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.

14 minAUG 17
Comments
Recursive Queries | Lateral Joins | Pagination | JSONB Arrays

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.

14 minAUG 10
Comments
BRIN Pitfalls | pg_stat_statement Troubleshooting | Natural Join | Geography Type

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.

15 minAUG 3
Comments
Scaling Suggestions | Slot Safety | SCRAM Channel Binding | Effective Cache Size

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.

15 minJUL 27
Comments
Partition Migration | Like Performance | Best Fillfactor | In-Memory Tables

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.

13 minJUL 20
Comments
JSONB Types | Earth Distance | Dates, Times & Intervals | Authentication
success toast
Welcome to Himalaya LearningDozens of podcourses featuring over 100 experts are waiting for you.