Re: Massive delete performance

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Massive delete performance
Date: 2005-10-11 12:19:42
Message-ID: 20051011121942.GA25543@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andy 2005-10-11 13:27:48 Re: Massive delete performance
Previous Message Sean Davis 2005-10-11 12:12:11 Re: Massive delete performance