Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

April 16, 2018 Scaling Real-Time Analytics, Covering Indexes, 1,500 Upgrades | Scaling Postgres 8
In this episode of Scaling Postgres, we review articles covering real-time analytics at scale, covering indexes in Postgres 11, 1,500 Postgres upgrades and PostgreSQL vs. MySQL.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/8-scaling-analytics-covering-indexes-1500-upgrades/
16 min
April 09, 2018 Any Scale, Monitoring Vacuum, Copy, Annotated Config | Scaling Postgres 7
In this episode of Scaling Postgres, we review articles covering Postgres at any scale, monitoring vacuum, using copy, annotated config files, and how to do easy replication failback to an old primary database.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/7-any-scale-monitor-vacuum-copy-annotated-config/
12 min
April 02, 2018 Terabyte Scale, Permissions, Fast Column Adds, pgBouncer | Scaling Postgres 6
In this episode of Scaling Postgres, we review articles covering terabyte scale & analytics, database permissions, fast column adding coming to PosgreSQL 11 and pgBouncer.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/6-terabyte-scale-permissions-fast-column-add-pgbouncer/
11 min
March 26, 2018 Constraints, User Order, PG Terrible, Logical Upgrades | Scaling Postgres 5
In this episode of Scaling Postgres, we review articles covering database constraints, user defined ordering, how PostgreSQL is terrible, TimeScaleDB and using logical replication for upgrades.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/5-constraints-user-order-pg-terrible-logical-upgrades/
15 min
March 19, 2018 50TB Upgrade, Vacuum, DB Security | Scaling Postgres 4
In this episode of Scaling Postgres, we review articles covering developers loving PostgreSQL, a 50TB database upgrade, information on vacuums, patches for parallel PostGIS plans, database security concerns, DB normalization and primary keys and generate series.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/4-50TB-upgrade-vacuum-db-security/
13 min
March 12, 2018 Modeling, Query Performance, Statistics, pgmetrics | Scaling Postgres 3
In this episode of Scaling Postgres, we review articles covering modeling, checking for long queries using pg_stat_statements, statistics in PosgreSQL 10 and pgmetrics.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/3-modeling-query-performance-statistics-pgmetrics/
10 min
March 05, 2018 Analytical DBs, Recursive Queries, Replication | Scaling Postgres 2
In this episode of Scaling Postgres, we review articles covering analytical DBs (potentially using GPUs), recursive queries and different forms of replication.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/2-analytical-db-recursive-queries-replication/
18 min
February 27, 2018 Petabyte Scale and Locking | Scaling Postgres 1
In this episode of Scaling Postgres, we review articles covering petabyte scale techniques as well as various articles on locking.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/1-petabyte-scale-and-locking/
18 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…