Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group