Date: 2015-11-27
Time: 11:00–11:45
Room: Lotse
Level: Intermediate
Talk is a categorized overview (together with some live showcases) of various PostgreSQL specific scripts, utilities and whole toolsets that DBA-s should be aware of for monitoring database performance, database logs and identifying/fixing most common adminstration problems around areas of general performance metrics, tuning, locking, indexing, bloat. Doesn't include backup, replication and clustering topics i.e. focus is more on working with a single running database. Covered tools include some known oldies from wiki.postgresql.org as well as some of my newer favourites from Github.