Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Yet another question on LIMIT performance :/
- From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
- To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
- To: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Yet another question on LIMIT performance :/
- Date: Mon, 06 Nov 2006 15:21:35 +0100
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
- References:
- Yet another question on LIMIT performance :/
- From: Hannes Dorbath
- Re: Yet another question on LIMIT performance :/
- From: Heikki Linnakangas
- Yet another question on LIMIT performance :/
- Prev by Date: Re: Yet another question on LIMIT performance :/
- Next by Date: Re: Setting "nice" values
- Previous by thread: Re: Yet another question on LIMIT performance :/
- Next by thread: Re: Yet another question on LIMIT performance :/
- Indexes: