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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Mike Broers <mbroers(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: plan question - query with order by and limit not choosing index depends on size of limit, table
Date: 2011-01-14 18:03:34
Message-ID: AANLkTinq-xFdC3Lakw6wrJXxeqA+aFGag9w-22cOCtkH@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jan 14, 2011 at 11:36 AM, Mike Broers <mbroers(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2011-01-14 19:01:23 Re: "SELECT .. WHERE NOT IN" query running for hours
Previous Message Mladen Gogala 2011-01-14 16:54:51 Re: The good, old times