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 6878152D44 for ; Wed, 6 Apr 2005 19:15:45 +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 46575-07 for ; Wed, 6 Apr 2005 18:15:43 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id E588E533B8 for ; Wed, 6 Apr 2005 19:15:42 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j36IFdnc028824; Wed, 6 Apr 2005 14:15:39 -0400 (EDT) To: "Jim C. Nasby" Cc: Ricardo Valen?a de Assis , Bruno Wolff III , pgsql-admin@postgresql.org Subject: Re: delete to slow In-reply-to: <20050406180204.GG93835@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> Comments: In-reply-to "Jim C. Nasby" message dated "Wed, 06 Apr 2005 13:02:04 -0500" Date: Wed, 06 Apr 2005 14:15:39 -0400 Message-ID: <28823.1112811339@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/85 X-Sequence-Number: 17098 "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. regards, tom lane