Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 808689FB350 for ; Fri, 28 Sep 2007 11:43:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 37110-02 for ; Fri, 28 Sep 2007 11:43:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pih-relay05.plus.net (pih-relay05.plus.net [212.159.14.132]) by postgresql.org (Postfix) with ESMTP id D00949FB34E for ; Fri, 28 Sep 2007 11:43:50 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay05.plus.net with esmtp (Exim) id 1IbH4C-0005gv-Kx; Fri, 28 Sep 2007 15:43:46 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 934FC274052; Fri, 28 Sep 2007 15:43:41 +0100 (BST) Message-ID: <46FD131D.3020901@archonet.com> Date: Fri, 28 Sep 2007 15:43:41 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: Tom Lane CC: Peter Koczan , pgsql-performance Subject: Re: sequence query performance issues References: <4544e0330709271504g364fd042u161966fa448934f6@mail.gmail.com> <46FCB5F3.4080600@archonet.com> <886.1190988979@sss.pgh.pa.us> In-Reply-To: <886.1190988979@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/468 X-Sequence-Number: 27013 Tom Lane wrote: > Richard Huxton writes: >> Hmm - why is it doing that? > > I'm betting that the OP's people.uid column is not an integer. Existing > PG releases can't use hashed subplans for cross-data-type comparisons > (8.3 will be a bit smarter). Looked like an int2 to me (width=2, max value ~ 32k) -- Richard Huxton Archonet Ltd