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

Re: Redundant sub query triggers slow nested loop left join

From: "henk de wit" <henk53602(at)hotmail(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Redundant sub query triggers slow nested loop left join
Date: 2007-04-28 09:56:36
Message-ID: BAY106-F169F7960F6410D3F33B2C9F54E0@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-performance
>Well, that's darn odd.  It should not be getting that so far wrong.

I've been puzzling on this for over a week now, but can't seem to find a 
solution. Would you have some more hints of what I could possibly try next? 
As far as I can see, the mentioned status column is just a simple column. Or 
could it be related to the fact that its type is var(1)? Would that confuse 
the planner?

_________________________________________________________________
Talk with your online friends with Messenger 
http://www.join.msn.com/messenger/overview


pgsql-performance by date

Next:From: Jonah H. HarrisDate: 2007-04-28 16:54:18
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning
Previous:From: davidDate: 2007-04-28 01:40:25
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning

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