Re: Performance Optimization for Dummies 2 - the SQL - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: Performance Optimization for Dummies 2 - the SQL
Date
Msg-id b42b73150610031221y4955e663ped999a83a810d318@mail.gmail.com
Whole thread Raw
In response to Re: Performance Optimization for Dummies 2 - the SQL  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
List pgsql-performance
On 10/3/06, Carlo Stonebanks <stonec.register@sympatico.ca> wrote:
> Please ignore sample 1 - now that I have the logging feature, I can see that
> my query generator algorithm made an error.

can you do explain analyze on the two select queries on either side of
the union separatly?  the subquery is correctly written and unlikely
to be a problem (in fact, good style imo).  so lets have a look at
both sides of facil query and see where the problem is.

merlin

pgsql-performance by date:

Previous
From: Graham Davis
Date:
Subject: Re: BUG #2658: Query not using index
Next
From: Chris Browne
Date:
Subject: Re: BUG #2658: Query not using index