Re: Yet another question on LIMIT performance :/

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Hannes Dorbath" <light(at)theendofthetunnel(dot)de>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Yet another question on LIMIT performance :/
Date: 2006-11-06 14:13:19
Message-ID: 454F42FF.3070901@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hannes Dorbath wrote:
> Though it should only have to join a few rows it seems to scan all rows.

What makes you think that's the case?

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Madison Kelly 2006-11-06 14:18:03 Re: Setting "nice" values
Previous Message Hannes Dorbath 2006-11-06 14:13:10 Yet another question on LIMIT performance :/