On 10/12/11 04:30, Tom Lane wrote:
> However, it's not apparent to me why you would see any difference
> between 8.2 and 8.4 on this type of query. I tried a query analogous
> to this one on both, and got identical plans. I'm guessing that your
> slowdown is due to not having updated statistics on the new
> installation, or perhaps failing to duplicate some relevant settings.
I notice he has 8.4.*8*... I wonder if he's running into the poor
estimation bug for sub-selects/semi joins that was fixed in 8.4.9.
Kaloyan, can you try the query in 8.4.9?
regards
Mark