Re: Yet another question on LIMIT performance :/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Heikki Linnakangas <heikki@xxxxxxxxxxxxxxxx>
To: pgsql-performance@xxxxxxxxxxxxxx
Subject: Re: Yet another question on LIMIT performance :/
From: Hannes Dorbath <light@xxxxxxxxxxxxxxxxxxxx>
Date: Mon, 06 Nov 2006 15:21:35 +0100
In-reply-to: <454F42FF.3070901@xxxxxxxxxxxxxxxx>
Organization: Hub.Org Networking Services
References: <einfmm$r41$1@xxxxxxxxxxxx> <454F42FF.3070901@xxxxxxxxxxxxxxxx>
User-agent: Thunderbird 1.5.0.7 (Windows/20060909)

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 isso 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

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 :/
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux