Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?

From: Miernik <public(at)public(dot)miernik(dot)name>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
Date: 2008-08-09 21:36:35
Message-ID: 20080809213635.7270.0.NOFFLE@turbacz.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Miernik <public(at)public(dot)miernik(dot)name> wrote:
> How can I bring it back to working? Like un-run ANALYZE on that table or
> something? All was running reasonably well before I changed from
> autovacuum to running ANALYZE manually, and I thought I would improve
> performance... ;(

I now removed all manual ANALYZE commands from the scripts, set
enable_hashjoin = on
enable_mergejoin = on
and set on autovacuum, but it didn't bring back the performance of that query :(

--
Miernik
http://miernik.name/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-08-09 21:37:29 Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
Previous Message Miernik 2008-08-09 21:19:32 Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?