Re: VACUUM process running for a long time

Adrian von Bidder <avbidder@fortytwo.ch>

From: Adrian von Bidder <avbidder@fortytwo.ch>
To: pgsql-general@postgresql.org
Date: 2010-04-16T09:23:56Z
Lists: pgsql-general
On Thursday 15 April 2010 15.56:20 Jan Krcmar wrote:
> i'm doing one big insert per day, and one big delete per day
> 
> anyway, i've found, this article
> http://www.postgresql.org/docs/8.4/interactive/ddl-partitioning.html
> 
> could the partitioning be helpfull for this situation?

Yes, I'm quite sure that partitioning will be a big help in this scenario.

cheers
-- vbi

-- 
this email is protected by a digital signature: http://fortytwo.ch/gpg