Visibility map arrives

Magnus Hagander's PostgreSQL blog

Wednesday, December 3. 2008

Posted by Magnus Hagander in PostgreSQL

Comments (2)
Trackbacks (2)

2841 hits

Defined tags for this entry: PostgreSQL

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.

Trackbacks

Trackback specific URI for this entry

Visibility Map
Magnus benden önce bloglamış -- Visibility map PostgreSQL'e girdi. 8.4'e eklenen birçok yeni özellikten birisi. VACUUM işlemlerinin işlemci ve disk üzerine etkisini önemli oranda azaltacak ve belirgin şekilde başarım artışları sağlayacak bir özellik. T

Weblog: MadBlog
Tracked: Dec 04, 09:03

What's your favorite 8.4 feature?
Over the past month or so, I have been informally polling those of our customers I've been meeting with about which features in the upcoming 8.4 version of PostgreSQL they are most excited about, and most likely to have use for in the short-to-medium term

Weblog: Magnus Hagander's PostgreSQL blog
Tracked: Apr 14, 19:40

Comments

Display comments as (Linear | Threaded)

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

#1 Vincenzo Romano on 2008-12-03 15:11 (Reply)

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

#2 pabloj on 2008-12-03 19:48 (Reply)

Add Comment

Name
Email
Homepage
In reply to
Comment	Enclosing asterisks marks text as bold (word), underscore are made via _word_. Standard emoticons like :-) and ;-) are converted to images. To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above:
	Remember Information? Subscribe to this entry