Monat: November 2015

Introduction to pg_stat_activity.

PostgreSQL RDBMS has a very informative built-in tools to track the state of the database. One such tool is pg_stat_activity. This is a system view that allows…

PostgreSQL Performance Observability

PostgreSQL Performance Observability or Where PostgreSQL spends his time.

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…