From: Sean Davis <sdavis2@mail.nih.gov>
To: Andy <frum@ar-sd.net>
To: pgsql-performance@postgresql.org
Subject: Re: Massive delete performance
Date: Tue, 11 Oct 2005 07:54:39 -0400
Message-ID: <BF71203F.10300%sdavis2@mail.nih.gov> (raw)
In-Reply-To: <00bd01c5ce37$f8a4cc00$0b00a8c0@forge>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sdavis2@mail.nih.gov, frum@ar-sd.net
Subject: Re: Massive delete performance
In-Reply-To: <BF71203F.10300%sdavis2@mail.nih.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox