Postgres Pro
Downloads
Home   >   mailing lists

Thread: When will vacuum go away?

When will vacuum go away?

From
"Michael Richards"
Date:
I've been watching for this for some time. First it was 7.0, then 
7.1. Does anyone have any idea on when the row re-use code will be 
ready? 

Currently I'm running into trouble with an OLTP database. It grows 
like crazy, has only 3,000,000 rows and vacuum takes a good 1/2 hour. 
Given trouble with Great Bridge is there any info out there on when 
7.2 might hit the streets?

-Michael
_________________________________________________________________    http://fastmail.ca/ - Fast Free Web Email for
Canadians

Re: When will vacuum go away?

From
Tom Lane
Date:
"Michael Richards" <michael@fastmail.ca> writes:
> I've been watching for this for some time. First it was 7.0, then 
> 7.1. Does anyone have any idea on when the row re-use code will be 
> ready? 

VACUUM isn't disappearing any time soon, but 7.2's version of vacuum
runs in parallel with normal transactions, so it's not so painful to
run it frequently.  See discussion in development docs,
http://candle.pha.pa.us/main/writings/pgsql/sgml/maintenance.html

> Given trouble with Great Bridge is there any info out there on when 
> 7.2 might hit the streets?

The last several postponements of 7.2 beta have *not* been the fault
of the ex-GreatBridge folks around here.

You can find a snapshot that should be pretty durn close to 7.2beta1
at ftp://ftp2.us.postgresql.org/pub/dev/postgresql-snapshot.tar.gz
(note that at last word, other mirrors were not up to date --- if
the doc/TODO file doesn't contain a date in October, it's stale).
I think the only thing we're still waiting on is some datetime fixes
from Tom Lockhart...
        regards, tom lane

Re: When will vacuum go away?

From
Tom Lane
Date:
Joseph Shraibman <jks@selectacast.net> writes:
> BTW will there be a 7.1.4 release before 7.2 comes out so we can dump
> our databases to upgrade to 7.2 w/o there being 60 in the seconds
> field?

I doubt it.  We're having enough trouble trying to get everyone lined
up to produce a 7.2 beta :-(.  Producing another 7.1 patch release
isn't in the cards.
        regards, tom lane

Re: When will vacuum go away?

From
Joseph Shraibman
Date:
BTW will there be a 7.1.4 release before 7.2 comes out so we can dump our databases to 
upgrade to 7.2 w/o there being 60 in the seconds field?

Tom Lane wrote:

> "Michael Richards" <michael@fastmail.ca> writes:
> 
>>I've been watching for this for some time. First it was 7.0, then 
>>7.1. Does anyone have any idea on when the row re-use code will be 
>>ready? 
>>
> 
> VACUUM isn't disappearing any time soon, but 7.2's version of vacuum
> runs in parallel with normal transactions, so it's not so painful to
> run it frequently.  See discussion in development docs,
> http://candle.pha.pa.us/main/writings/pgsql/sgml/maintenance.html
> 
> 
>>Given trouble with Great Bridge is there any info out there on when 
>>7.2 might hit the streets?
>>
> 
> The last several postponements of 7.2 beta have *not* been the fault
> of the ex-GreatBridge folks around here.
> 
> You can find a snapshot that should be pretty durn close to 7.2beta1
> at ftp://ftp2.us.postgresql.org/pub/dev/postgresql-snapshot.tar.gz
> (note that at last word, other mirrors were not up to date --- if
> the doc/TODO file doesn't contain a date in October, it's stale).
> I think the only thing we're still waiting on is some datetime fixes
> from Tom Lockhart...
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
> 


-- 
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com