Re: VACUUM process running for a long time - Mailing list pgsql-general

From Adrian von Bidder
Subject Re: VACUUM process running for a long time
Date
Msg-id 201004161123.56985@fortytwo.ch
Whole thread Raw
In response to Re: VACUUM process running for a long time  (Jan Krcmar <honza801@gmail.com>)
List 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

Attachment

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Complete row is fetched ?
Next
From: Scott Marlowe
Date:
Subject: Re: VACUUM process running for a long time