Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2324C9F9D81 for ; Sun, 28 Oct 2007 14:29:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 82874-09 for ; Sun, 28 Oct 2007 14:28:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail128156.authsmtp.com (outmail128156.authsmtp.com [62.13.128.156]) by postgresql.org (Postfix) with ESMTP id 7B1919F9F40 for ; Sun, 28 Oct 2007 14:28:57 -0300 (ADT) Received: from outmail128184.authsmtp.net (outmail128184.authsmtp.net [62.13.128.184]) by punt3.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l9SHStXb064642; Sun, 28 Oct 2007 17:28:55 GMT Received: from [192.168.0.3] (62-3-250-177.dyn.gotadsl.co.uk [62.3.250.177]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l9SHSrnv039394; Sun, 28 Oct 2007 17:28:53 GMT Subject: Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1 From: Simon Riggs To: Tom Lane Cc: pgsql-performance@postgresql.org In-Reply-To: <515.1193590439@sss.pgh.pa.us> References: <1193562833.4242.670.camel@ebony.site> <515.1193590439@sss.pgh.pa.us> Content-Type: text/plain Date: Sun, 28 Oct 2007 17:27:24 +0000 Message-Id: <1193592444.4242.711.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: 413eccf7-857b-11dc-b86a-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFag1bYlpF HGQLW1NEUVp7W2t/ bgkfawdDYVRMWgV0 UU9OXVBXCwUmXRVi fn1cDF9ydAxFcXo+ ZEZmWz5fXUcvJhUr RVNcEGpUeGZhPDMC AkheJh5UcAJLdhoR aVd4ByJDAzANdhEA MjUdGAoUCH1HIT5J Qx0MKlQfTQ4XFzQ4 SlgLGzlnOncpah97 BS1uK1gQEVYcPnI8 MFYlVTB5HzIpISl/ OmBxSHYx X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:752/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.085 tagged_above=0 required=5 tests=AWL=-0.072, BAYES_50=0.001, SUBJECT_FUZZY_TION=0.156 X-Spam-Level: X-Archive-Number: 200710/333 X-Sequence-Number: 27355 On Sun, 2007-10-28 at 12:53 -0400, Tom Lane wrote: > Simon Riggs writes: > > I agree its annoying and I have a way of doing this, but that's an 8.4 > > thing now. > > It was an 8.4 thing quite some time ago, since no working patch was ever > submitted. Sorry, I meant that the problem itself is annoying, not anything to do with patches. I'm very happy with all that we've done. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com