Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 06 Nov 2006 14:13:19 +0000
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
- Follow-Ups:
- Re: Yet another question on LIMIT performance :/
- From: Tom Lane
- Re: Yet another question on LIMIT performance :/
- From: Hannes Dorbath
- Re: Yet another question on LIMIT performance :/
- References:
- Yet another question on LIMIT performance :/
- From: Hannes Dorbath
- Yet another question on LIMIT performance :/
- Prev by Date: Re: Setting "nice" values
- Next by Date: Re: Yet another question on LIMIT performance :/
- Previous by thread: Yet another question on LIMIT performance :/
- Next by thread: Re: Yet another question on LIMIT performance :/
- Indexes: