Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance of full outer join in 8.3 - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Performance of full outer join in 8.3
Date
Msg-id 2f4958ff0904150531h32358fex5cb705472abd271e@mail.gmail.com
Whole thread Raw
In response to Re: Performance of full outer join in 8.3  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Performance of full outer join in 8.3
List pgsql-general
Tree view 
On Wed, Apr 15, 2009 at 1:25 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> The cost of the query seems accurate, so the absence of
> attachment_isins_attachment_idx on the 8.3 plan looks to be the reason.
> There's no way it would choose to scan 8115133 rows on the pkey if the
> other index was available and usable.

hance my question, if there's index on it in 8.3 version of db.



--
GJ

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Performance of full outer join in 8.3
Next
From: William Temperley
Date:
Subject: Re: Disconnected editing - versioning of databases