Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0F292475D99 for ; Tue, 28 Jan 2003 00:51:27 -0500 (EST) Received: from txsmtp02.texas.rr.com (ms-smtp-02.texas.rr.com [24.93.36.230]) by postgresql.org (Postfix) with ESMTP id 57F31475A71 for ; Tue, 28 Jan 2003 00:51:26 -0500 (EST) Received: from spaceship.com (cs24243214-140.austin.rr.com [24.243.214.140]) by txsmtp02.texas.rr.com (8.12.5/8.12.2) with ESMTP id h0S5nE5D023572 for ; Tue, 28 Jan 2003 00:49:15 -0500 (EST) Message-ID: <3E361A63.6010409@spaceship.com> Date: Mon, 27 Jan 2003 23:51:31 -0600 From: Matt Mello User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Indexing foreign keys References: <20030127131057.F81562-100000@megazone23.bigpanda.com> In-Reply-To: <20030127131057.F81562-100000@megazone23.bigpanda.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/367 X-Sequence-Number: 1014 > You don't always need to create them, because there are fk patterns where > an index is counterproductive, but if you're not in one of those cases you > should create them. I'm not sure the docs actually say anything about > this however. I would try to add a comment about this to the interactive docs if they weren't so far behind already (7.2.1). :\ -- Matt Mello