Postgres Pro
Downloads
Home   >   mailing lists

Re: plan question - query with order by and limit not choosing index depends on size of limit, table - Mailing list pgsql-performance

From Robert Haas
Subject Re: plan question - query with order by and limit not choosing index depends on size of limit, table
Date
Msg-id AANLkTinq-xFdC3Lakw6wrJXxeqA+aFGag9w-22cOCtkH@mail.gmail.com
Whole thread Raw
In response to Re: plan question - query with order by and limit not choosing index depends on size of limit, table  (Mike Broers <mbroers@gmail.com>)
List pgsql-performance
Tree view 
On Fri, Jan 14, 2011 at 11:36 AM, Mike Broers <mbroers@gmail.com> wrote:
> Thanks Robert, this is what I was looking for.  I will try these suggestions
> and follow up if any of them are the silver bullet.

No problem - and sorry for the off-list reply.  I was a little sleepy
when I wrote that; thanks for getting it back on-list.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-performance by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: The good, old times
Next
From: Robert Haas
Date:
Subject: Re: "SELECT .. WHERE NOT IN" query running for hours