Ускоряем VACUUM в PostgreSQL
Пару дней назад к нам поступил вопрос – можно ли ускорить процесс VACUUMа на больших таблицах в момент когда процесс уже запущен. В кратце, нет, VACUUM ускорить…
Filters
Vacuuming update-heavy tables
In my previous post I gave an overview of some general parameters that will work well in a standard setting. They might be aggressive, but will allow…
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…
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…