DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=epgDddQ5Sp35rS0ACXvTy0d4DNazhlXaBaF+md70TbFroxLsmLt1ttjGfTBXGD/D2d
	BqlD3Q3pXVh6suZQgg0grD9qZktrcRbT1tBG7OKB/uP8brPPw/OYWrYtsILFszgjWT2q
	oFDGMZxAsRY+5wqDuyR2b3a58ZQcEcCifs+J8=
MIME-Version: 1.0
In-Reply-To: <4B765B94.4000602@obviously.com>
References: <4B723042.7090406@obviously.com>
	<4B751AD5020000250002F248@gw.wicourts.gov>
	<4B757C59.8070500@denninger.net>
	<4B752934020000250002F24E@gw.wicourts.gov>
	<4B75851E.6070909@denninger.net> <26772.1266005254@sss.pgh.pa.us>
	<4B765B94.4000602@obviously.com>
Date: Mon, 15 Feb 2010 11:41:43 -0500
Message-ID: <603c8f071002150841w53cda2f6l7901e7af06da862@mail.gmail.com>
Subject: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3
	query planner quirk?
From: Robert Haas <robertmhaas@gmail.com>
To: Bryce Nesbitt <bryce2@obviously.com>
Cc: pgsql-performance@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Sat, Feb 13, 2010 at 2:58 AM, Bryce Nesbitt <bryce2@obviously.com> wrote=
:
> So as the op, back to the original posting....
>
> In the real world, what should I do?=A0 Does it make sense to pull the "A=
ND
> articles.indexed" clause into an outer query?=A0 Will that query simply
> perform poorly on other arbitrary combinations of words?

It's really hard to say whether a query that performs better is going
to always perform better on every combination of words.  My suggestion
is - try it and see.  It's my experience that rewriting queries is a
pretty effective way of speeding them up, but I can't vouch for what
will happen in your particular case.  It's depressing to see that
increasing the statistics target didn't help much; but that makes me
think that the problem is that your join selectivity estimates are
off, as Tom and Jorge said upthread.  Rewriting the query or trying an
upgrade are probably your only options.

...Robert