X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 9D1679234DD for ; Mon, 2 Jun 2003 01:32:19 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 88696-05 for ; Mon, 2 Jun 2003 01:32:08 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id 0E4CE921B8C for ; Mon, 2 Jun 2003 01:31:37 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h525VRU6002116; Mon, 2 Jun 2003 01:31:27 -0400 (EDT) To: George Papastamatopoulos Cc: pgsql-performance@postgresql.org, Paul Smith Subject: Re: FW: Query Plan problem In-reply-to: <7395B46C07F8D51182AE000629570CC4804A31@IKE> References: <7395B46C07F8D51182AE000629570CC4804A31@IKE> Comments: In-reply-to George Papastamatopoulos message dated "Mon, 02 Jun 2003 14:56:18 +1000" Date: Mon, 02 Jun 2003 01:31:27 -0400 Message-ID: <2115.1054531887@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200306/9 X-Sequence-Number: 2093 George Papastamatopoulos writes: >> ... WHERE tblUser.id IN >> ('102','103','104','105','106','107','108','109','110','111','112','113',' >> 114','115','116','117','118','119','120','121','122','123','124','125','12 > ... What's the datatype of tblUser.id? What indexes do you have on the table? Also, are both databases built with the same locale/encoding support and initdb-time choices? What are they? regards, tom lane