Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-performance by date:

Previous
From: Tobias Brox
Date:
Subject: Re: Setting "nice" values
Next
From: Hannes Dorbath
Date:
Subject: Re: Yet another question on LIMIT performance :/