X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 61C3453A7E for ; Wed, 6 Apr 2005 23:16:32 +0100 (BST) 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 22310-09 for ; Wed, 6 Apr 2005 22:16:22 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 8227053A3B for ; Wed, 6 Apr 2005 23:16:18 +0100 (BST) Received: by flake.decibel.org (Postfix, from userid 1001) id 7E0D515487; Wed, 6 Apr 2005 17:16:20 -0500 (CDT) Date: Wed, 6 Apr 2005 17:16:20 -0500 From: "Jim C. Nasby" To: Tom Lane Cc: Ricardo Valen?a de Assis , Bruno Wolff III , pgsql-admin@postgresql.org Subject: Re: delete to slow Message-ID: <20050406221620.GJ93835@decibel.org> References: <006701c53ac8$014b27e0$1b00280a@ugf.br> <20050406173137.GA19739@wolff.to> <00e301c53ace$ab400260$1b00280a@ugf.br> <20050406175641.GF93835@decibel.org> <010101c53ad2$5a4d84a0$1b00280a@ugf.br> <20050406180204.GG93835@decibel.org> <28823.1112811339@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <28823.1112811339@sss.pgh.pa.us> X-Operating-System: FreeBSD 4.11-RELEASE i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.8i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.021 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/89 X-Sequence-Number: 17102 On Wed, Apr 06, 2005 at 02:15:39PM -0400, Tom Lane wrote: > "Jim C. Nasby" writes: > > Well, neither of those should take very long at all. What's EXPLAIN > > ANALYZE show? > > Indeed ... now I'm wondering about foreign key checks. Are there any > tables with foreign keys linking to usuario? If so, the problem is > likely unindexed foreign key columns, or maybe a datatype mismatch > between foreign key and referenced column. Hmm... it would be pretty handy if there was a way to make triggers show up in explain somehow, maybe as a pseudo query node. -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"