Month: September 2018
Correlation of PostgreSQL columns explained
After you ANALYZE a PostgreSQL table to collect value distribution statistics, you will find the gathered statistics for each column in the pg_stats system view. This article will explain the meaning of the correlation column and its impact on index scans. Physical vs. logical ordering Most common PostgreSQL data types have an ordering: they support […]
Next feature release for the pgwatch2 monitoring tool
With summer fading away it’s time to get busy again. During the last couple of weeks, I’ve taken time to work on our Open Source PostgreSQL monitoring tool pgwatch2 and added another batch of useful management / scaling features and some more minor enhancements. Those were requested by a couple of bigger organizations who are […]
PostgreSQL: Parallel CREATE INDEX for better performance
As of PostgreSQL 11 postgres users have the ability to create indexes in parallel. For many years various commercial database vendors have already offered this feature and we are glad that PostgreSQL is part of this elite club, which offers multi-core index creation that will dramatically improve the usability of large database deployments in the […]