Re: VACUUM process running for a long time

From: Adrian von Bidder <avbidder(at)fortytwo(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM process running for a long time
Date: 2010-04-16 09:23:56
Message-ID: 201004161123.56985@fortytwo.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-04-16 09:33:22 Re: VACUUM process running for a long time
Previous Message A. Kretschmer 2010-04-16 08:23:44 Re: Complete row is fetched ?