Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

November 04, 2019 Partitioning, Logical Replication Upgrade, Columnar Compression, HAProxy Connections | Scaling Postgres 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, visit:
https://www.scalingpostgres.com/episodes/88-partitioning-logical-replication-upgrade-columnar-compression-haproxy-connections/
15 min
October 28, 2019 pg_receivewal, Application Failover, pg_checksums, pgBouncer | Scaling Postgres 87
In this episode of Scaling Postgres, we discuss the benefits of pg_receivewal, how to setup simple application failover, new pg_checksums and setting up pgBouncer.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/87-pg_receivewal-application-failover-pg_checksums-pgbouncer/
13 min
October 20, 2019 Prewarming, Nondeterministic Collations, Generated Column Performance, Foreign Keys | Scaling Postgres 86
In this episode of Scaling Postgres, we discuss prewarming your cache, working with nondeterministic collations, generated column performance and foreign keys with partitions.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/86-prewarming-nondeterministic-collations-generated-column-performance-foreign-keys/
16 min
October 14, 2019 Recovery Configuration, Alter System, Transaction Isolation, Temp Table Vacuum | Scaling Postgres 85
In this episode of Scaling Postgres, we discuss changes to recovery configuration, the alter system command, transaction isolation and vacuum for temp tables.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/85-recovery-configuration-alter-system-transaction-isolation-temp-table-vacuum/
15 min
October 07, 2019 Postgres 12 Released, Generated Columns, Parallel Estimates, Change Data Capture | Scaling Postgres 84
In this episode of Scaling Postgres, we discuss the release features of Postgres 12, generated columns, parallel estimates and change data capture.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/84-postgres-12-released-generated-columns-parallel-estimates-change-data-capture/
13 min
September 30, 2019 Postgres 12, Window Frames, Index Types, Synchronous Replication | Scaling Postgres 83
In this episode of Scaling Postgres, we discuss the release of Postgres 12, how to use window frames, the different index types, and when to use synchronous replication.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/83-postgres-12-window-frames-index-types-synchronous-replication/
14 min
September 23, 2019 Faster Partitions, Count Speed, Extensions, Education | Scaling Postgres 82
In this episode of Scaling Postgres, we discuss faster partition performance, count speed, extensions and Postgres education.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/82-faster-partitions-count-speed-extensions-education/
13 min
September 16, 2019 Data Loading Speed, View Dependencies, Users & Roles, H/A Clusters | Scaling Postgres 81
In this episode of Scaling Postgres, we discuss data loading speeds, view dependencies, users & roles and high availability clusters.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/81-data-loading-speed-view-dependencies-users-roles-high-availability-clusters/
13 min
September 09, 2019 Just Upgrade, Vacuum Updates, Connection Strings, Postgres Showcase | Scaling Postgres 80
In this episode of Scaling Postgres, we discuss why you should just upgrade, vacuum updates in Postgres 12, psql connection strings and a Postgres showcase.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/80-just-upgrade-vacuum-updates-connection-strings-postgres-showcase/
14 min
September 02, 2019 PgBouncer SCRAM, Art of PostgreSQL, Distributed Time-Series, Window Functions | Scaling Postgres 79
In this episode of Scaling Postgres, we discuss PgBouncer SCRAM support, The Art of PostgreSQL, making Postgres a distributed time-series DB and window functions.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/79-pgbouncer-scram-art-of-postgresql-distributed-time-series-window-functions/
11 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…