Re: Yet another question on LIMIT performance :/

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

On 06.11.2006 15:13, Heikki Linnakangas wrote:
> 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?

Sorry, not all rows, but 80753. It's not clear to me why this number is
so high with LIMIT 10.

--
Regards,
Hannes Dorbath

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-11-06 14:33:02 Re: Yet another question on LIMIT performance :/
Previous Message Madison Kelly 2006-11-06 14:18:03 Re: Setting "nice" values