PgConf.Russia 2017 talks

PostgreSQL Diagnostics from the standpoint of a system administrator (not a DBA)

Nicholas Sivko, Co-founder

Co-founder of the monitoring service, formerly leader of the maintenance department.

It often happens that you already have PosgtreSQL in production, but you don’t have a DBA. To demystify the PostgreSQL database, I’ll tell you how to troubleshoot various problems while working with PosgtreSQL. We will try to understand how to answer "routine" questions of a typical system administrator: - Is everything OK with the database? - What consumes DB server resources? - What to optimize first to reduce resource consumption?