Postgres Performance and Maintenance
Joshua D. Drake is a PostgreSQL Consultant and has been consulting on PostgreSQL since Postgres95. He is the founder and lead consultant of Command Prompt, Inc., the oldest of the Postgres companies. Throughout his PostgreSQL career he has performed a variety of functions within the community including releasing an O'Reilly book on PostgreSQL, being part of the sysadmins and advocacy teams. Further he ran a biannual conference series dedicated to PostgreSQL between the years of 2007 - 2011. He is a former Director for SPI (the non-profit for PostgreSQL.org). Lastly he is also a Founder of United States PostgreSQL.
No video of the event yet, sorry!
When you are optimizing PostgreSQL it is usually maintenance that goes by the wayside. How do we fix autovacuum? Where did all of this bloat come from? Why am I getting IO spikes? How do I get RDS to behave?! Why are commits so slow on replication? The answer to all of these questions is understanding the relationship between proper Postgres maintenance and performance. Join us for a 3 hour jaunt through the wily world of making Postgres Go!
- 3 h
- PGConf Local: Philly 2017 [PgConf.US]
- Requires Registration:
- Yes (Registered: 0/25)