Re: performance tuning

On Tue, Dec 03, 2002 at 09:48:46PM -0500, Joseph Shraibman wrote:
> Joseph Shraibman wrote:
> >Since postgres
> >seems to think that the nested loop takes so long do I have to lower
> >cpu_operator_cost to get postgres to use the nested loop?
>
> To answer my own question that doesn't work. I've kept playing around with
> different paramaters with different variables but I can't find anything
> except disabling seqscans.
>
> This is really annoying, because *all* of my queries suddenly slowed down
> at the same time. What can I do?  Is there something I can change in the
> source to have nested loops seem cheaper? I haven't found anything.

What does explain analyze tell you?
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.