Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 114A5BBDD52 for ; Fri, 18 Nov 2011 10:16:56 -0400 (AST) Received: from sam.nabble.com ([216.139.236.26]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RRPFM-000111-KR for pgsql-performance@postgresql.org; Fri, 18 Nov 2011 14:16:56 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1RRPF9-000892-DZ for pgsql-performance@postgresql.org; Fri, 18 Nov 2011 06:16:39 -0800 Date: Fri, 18 Nov 2011 06:16:39 -0800 (PST) From: MirrorX To: pgsql-performance@postgresql.org Message-ID: <1321625799413-5004410.post@n5.nabble.com> In-Reply-To: <1F701652-23B3-4350-84D8-809254B6C6B0@silentmedia.com> References: <56E9C0EA-4647-4D2E-92A7-A1EADCABE160@blighty.com> <1F701652-23B3-4350-84D8-809254B6C6B0@silentmedia.com> Subject: Re: index usage for min() vs. "order by asc limit 1" MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 201111/238 X-Sequence-Number: 45749 can you run an analyze command first and then post here the results of: select * FROM pg_stats WHERE tablename = 'delayed_jobs'; ? -- View this message in context: http://postgresql.1045698.n5.nabble.com/index-usage-for-min-vs-order-by-asc-limit-1-tp5002928p5004410.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.