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
PostgreSQL Bloatbusters.
Or when the vacuum is not enough. Anyone who works with PostgreSQL, whether a DBA or a developer, at some point encountered vacuum. All DBAs have configured…
Deep dive into Postgres stats: pg_stat_progress_vacuum
Yet another post about vacuum… In today’s post I would like to talk about another stats enhancement that has been added in 9.6 and I hope will…
Новые диагностические тулзы на нашем сайте
Четыре небольших запроса которые помогут вам в работе с PostgreSQL С выходом новой версии PotsgreSQL 10.0 мы решили предложить вам, нашим читателям, проверить насколько хорошо настроена ваша…
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