Why avoid long transactions?
The majority of PostgreSQL community clearly understands why long and idle transactions are “bad”. But when you talk about it to the newcomers it’s always a good…
Filters
Let’s speed things up.
Parallelism settings and how to accelerate your database performance. Few days ago, when performing a routine audit for our client, we noticed that parallel queries in the…
PostgreSQL Performance Meltdown?
Overview On the 30th of December 2017, Kernel page-table isolation (PTI) patch had been merged with the mainline. Its main goal was to mitigate the Meltdown…
Deep dive into postgres stats: pg_stat_user_indexes
Everything you always wanted to know about Postgres stats One of the major strengths of PostgreSQL are indexes – they are flexible and cover almost all use…
Deep dive into postgres stats: pg_stat_all_tables
Everything you always wanted to know about Postgres stats Today’s post is about pg_stat_all_tables. This view contains various statistics about tables usage and may be useful in…
Autovacuum, explained for engineers, new improved version PGConf.eu 2015 Vienna
Autovacuum, explained for engineers, new improved version PGConf.eu 2015 Vienna from PostgreSQL-Consulting Lots of things improved, now these slides can be more useful without talk