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 A23B3D9BA3 for ; Thu, 29 Sep 2005 10:29:38 -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 07559-02 for ; Thu, 29 Sep 2005 13:29:34 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8D4B8D9AF0 for ; Thu, 29 Sep 2005 10:29:35 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id B560831F51; Thu, 29 Sep 2005 15:29:39 +0200 (MET DST) From: Gaetano Mendola X-Newsgroups: pgsql.performance Subject: Re: Delete query takes exorbitant amount of time Date: Thu, 29 Sep 2005 15:29:30 +0200 Organization: Hub.Org Networking Services Lines: 14 Message-ID: <433BEC3A.40404@bigfoot.com> References: <1111709457.9085.127.camel@k2.cet.nau.edu> <2630.1111711927@sss.pgh.pa.us> <1111713798.23412.3.camel@amateljan.mirlogic.com> <4009.1111717976@sss.pgh.pa.us> <1112031350.23412.131.camel@amateljan.mirlogic.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Mark Lewis User-Agent: Thunderbird 1.4 (Windows/20050908) In-Reply-To: <1112031350.23412.131.camel@amateljan.mirlogic.com> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/419 X-Sequence-Number: 14727 Mark Lewis wrote: > I imported my test dataset > and was almost immediately able to track down the cause of my > performance problem. Why don't you tell us what the problem was :-) ? Regards Gaetano Mendola