Postgres Pro
Downloads
Home   >   mailing lists

Re: Yet another question on LIMIT performance :/ - Mailing list pgsql-performance

From Hannes Dorbath
Subject Re: Yet another question on LIMIT performance :/
Date
Msg-id 454F44EF.1090401@theendofthetunnel.de
Whole thread Raw
In response to Re: Yet another question on LIMIT performance :/  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: Yet another question on LIMIT performance :/
Next
From: Madison Kelly
Date:
Subject: Re: Setting "nice" values