Deep dive into PostgreSQL statistics.

Slides from Highload++ 2015 (Moscow, Russia).

PostgreSQL is a huge system which consists of many subsystems, whose work determines the performance of PostgreSQL. During lifetime, postgres ensures the  statistics tracking of the components, which allows to evaluate the effectiveness of PostgreSQL and to take action to improve performance. However, most of this information is presented in a rather simplified way. Processing this information and its interpretation is often quite trivial task, and the numerous tools and utilities easily confound even the advanced DBA.

The report will discuss the statistics collector and  which information is available to assess the effectiveness of PostgreSQL, how to get it without resorting the numerous tools. How to interpret and use the information, how to find bottlenecks, eliminate them and improve the performance of PostgreSQL.


Discover Highload++

Comments

  1. I can set up my new idea from this post. It gives in depth Thanks for this valuable information for all,..
    Scuba Diving in Cabo

    ReplyDelete

Post a Comment

Popular Posts