Re: index usage for min() vs. "order by asc limit 1"

From: MirrorX <mirrorx(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: index usage for min() vs. "order by asc limit 1"
Date: 2011-11-18 14:16:39
Message-ID: 1321625799413-5004410.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2011-11-18 14:21:52 Re: probably cause (and fix) for floating-point assist faults on itanium
Previous Message Cédric Villemain 2011-11-18 12:44:30 Re: Benchmarking tools, methods