Re: Optimizer Selecting Incorrect Index

From: Richard Huxton <dev(at)archonet(dot)com>
To: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
Cc: David Price <dprice(at)dentfirst(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimizer Selecting Incorrect Index
Date: 2004-08-26 10:17:34
Message-ID: 412DB8BE.9060106@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dennis Bjorklund wrote:
> On Wed, 25 Aug 2004, Richard Huxton wrote:
>>
>>These queries are different. The first returns 687 rows and the second
>>713 rows.
>
>
> The 687 and 713 are the number of rows in the plan, not the number of rows
> the queries return.

D'OH! Thanks Dennis

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Price 2004-08-26 11:05:26 Re: Optimizer Selecting Incorrect Index
Previous Message Hervé Piedvache 2004-08-26 07:22:01 Re: TSearch2 and optimisation ...