Linux tuning for PostgreSQL at Secon’2015
Slides from Secon’2015 – Software Developers Conference. Penza, The database is an essential element of any project. The database must be stable and provide good performance. If you…
Filters
Linux Performance Observability Tools. Sysstat.
We continue the series of posts about tools for performance monitoring. Today I would like to tell discuss sysstat package. This is a very interesting package. First of all,…
PostgreSQL autovacuum, explained for engeneers – slides from PostgreSQL Meetup at Zalando Berlin HQ
At the first Russian PGDay there was a sort of joke, right after PostgreSQL DBA tutorial: “we need an autovacuum tutorial”. The topic is utmost important, poor…
Warning: pgstat wait timeout… pgstat what???
pgstat wait timeout, what does it mean? Today I would like to tell about warning message “pgstat wait timeout“. Pretty uninformative message, right? If you see this…
Linux Performance Observability Tools. Top.
Linux Performance Observability Tools. Top. Picture is a courtesy of Brendan Gregg Blog. Given above are Linux Performance Observability Tools. At a first glance, the picture may…