> > > > However, if you limit the number of rows enough, you > might force it > > to use an index: > > > > select * from stats order by start_time limit 1000; > > > > Thanks! Since LIMIT/OFFSET is the typical usage pattern for > a paginated > data set accessed from the Web (which is my case), it > immediately > becomes a non-issue. >
We do a lot of queries with order by limit n, and from my experience setting enable_sort to off on the database also makes a massive difference. http://www.postgresql.org/docs/8.3/static/indexes-ordering.html __________________________________________________________ Not happy with your email address?. Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
