X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BF29DD1DC15 for ; Mon, 22 Mar 2004 20:55:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 59315-04 for ; Mon, 22 Mar 2004 16:56:03 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 73B44D1DB5C for ; Mon, 22 Mar 2004 16:55:51 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2MKu32b008054; Mon, 22 Mar 2004 15:56:04 -0500 (EST) To: Ricardo Vaz Mannrich Cc: pgsql-admin@postgresql.org Subject: Re: Slow Foreign Key In-reply-to: <1079979898.5609.15.camel@paranagua.silcom> References: <1079979898.5609.15.camel@paranagua.silcom> Comments: In-reply-to Ricardo Vaz Mannrich message dated "22 Mar 2004 15:24:58 -0300" Date: Mon, 22 Mar 2004 15:56:03 -0500 Message-ID: <8053.1079988963@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/289 X-Sequence-Number: 12858 Ricardo Vaz Mannrich writes: > Is FOREIGN KEY so slow like that? Not normally. Have you checked that the referencing and referenced columns are of the same datatype? Have you done ANALYZE on both tables recently? regards, tom lane