X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0BD915E46E8 for ; Fri, 13 Aug 2004 13:17:13 -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 03703-08 for ; Fri, 13 Aug 2004 16:17:15 +0000 (GMT) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id ABACF5E46D4 for ; Fri, 13 Aug 2004 13:17:06 -0300 (ADT) Received: from solent (82-68-95-1.dsl.in-addr.zen.co.uk [82.68.95.1]) by bayswater1.ymogen.net (Postfix) with ESMTP id 2A95FA5720; Fri, 13 Aug 2004 17:17:11 +0100 (BST) Reply-To: From: "Matt Clark" To: "'Bruno Wolff III'" , "'Rod Taylor'" Cc: "'Ulrich Wisser'" , "'gnari'" , "'Postgresql Performance'" Subject: Re: insert Date: Fri, 13 Aug 2004 17:17:10 +0100 Organization: Ymogen Ltd Message-ID: <006901c48150$fcfafb10$8300a8c0@solent> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 In-Reply-To: <20040813150243.GA2004@wolff.to> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/212 X-Sequence-Number: 7848 > > It is likely that you are missing an index on one of those foreign > > key'd items. > > I don't think that is too likely as a foreign key reference > must be a unique key which would have an index. I think you must be thinking of primary keys, not foreign keys. All one-to-many relationships have non-unique foreign keys.