Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

June 06, 2021 Managing Autovacuum, Better JSON, Avoiding Updates, OS Tuning | Scaling Postgres 168
In this episode of Scaling Postgres, we discuss managing autovacuum, better JSON in Postgres 14, how to avoid redundant updates and operating system tuning.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/168-managing-autovacuum-better-json-avoiding-updates-os-tuning/
17 min
May 30, 2021 Interpreting Explain Analyze, Bulk Loading Data, Limiting Update & Delete, pg_buffercache | Scaling Postgres 167
In this episode of Scaling Postgres, we discuss how to interpret explain analyze, the best ways to load data in bulk, how to limit rows affected by update or delete and using pg_buffercache.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/167-interpreting-explain-analyze-bulk-data-loading-limiting-update-delete-pg_buffercache/
19 min
May 23, 2021 Postgres 14 Beta 1, PG 14 Improvements, Best Primary Keys, Composite Keys | Scaling Postgres 166
In this episode of Scaling Postgres, we discuss the release of Postgres 14 Beta 1, different PG 14 improvements, choosing the best type of primary key and using composite keys.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/166-postgres-14-beta1-pg14-improvements-best-primary-keys-composite-keys/
17 min
May 16, 2021 Postgres Releases, Data Warehouses, Exclusion Operators, Read-Only Users | Scaling Postgres 165
In this episode of Scaling Postgres, we discuss the newest Postgres releases, implementing a data warehouse, using exclusion operators and setting up read-only users.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/165-postgres-releases-data-warehouses-exclusion-operators-read-only-users/
14 min
May 09, 2021 Fast Random Rows, Fast Distinct Queries, Temp & Unlogged Tables, Terminating Connections | Scaling Postgres 164
In this episode of Scaling Postgres, we discuss selecting random rows quickly, faster distinct queries, how replication handles temp and unlogged tables and how to terminate connections.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/164-fast-random-rows-fast-distinct-queries-temp-unlogged-tables-terminating-connections/
18 min
May 02, 2021 SQL Data Analysis, pgBouncer Setup, Understanding Deadlocks, Tuning & Optimization | Scaling Postgres 163
In this episode of Scaling Postgres, we discuss doing data analysis with SQL, sophisticated pgBouncer set ups, understanding how to avoid deadlocks and an intro to tuning and optimization.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/163-sql-data-analysis-pgbouncer-setup-understanding-deadlocks-tuning-optimization/
16 min
April 25, 2021 Custom Data Types, Row Level Triggers, Dynamic pl/pgsql Columns, citext Usage | Scaling Postgres 162
In this episode of Scaling Postgres, we discuss implementing row level triggers, how to return dynamic columns using pl/pgsql, and when to use citext.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/162-custom-data-types-row-level-triggers-dynamic-plpgsql-columns-citext-usage/
11 min
April 18, 2021 Scaling Lessons, Synchronous Commit, Connection Management, BLOB Cleanup | Scaling Postgres 161
In this episode of Scaling Postgres, we discuss 5 years of scaling lessons, working with synchronous commit, managing connections and cleaning up BLOBs.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/161-scaling-lessons-synchronus-commit-connection-management-blob-cleanup/
19 min
April 11, 2021 psql Tips, Postgres 13 Upgrade, Roles Hierarchy, Replica Scaling | Scaling Postgres 160
In this episode of Scaling Postgres, we discuss tips for using psql, stories from a Postgres 13 upgrade, exploring the role hierarchy and replica scaling considerations.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/160-psql-tips-postgres-13-upgrade-roles-hierarchy-replica-scaling/
10 min
April 04, 2021 Tablespaces, Streaming Replication, More Postgres 14, Security | Scaling Postgres 159
In this episode of Scaling Postgres, we discuss when to use tablespaces, setting up streaming replication, features coming in Postgres 14 and implementing security.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/159-tablespaces-streaming-replication-more-postgres-14-security/
10 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…