Re: Incorrect index being used - Mailing list pgsql-general

From Albe Laurenz
Subject Re: Incorrect index being used
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C2975B@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Re: Incorrect index being used  (Jesse Long <jpl@unknown.za.net>)
List pgsql-general
Jesse Long wrote:
> I did ALTER COLUMN SET STATISTICS 10000 for each column involved after
> that (is that what you meant?). But it did not make much difference, but
> I have read the manual regarding this setting and think I understand it.
> 
> Would it be a bad idea to ALTER COLUMN SET STATISTICS 100000? Would that
> have a very negative impact on disk usage or performace?

No, in the light of what Tom wrote, I was on the wrong track entirely
and your best bet is probably to rewrite the query.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Víctor Cosqui
Date:
Subject: Re: Doubt with physical storage being used by postgres when storing LOBs
Next
From: hiroyuki shiga
Date:
Subject: Re: postgresql9.1.6 core dump