Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 23E4A47603B for ; Mon, 27 Jan 2003 15:56:40 -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 8B5614759AF for ; Mon, 27 Jan 2003 15:56:39 -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 h0RKsN5D021623 for ; Mon, 27 Jan 2003 15:54:23 -0500 (EST) Message-ID: <3E359D06.5020408@spaceship.com> Date: Mon, 27 Jan 2003 14:56:38 -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: <3E35991D.5050704@spaceship.com> <030201c2c644$e14cfcb0$32021aac@chad> In-Reply-To: <030201c2c644$e14cfcb0$32021aac@chad> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/358 X-Sequence-Number: 1005 Yes, I had not only done a "vacuum full analyze" on the PG db once I stuffed it, but I also compared that with an IFX db that I had run "update statistics high" on. Things are much better with the FK indexes. 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? ;) Thanks! Chad Thompson wrote: > Make sure that you've run a vacuum and an analyze. There is also a > performance hit if the types of the fields or values are different. ie int > to int8 -- Matt Mello