Visibility map arrives

Magnus Hagander's PostgreSQL blog

Wednesday, December 3. 2008

Posted by Magnus Hagander in PostgreSQL

Comments (2)
Trackbacks (2)
4586 hits
Defined tags for this entry:
Related entries by tags:

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

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.
CAPTCHA 1CAPTCHA 2CAPTCHA 3CAPTCHA 4CAPTCHA 5
 
 

Frontpage - Top level

Calendar

Back February '12
Mon Tue Wed Thu Fri Sat Sun
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29        

Archives

Upcoming conferences

Planned Conferences

Tentative conferences

Past conferences

  • PGDay.IT 2011
  • FSCONS 2011
  • Postgres Open 2011
  • PGConf.EU 2011
  • Char(11) 2011
  • EuroPython 2011
  • PGCon 2011
  • NLUUG Spring
  • PG-East 2011
  • OpenSource Days 2011
  • P2D2 2011
  • FOSDEM 2011
  • PGDay.EU 2010
  • PG-West 2010
  • PG-East 2010
  • PGCon 2010
  • OpenSource Days 2010
  • FOSS-Stockholm #1
  • FOSDEM 2010
  • JPUG 2009
  • FSCONS
  • PGDay.EU 2009
  • PGcon.BR 2009
  • JDCon West 2009
  • Highload++ 2009
  • PGCon 2009
  • Prague PG Day 2009
  • FOSDEM 2009
  • FSCONS 2008
  • PGDay.EU 2008
  • Open Source Days 2008
  • PG-West 2008
  • PGCon 2008
  • PG-East 2008
  • FOSDEM 2008

Tags

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Latest comments

Magnus Hagander about Finding gaps in partitioned sequences
Mon, 30.01.2012 17:25
No, there are no user defined functions in this. seq is t he column name, then minus the operator, then lag the [...]
mark about Finding gaps in partitioned sequences
Mon, 30.01.2012 17:23
what is seq-lag ? i assume thi s is a user defined func.
Magnus Hagander about www.postgresql.org - brand new, yet old and familiar
Thu, 22.12.2011 17:41
Yeah, unfortunately we are sti ll waiting on David to migrate the content over there.
Dave about www.postgresql.org - brand new, yet old and familiar
Thu, 22.12.2011 16:55
The weekly news page (http://w ww.postgresql.org/community/we eklynews/) seems to be broken. I see only a couple of [...]
Magnus Hagander about www.postgresql.org - brand new, yet old and familiar
Thu, 22.12.2011 14:08
I didn't see that when I check ed, but there was a bug that c aused it to cache the internal errors for several hour [...]
Hans about www.postgresql.org - brand new, yet old and familiar
Thu, 22.12.2011 11:14
The page with the mail archive is no longer working: htt p://www.postgresql.org/communi ty/ Shows me "An inte [...]
daamien about www.postgresql.org - brand new, yet old and familiar
Wed, 21.12.2011 22:20
you know your upgrade is a suc cess when nobody notices anyth ing :-) kudos to the webmast er team !
gabrielle about www.postgresql.org - brand new, yet old and familiar
Wed, 21.12.2011 14:13
Thanks for all your hard work! (And that goes for the rest of the team, too.)
Piotr Adamiak about PGConf.EU 2011 - the speakers and the presentations
Tue, 08.11.2011 10:57
Thanks for the link Pavel and also thanks for your very usef ul blog !
Pavel Golub about PGConf.EU 2011 - the speakers and the presentations
Mon, 07.11.2011 14:50
Piotr, here they are: http://w iki.postgresql.org/wiki/Postgr eSQL_Conference_Europe_Talks_2 011

Tweets

magnushagander: The restaurant ran out of large beer glasses... #postgresql #fosdem #brussels

magnushagander: RT @infofarmer: By now there's no way you can get into PostgreSQL devroom. Full to the brims. We should've gone with MySQL -- there almo ...

magnushagander: Not even standing room left (seats long gone) in heikki's talk about #postgresql 9.2 performance. #fosdem http://t.co/Zll7MZz6

magnushagander: Time for @DevrimGunduz to teach us all about redhat clustering with postgresql! #postgresql #fosdem http://t.co/YdTk93vn
tweetbackcheck