Re: Yet another question on LIMIT performance :/

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

To: "Hannes Dorbath" <light@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Yet another question on LIMIT performance :/
From: "Heikki Linnakangas" <heikki@xxxxxxxxxxxxxxxx>
Date: Mon, 06 Nov 2006 14:13:19 +0000
Cc: <pgsql-performance@xxxxxxxxxxxxxx>
Importance: normal
In-reply-to: <einfmm$r41$1@xxxxxxxxxxxx>
References: <einfmm$r41$1@xxxxxxxxxxxx>
Thread-index: AccBrc1SEb9C4EfgSE6Wxbbp+vSQ9w==
User-agent: Thunderbird 1.5.0.7 (X11/20060927)

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

References:
- Yet another question on LIMIT performance :/
  - From: Hannes Dorbath

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 :/
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