From: Miernik <public@public.miernik.name>
To: pgsql-performance@postgresql.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: Sat, 9 Aug 2008 23:36:35 +0200
Message-ID: <20080809213635.7270.0.NOFFLE@turbacz.local> (raw)
References: <20080809203435.7227.0.NOFFLE@turbacz.local>
<11224.1218315478@sss.pgh.pa.us>
<20080809211932.7252.0.NOFFLE@turbacz.local>
Miernik <public@public.miernik.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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: public@public.miernik.name
Subject: Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK?
In-Reply-To: <20080809213635.7270.0.NOFFLE@turbacz.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox