Wednesday, December 3. 2008Visibility map arrivesSince 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
Display comments as
(Linear | Threaded)
This is the kind of advancements that justify the upgrade worth any adaptation work!
This will be a great release, PostgreSQL will definitely have the most complete SQL dialect amongst opensource databases with CTE and Window Queries!
|
Calendar
Upcoming eventsScheduled events
Tentative events
CategoriesSyndicate This BlogLatest commentsMon, 22.06.2009 04:50
I have an enterprise Apache/Mo
d_perl/PostgreSQL application
in development for aircraft di
spatch. The connection [...]
about Getting started at pgcon
Tue, 16.06.2009 20:44
Wed, 10.06.2009 21:40
Well, it assumes there are no
gaps, and that the sequence st
arts at a controlled value. An
d that there are no othe [...]
Tue, 09.06.2009 10:08
Assuming id's are coming witho
ut "holes" such statement may
be used:
SELECT * FROM cust
omer ORDER BY ABS(custno [...]
Fri, 05.06.2009 18:50
Fri, 05.06.2009 16:11
It's for just this kind of use
case that OLAP functions were
invented. The ROWS n (PRECED
ING|FOLLOWING) syntax si [...]
Fri, 05.06.2009 16:08
instead of doing select [*] fr
om (select ... limit) as a uni
on all, you can also use this
notation:
(select [*] [...]
about pgcon photos
Fri, 29.05.2009 18:46
Show tagged entriesTweets |
|||||||||||||||||||||||||||||||||||||||||||||||||
Too light outside.
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
Tracked: Dec 04, 10:03
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
Tracked: Apr 14, 21:40