Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5254747627E for ; Mon, 27 Jan 2003 19:05:41 -0500 (EST) Received: from silmaril.syscor.priv (h24-77-52-251.sbm.shawcable.net [24.77.52.251]) by postgresql.org (Postfix) with ESMTP id 3B39E475D64 for ; Mon, 27 Jan 2003 19:05:40 -0500 (EST) Received: from syscor.com (strider.syscor.priv [192.168.1.3]) by silmaril.syscor.priv (8.11.1/8.11.1) with ESMTP id h0S05l120238 for ; Mon, 27 Jan 2003 16:05:47 -0800 Message-ID: <3E35C99B.5020105@syscor.com> Date: Mon, 27 Jan 2003 16:06:51 -0800 From: "Ron St.Pierre" User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US; rv:1.2) Gecko/20021126 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Indexing foreign keys References: <3E35991D.5050704@spaceship.com> <030201c2c644$e14cfcb0$32021aac@chad> <3E359D06.5020408@spaceship.com> <200301271312.09105.josh@agliodbs.com> In-Reply-To: <200301271312.09105.josh@agliodbs.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/364 X-Sequence-Number: 1011 Josh Berkus wrote: > Matt, >>Did the docs say to index those FK fields (is that standard in the DB >>industry?), or was I just spoiled by IFX doing it for me? ;) > It's pretty standard in the DB industry. I didn't know that, but I'm new to the DB field. I've gleaned quite a few tips from this group, especially from responses to people with slow queries/databases, but this is the first I've noticed it this tip. I'll try it on my db too. -- Ron St.Pierre Syscor R&D tel: 250-361-1681 email: rstpierre@syscor.com