User-Agent: Microsoft-Entourage/10.1.4.030702.0
Date: Tue, 11 Oct 2005 07:54:39 -0400
Subject: Re: Massive delete performance
From: Sean Davis <sdavis2@mail.nih.gov>
To: Andy <frum@ar-sd.net>, <pgsql-performance@postgresql.org>
Message-ID: <BF71203F.10300%sdavis2@mail.nih.gov>
In-Reply-To: <00bd01c5ce37$f8a4cc00$0b00a8c0@forge>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit

On 10/11/05 3:47 AM, "Andy" <frum@ar-sd.net> wrote:

> Hi to all, 
> 
> I have the following problem: I have a client to which we send every night a
> "dump" with a the database in which there are only their data's. It is a
> stupid solution but I choose this solution because I couldn't find any better.
> The target machine is a windows 2003.
> 
> So, I have a replication only with the tables that I need to send, then I make
> a copy of this replication, and from this copy I delete all the data's that
> are not needed. 
> 
> How can I increase this DELETE procedure because it is really slow???  There
> are of corse a lot of data's to be deleted.

Do you have foreign key relationships that must be followed for cascade
delete?  If so, make sure that you have indices on them.  Are you running
any type of vacuum after the whole process?  What kind?

Sean