Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id EA6DC1337BD9 for ; Sun, 13 Mar 2011 09:41:32 -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 51089-07 for ; Sun, 13 Mar 2011 12:41:24 +0000 (UTC) X-Greylist: delayed 00:19:33.25815 by SQLgrey-1.7.6 Received: from wizmail.org (wizmail.org [217.146.107.12]) by mail.postgresql.org (Postfix) with ESMTP id 5A67E1337B58 for ; Sun, 13 Mar 2011 09:41:22 -0300 (ADT) Received: from stick.jgh.adsl.wizards.co.uk ([217.146.123.58] helo=localhost) from_AS 16353by wizmail.org with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.72) id 1PykIz-00088k-Cx for pgsql-performance@postgresql.org (return-path ); Sun, 13 Mar 2011 12:21:54 +0000 Date: Sun, 13 Mar 2011 12:21:47 +0000 Subject: Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 Message-ID: From: Jeremy To: pgsql-performance@postgresql.org Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201103/128 X-Sequence-Number: 42807 VGhlIHJvdyBlc3RpbWF0ZSBpcyB3YXkgb2ZmLiAgSXMgYXV0b3ZhY3V1bSBkaXNhYmxlZD8=