Postgres Pro
Downloads
Home   >   mailing lists

Re: index usage for min() vs. "order by asc limit 1" - Mailing list pgsql-performance

From MirrorX
Subject Re: index usage for min() vs. "order by asc limit 1"
Date
Msg-id 1321625799413-5004410.post@n5.nabble.com
Whole thread Raw
In response to Re: index usage for min() vs. "order by asc limit 1"  (Ben Chobot <bench@silentmedia.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: Benchmarking tools, methods
Next
From: Claudio Freire
Date:
Subject: Re: probably cause (and fix) for floating-point assist faults on itanium