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 68C1BD701B for ; Tue, 11 Oct 2005 09:19: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 59218-10 for ; Tue, 11 Oct 2005 12:19:45 +0000 (GMT) Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by svr1.postgresql.org (Postfix) with ESMTP id 6E3E0D7061 for ; Tue, 11 Oct 2005 09:19:44 -0300 (ADT) Received: from trofast.sesse.net ([129.241.93.32]) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1EPJ6g-0000Wq-DQ for pgsql-performance@postgresql.org; Tue, 11 Oct 2005 14:19:47 +0200 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1EPJ6c-0006ln-00 for ; Tue, 11 Oct 2005 14:19:42 +0200 Date: Tue, 11 Oct 2005 14:19:42 +0200 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: Massive delete performance Message-ID: <20051011121942.GA25543@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: <00bd01c5ce37$f8a4cc00$0b00a8c0@forge> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <00bd01c5ce37$f8a4cc00$0b00a8c0@forge> X-Operating-System: Linux 2.6.11.8 on a i686 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.012 required=5 tests=[AWL=0.012] X-Spam-Level: X-Archive-Number: 200510/190 X-Sequence-Number: 14958 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/