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 669C1D6F80 for ; Tue, 11 Oct 2005 09:12:11 -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 49349-06 for ; Tue, 11 Oct 2005 12:12:07 +0000 (GMT) Received: from wimpy.net.nih.gov (wimpy.net.nih.gov [128.231.88.106]) by svr1.postgresql.org (Postfix) with ESMTP id 72467D6FEA for ; Tue, 11 Oct 2005 09:12:09 -0300 (ADT) Received: from wimpy.net.nih.gov (localhost [127.0.0.1]) by wimpy.net.nih.gov (8.12.11/8.11.7) with ESMTP id j9BCCCPH016476 for ; Tue, 11 Oct 2005 08:12:13 -0400 (EDT) Received: from [128.231.145.14] (holmes.nhgri.nih.gov [128.231.145.14]) by wimpy.net.nih.gov (8.12.11/8.11.7) with ESMTP id j9BCCCbI016467; Tue, 11 Oct 2005 08:12:12 -0400 (EDT) User-Agent: Microsoft-Entourage/10.1.4.030702.0 Date: Tue, 11 Oct 2005 08:12:11 -0400 Subject: Re: Massive delete performance From: Sean Davis To: Andy , Message-ID: In-Reply-To: <017601c5ce5c$219e1b10$0b00a8c0@forge> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.013 required=5 tests=[AWL=0.013] X-Spam-Level: X-Archive-Number: 200510/189 X-Sequence-Number: 14957 On 10/11/05 8:05 AM, "Andy" wrote: >> Do you have foreign key relationships that must be followed for cascade >> delete? If so, make sure that you have indices on them. > Yes I have such things. Indexes are on these fields. >> To be onest this > delete is taking the longest time, but it involves about 10 tables. Can you post explain analyze output of the next delete? Sean