Re: Massive delete performance - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Massive delete performance
Date
Msg-id 20051011121942.GA25543@uio.no
Whole thread Raw
In response to Massive delete performance  ("Andy" <frum@ar-sd.net>)
List pgsql-performance
On Tue, Oct 11, 2005 at 10:47:03AM +0300, Andy wrote:
> 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.

Instead of copying and then deleting, could you try just selecting out what
you wanted in the first place?

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Sean Davis
Date:
Subject: Re: Massive delete performance
Next
From: "Andy"
Date:
Subject: Re: Massive delete performance