Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 086A62E0038 for ; Wed, 9 Apr 2008 19:31:12 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 59466-01 for ; Wed, 9 Apr 2008 19:31:09 -0300 (ADT) X-Greylist: delayed 00:23:14.048861 by SQLgrey-1.7.5 Received: from wizmail.org (wizmail.org [217.146.104.199]) by developer.postgresql.org (Postfix) with ESMTP id ECCE32E002C for ; Wed, 9 Apr 2008 19:31:08 -0300 (ADT) Received: from ebony.jgh.adsl.wizards.co.uk ([217.146.123.59]) (from_AS 16353) by wizmail.org with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.67) id 1JjiSn-00046Y-1D for pgsql-performance@postgresql.org (return-path ); Wed, 09 Apr 2008 22:08:17 +0000 Message-ID: <47FD3E36.3080309@wizmail.org> Date: Wed, 09 Apr 2008 23:07:50 +0100 From: Jeremy Harris User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.12) Gecko/20080226 Fedora/2.0.0.12-1.fc7 Thunderbird/2.0.0.12 Mnenhy/0.7.5.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: large tables and simple "= constant" queries using indexes References: <47FD2DF3.80500@gmail.com> <47FD3350.4060504@tweakers.net> <20080409173609.d1b959c0.wmoran@collaborativefusion.com> In-Reply-To: <20080409173609.d1b959c0.wmoran@collaborativefusion.com> 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: 200804/117 X-Sequence-Number: 29610 Bill Moran wrote: > This is a FAQ, it comes up on an almost weekly basis. I don't think so. "where". >>> - select count(*) from gene_prediction_view where gene_ref = 523 Cheers, Jeremy