Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

August 24, 2020 Statistics Speed Up, Synchronous Commits, TLS Updates, Avoiding Cursors | Scaling Postgres 128
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.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/128-statistics-speed-up-synchronous-commits-tls-updates-avoiding-cursors/
17 min
August 17, 2020 Recursive Queries, Lateral Joins, Pagination, JSONB Arrays | Scaling Postgres 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 notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/127-recursive-queries-lateral-joins-pagination-jsonb-arrays/
15 min
August 09, 2020 BRIN Pitfalls, pg_stat_statement Troubleshooting, Natural Join, Geography Type | Scaling Postgres 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 as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/126-brin-pitfalls-pg_stat_statement-troubleshooting-natural-join-geography-type/
15 min
August 03, 2020 Scaling Suggestions, Slot Safety, SCRAM Channel Binding, Effective Cache Size | Scaling Postgres 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_size.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/125-scaling-suggestions-slot-safety-scram-channel-binding-effective-cache-size/
15 min
July 27, 2020 Partition Migration, Like Performance, Best Fillfactor, In-Memory Tables | Scaling Postgres 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 show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/124-partition-migration-like-performance-best-fillfactor-in-memory-tables/
16 min
July 19, 2020 JSONB Types, Earth Distance, Dates, Times & Intervals, Authentication | Scaling Postgres 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 get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/123-jsonb-types-earth-distance-dates-times-intervals-authentication/
14 min
July 13, 2020 Postgres is Fine, Generated Columns, Postgres Inserts, Synchronous Replication | Scaling Postgres 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 get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/122-postgres-is-fine-generated-columns-postgres-inserts-synchronous-replication/
11 min
July 06, 2020 Fantastic Data Types, Domain Data Types, Insert Performance, Row Differences | Scaling Postgres 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 notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/121-fantastic-data-types-domain-data-types-insert-performance-row-differences/
17 min
June 28, 2020 Postgres 13 Beta 2, System Stats Extension, Tuned, Join Strategy | Scaling Postgres 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 as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/120-postgres13-beta2-system-stats-extension-tuned-join-strategy/
13 min
June 22, 2020 Replication Complications, One Word Performance, Pgbouncer Users, Serializable Isolation | Scaling Postgres 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 well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/119-replication-complication-one-word-performance-pgbouncer-users-serializable-isolation/
16 min

About Scaling Postgres

From the publisher's feed

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…