PGConf NYC 2021 - How we made PG Fitter, Happier, More Productive by Andrew Atkinson

Channel:
United States Confreaks
Subscribers:
42,400
Published on ● Video Link: https://www.youtube.com/watch?v=6pO41Gx43QU


Duration: 45:49
26 views
0

How we made PG Fitter, Happier, More Productive by Andrew Atkinson

This talk will walk through a series of improvements made to our PostgreSQL 10 databases to improve performance, increase operational efficiency, and tune parameters. Some of the techniques were to add monitoring, remove and replace indexes, remove bloat, and split tables into a new database without application downtime.



Other Videos By Confreaks


2022-10-12PGConf NYC 2021 - Row Level Security Explained by Stephen Frost
2022-10-12PGConf NYC 2021 - Advanced Int - Bigint Conversions by Robert Treat
2022-10-12PGConf NYC 2021 - Identifying Slow Queries and Fixing Them! by Stephen Frost
2022-10-12PGConf NYC 2021 - PostgreSQL Query Performance Insights by Hamid Quddus Akhtar
2022-10-12PGConf NYC 2021 - Advanced Data Types in PostgreSQL by Andreas Scherbaum
2022-10-12PGConf NYC 2021 - NORM: No ORM Framework by Henrietta Dombrovskaya
2022-10-12PGConf NYC 2021 - Speaking and Community Involvement for the Introvert by Pat Wright
2022-10-12PGConf NYC 2021 - Get Your Insecure PostgreSQL Passwords to SCRAM! by Jonathan S. Katz
2022-10-12PGConf NYC 2021 - NORM: No ORM Framework by Henrietta Dombrovskaya
2022-10-12PGConf NYC 2021 - Navigate Postgres Cloud Paths: Kubernetes, IaaS, or DbaaS by Marc Linster
2022-10-12PGConf NYC 2021 - How we made PG Fitter, Happier, More Productive by Andrew Atkinson
2022-10-12PGConf NYC 2021 - Flexible Indexing with Postgres by Bruce Momjian
2022-10-12PGConf NYC 2021 - How PostgreSQL aggregates work and how to create and use custom... by David Kohn
2022-10-12PGConf NYC 2021 - A Deep Dive into PostgreSQL Indexing by Ibrar Ahmed
2022-10-12PGConf NYC 2021 - PostgreSQL sharding, state of the art by Julien Tachoires
2022-10-12PGConf NYC 2021 - Teaching elephants to fish by Ryan Booz
2022-10-12PGConf NYC 2021 - Migration validation made easy with Ora2Pg by Gilles Darold
2022-10-12PGConf NYC 2021 - Chasing unicorns : 0 dataloss and 99.999% availability by Laetitia Avrot
2022-10-12PGConf NYC 2021 - Evolution Of PostgreSQL Replication and High Availability... by Stacy Scoggins
2022-10-12PGConf NYC 2021 - Pglog: a flexible log analyser by Laetitia Avrot
2022-10-12PGConf NYC 2021 - When it all GOes right by Pavlo Golub


Tags:
PostgreSQL
PGConf
Postgres