Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sat, 28 Apr 2007 11:56:36 +0200
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
- Prev by Date: Re: Feature Request --- was: PostgreSQL Performance Tuning
- Next by Date: Re: Feature Request --- was: PostgreSQL Performance Tuning
- Previous by thread: Re: Redundant sub query triggers slow nested loop left join
- Next by thread: Re: Redundant sub query triggers slow nested loop left join
- Indexes: