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
    Replies
    1. You may also be interested in the following post about managing PostgreSQL statistics with one of our popular tools - pgCenter: https://blog.dataegret.com/2018/10/pgcenter-stress-free-postgres-stats.html#more

      Delete

Post a Comment

You might also be interested in

pgCenter - stress free Postgres stats.

Deep dive into Postgres stats: pg_stat_progress_vacuum

Deep dive into postgres stats: pg_stat_bgwriter