Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 467D8476D5C for ; Thu, 16 Jan 2003 16:12:33 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 3CC7B476299 for ; Thu, 16 Jan 2003 15:51:51 -0500 (EST) Received: by serwer.skawsoft.com.pl (Postfix, from userid 1000) id 517F22B26E; Thu, 16 Jan 2003 21:48:26 +0100 (CET) Date: Thu, 16 Jan 2003 21:48:26 +0100 To: Tom Lane Cc: Roman Fail , Josh Berkus , sszabo@megazone23.bigpanda.com, pgsql-performance@postgresql.org Subject: Re: 7.3.1 New install, large queries are slow Message-ID: <20030116204826.GA26576@serwer> References: <9B1C77393DED0D4B9DAA1AA1742942DA0E4C06@pos_pdc.posportal.com> <26712.1042746393@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <26712.1042746393@sss.pgh.pa.us> User-Agent: Mutt/1.3.28i From: jasiek@klaster.net X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/170 X-Sequence-Number: 817 Tom said: > datatype mismatch that prevents the index from being used. What are the > datatypes of d.batchid and b.batchid, exactly? If they're not the same, > either make them the same or add an explicit coercion to the query, like > WHERE d.batchid = b.batchid::typeof_d_batchid > It can be source of problem. I found in one of Roman's mail, that batchid is declared as int8 in master table and as int4 in detail table. Regards, Tomasz Myrta