Visibility map arrives

Since Heikki doesn't have a blog of his own, I will take it upon myself to blog about this one: he has just committed the initial version of the visibility map feature for PostgreSQL 8.4.

In short, this means that VACUUM will now only need to visit pages in a table that has actually changed. So if you have a large table where only a very few rows change, VACUUM will require significantly less CPU and I/O to run. With this lower cost, it's also possible to run VACUUM more often on large tables - if nothing at all has changed, it's more or less a no-op!

In the future, the hope is to be able to build on this patch to implement things like index-only scans - but that's for another version.

Yet another great feature for 8.4 - this is shaping up to be a very good release I think.


Comments

This is the kind of advancements that justify the upgrade worth any adaptation work!

Posted on Dec 3, 2008 at 15:11 by Vincenzo Romano.

This will be a great release, PostgreSQL will definitely have the most complete SQL dialect amongst opensource databases with CTE and Window Queries!

Posted on Dec 3, 2008 at 19:48 by pabloj.

Conferences

I speak at and organize conferences around Open Source in general and PostgreSQL in particular.

Upcoming

FOSDEM PGDay 2020
Jan 31-Feb 2, 2020
Brussels, Belgium
SCALE 18x
Mar 5-8, 2020
Pasadena, USA
Nordic PGDay 2020
Mar 24-20, 2020
Helsinki, Finland
PGCon 2020
May 26-29, 2020
Ottawa, Canada
PGConf.EU 2020
Oct 20-23, 2020
Berlin, Germany

Past

PGDaySF 2020
Jan 21, 2020
San Francisco, USA
Stockholm PostgreSQL Meetup
Dec 3, 2019
Stockholm, Sweden
Berlin PostgreSQL Meetup
Nov 21, 2019
Berlin, Germany
Chicago PostgreSQL Meetup
Nov 12, 2019
Chicago, USA
PGConf.EU 2019
Oct 15-18, 2019
Milan, Italy
More past conferences