pgCenter — stress free Postgres stats.
pgCenter has seen a new release with several significant changes. If you used pgCenter before, you might have noticed that I stopped issuing updates for a while….
Фильтры
Autovacuum slides from PgCon 2018 Ottawa
Slides from our talks at PgCon 2018. This week was busy for me and my colleague Ilya Kosmodemiansky as we made our way to Ottawa, Canada to…
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…
pg_wal is too big… what’s going on?
What’s common between DBA and detective? They both solve murder and mystery while trying to make sense of the nonsense. Recently, one of our clients had Postgres…
Waiting for PostgreSQL 11: Covering + unique indexes.
Indexes with INCLUDE columns and their support in B-tree Last weekend, a very useful patch was committed, that enhances an already extensive Postgres indexing functionality. commit 8224de4f42ccf98e08db07b43d52fed72f962ebb…
Waiting for PostgreSQL 11: Online enabling of data checksums.
Enable data page checksums on the fly without the database interruption. New interesting patch was committed on Thursday, 5 Apr. Upd. Unfortunately this patch was reverted, and we…