X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 599D0D77D2
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 11 Oct 2005 18:48:54 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 45545-02
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 11 Oct 2005 21:48:49 +0000 (GMT)
Received: from metux.de (seven.metux.de [193.16.1.1])
	by svr1.postgresql.org (Postfix) with ESMTP id 8F52DD72F6
	for <pgsql-performance@postgresql.org>;
	Tue, 11 Oct 2005 18:48:50 -0300 (ADT)
Received: (from weigelt@localhost)
	by metux.de (8.12.10/8.12.10) id j9BLmoWc004153
	for pgsql-performance@postgresql.org; Tue, 11 Oct 2005 23:48:50 +0200
Date: Tue, 11 Oct 2005 23:48:50 +0200
From: Enrico Weigelt <weigelt@metux.de>
To: pgsql-performance@postgresql.org
Subject: Re: Massive delete performance
Message-ID: <20051011214849.GA23769@nibiru.local>
Reply-To: weigelt@metux.de
Mail-Followup-To: pgsql-performance@postgresql.org
References: <00bd01c5ce37$f8a4cc00$0b00a8c0@forge>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <00bd01c5ce37$f8a4cc00$0b00a8c0@forge>
User-Agent: Mutt/1.4.1i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.005 required=5 tests=[AWL=0.005]
X-Spam-Level: 
X-Archive-Number: 200510/204
X-Sequence-Number: 14972

* Andy <frum@ar-sd.net> wrote:

<snip>
>    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.

Why not filtering out as much unnecessary stuff as possible on copying ?

<snip>

>    How can I increase this DELETE procedure because it is really slow???
>     There are of corse a lot of data's to be deleted.

Have you set up the right indices ?


cu
-- 
---------------------------------------------------------------------
 Enrico Weigelt    ==   metux IT service
  phone:     +49 36207 519931         www:       http://www.metux.de/
  fax:       +49 36207 519932         email:     contact@metux.de
---------------------------------------------------------------------
  Realtime Forex/Stock Exchange trading powered by postgreSQL :))
                                            http://www.fxignal.net/
---------------------------------------------------------------------