Skip site navigation (1) Skip section navigation (2)

Re: Press Release

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: <josh(at)agliodbs(dot)com>,Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>,<pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Press Release
Date: 2003-10-29 23:07:28
Message-ID: Pine.LNX.4.33.0310291604390.22178-100000@css120.ihs.com (view raw or flat)
Thread:
Lists: pgsql-advocacy
On Wed, 29 Oct 2003, Joshua D. Drake wrote:

> First of all, be aware that we have already collected half the translations
> 
> >for the press kit.  So at this point, we can only cut paragraphs and not 
> >edit.  These comments would have been more timely a month ago ....
> >
> >  
> >
> If only I had a nickel :)
> 
> >>I believe is false. As long as you have to vacuum the above is not true.
> >>    
> >>
> >
> >How?  Vacuuming does not require the database to be offline.  Vacuum full 
> >does, but that can be eliminated with proper tuning.
> >
> >  
> >
> No but vacuum will cause your machine to grind to a crawl. Try telling a 
> customer
> that is pushing 240,000 transactions an hour, 24 hours a day to run a 
> Vacuum.
> They are not pleased.

The autovacuum daemon makes this situation as good as it's likely to ever 
get without some form of "vacuum this tuple at your leisure when you've 
got free bandwidth" setting for an update/delete.  It only vacuums the 
tables that have actually been changing, and you can set the period and 
what not so that it runs often enough that it never has too much to do.  
Keep in mind, the garbage collection HAS to happen sometime, so even if it 
were rolled 100% efficiently into the individual update/delete itself, it 
would still cost, just with slower transactions.


I agree though that the paragraph may make it sound like automatic 
vacuuming is a default part of the install when it isn't.


In response to

Responses

pgsql-advocacy by date

Next:From: Bruce MomjianDate: 2003-10-29 23:07:56
Subject: Re: Press Release
Previous:From: Joshua D. DrakeDate: 2003-10-29 23:04:04
Subject: Re: Press Release

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group