Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 75AC4B5DC04 for ; Wed, 22 Jun 2011 18:35:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 79089-05 for ; Wed, 22 Jun 2011 21:35:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10]) by mail.postgresql.org (Postfix) with ESMTP id E9DFFB5DC00 for ; Wed, 22 Jun 2011 18:35:41 -0300 (ADT) Received: from [192.168.1.7] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0MWOFC-1R5sCk3VGs-00XY6O; Wed, 22 Jun 2011 23:35:41 +0200 Message-ID: <4E02602B.3060607@2ndQuadrant.com> Date: Wed, 22 Jun 2011 17:35:39 -0400 From: Greg Smith User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.16) Gecko/20110505 Icedove/3.0.11 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: seq scan in the case of max() on the primary key column References: <4DFA4D2F.8020101@peak6.com> <4E01EA4D.3080205@peak6.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:jAOsGje9/2fkcnIW1QAcHnsZB2GuSQDJtCOLPH/eDZb J43t9i5BaSMlrrGz969cfR8pk6nz8EBGJ8Y2g7xf//eSfm9EUH if3waIe2V1f6CPlLLP97Kdwij+NekbImFw8kgzbd+wdr4DkHwT Et+pflFjJnEEgqpyfP4o4PK1D3R56IvEoPyQpF3l8372M6eiy6 RKaFlH9RO8E/X0R1CjEbzG8nfPlATKS/06UT///Pn0= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201106/215 X-Sequence-Number: 44148 On 06/22/2011 02:12 PM, Scott Marlowe wrote: > Given that many folks still run < 9.0 in production, the wiki page > should really have a version of that function for older versions, > whether it's long or not. > I updated the page already to be clear about what versions of PostgreSQL it works on, and it directs people to Shaun's original message if they are running 8.2. The only people who might get confused now are the ones running EDB's versions, where the exact features you get in particular versions can be slightly different than the community version. But that problem both exists in other parts of the wiki, and is a bit outside of its scope to try and address. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books