Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer Selecting Incorrect Index - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Optimizer Selecting Incorrect Index
Date
Msg-id 412DB8BE.9060106@archonet.com
Whole thread Raw
In response to Re: Optimizer Selecting Incorrect Index  (Dennis Bjorklund <db@zigo.dhs.org>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Hervé Piedvache
Date:
Subject: Re: TSearch2 and optimisation ...
Next
From: "David Price"
Date:
Subject: Re: Optimizer Selecting Incorrect Index