Re: performance tuning - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: performance tuning
Date
Msg-id asjqec$2ii8$1@news.hub.org
Whole thread Raw
In response to performance tuning  (Joseph Shraibman <jks@selectacast.net>)
Responses Re: performance tuning  (Martijn van Oosterhout <kleptog@svana.org>)
Re: performance tuning  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Postgresql -- initial impressions and comments
Next
From: Adrian Klaver
Date:
Subject: Drop column and Access