Whats slowing down my database a Dev-Ops approach
My passion in live is problem solving. This leads to a wide area of interests ranging form robotics,astonomy to boardgames.
No video of the event yet, sorry!
Dev-Ops. Imagine the following "Developer commits new feature. Feature passes Automate test. Feature gets Deployed. Oh no ... everything is slow."
This talk is aimed to provide methods and tools on how to identify slow and problematic queries on a database cluster and how to address and solve these problems. The second part of the talk will be aimed at lessons learned in our company and how we addressed these issues to solve these day to day problems
We will dive into
- pg_stat_activity and pg_stat_statements (setup and interpretation)
- Analysing why a query is slow (use of visual tools)
- How to optimise your query (Index, joins, ect)
- Lessons learned (Real live examples)
- Why more hardware doesn't always solve your problems.
- (Lessons learned) "Idle in transactions" why this is bad if transactions aren't ended
- (Lessons learned) High access tables slowing down overtime (autovacuum issues)
- (Lessons learned) Don't disable autovacuum (basic overview of autovacuum, why it is good)
- (Lessons learned) autovacuum settings for frequantly accesssed/updated tables to adress bloat
- (Lessons learned) Why Temp Tables are a bad idea and practical alternative suggestions.
- 2019 March 20 09:00
- 50 min
- Sugar Hill
- Postgres Conference
- Ops and Administration