Visibility map arrives

Magnus Hagander's PostgreSQL blog

Wednesday, December 3. 2008

Posted by Magnus Hagander in PostgreSQL

Comments (2)
Trackbacks (2)
2238 hits
Defined tags for this entry:
Related entries by tags:
Important updates for PostgreSQL Europe
Time management by (somebody elses) press-releases
Integrating django authentication with PostgreSQL
64-bit Windows in 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

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 March '10
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 30 31        

Archives

Upcoming conferences

Planned Conferences

Tentative conferences

Past conferences

  • 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

Lowe Schmidt about FOSS STHML #1
Thu, 25.02.2010 14:14
Tack själv! Även om jag inte ä r tillräckligt insatt i databa ser för att förstå storheterna i detta var det intressant :-)
Magnus about Summary of feedback from FOSDEM devroom
Tue, 23.02.2010 07:08
Well we did mention it :-) The others we didn't do thou gh. We had the URL on a board next to the speaker, but [...]
Selena Deckelmann about Summary of feedback from FOSDEM devroom
Tue, 23.02.2010 04:35
One thing you can do is create quarter-page sized surveys th at people fill out and drop in a box on their way out [...]
Andreas 'ads' Scherbaum about Important updates for PostgreSQL Europe
Thu, 18.02.2010 16:05
Good work so far!
Greg Smith about Time management by (somebody elses) press-releases
Tue, 09.02.2010 05:05
This is the sort of service yo u get when you're a Platinum s ponsor. It includes a time ma chine to tell what talks [...]
Devrim GÜNDÜZ about Time management by (somebody elses) press-releases
Mon, 08.02.2010 20:32
C'mon... You are Magnus -- you r each talk will be accepted.
Peter Eisentraut about Transferring slonified databases without slony
Mon, 25.01.2010 11:01
There is also a script in the Slony source tree by the name of slony1_extract_schema.sh th at attempts to solve thi [...]
Dimitri Fontaine about Integrating django authentication with PostgreSQL
Thu, 14.01.2010 10:31
SELECT ok FROM (SELECT encod e(pgcrypto.digest(split_part(p assword, '$', 2) || _password, 'sha1'), 'hex') = [...]
Magnus about Integrating django authentication with PostgreSQL
Wed, 13.01.2010 20:00
Yeah, you can actually make it slightly faster using CTEs. But it so happens to be that the function I cut it o [...]
Dimitri Fontaine about Integrating django authentication with PostgreSQL
Wed, 13.01.2010 19:57
I guess this should be IF EXIS TS (SELECT 1 FROM ...) rather than SELECT *, and IIRC 8.4 EX PLAIN VERBOSE will show [...]

Tweets

magnushagander: You're a business twitter account and you follow to get followers? You're a spammer. /via @Crad

magnushagander: @petrillic: I implemented similar to that. But on my own since I had to fix the broken NULL Handling anyway... But thanks for the pointer!

magnushagander: Once again got halfway using the #python CSV module until I realized that no, it doesn't support utf8, and yes, it has broken NULL handling.

magnushagander: @DevrimGunduz: are you sure that wasn't pgcon in canada?