| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Jesse Long *EXTERN*" <jpl(at)unknown(dot)za(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Incorrect index being used |
| Date: | 2013-10-11 09:23:28 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17C2975B@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SUNDAY A. OLUTAYO | 2013-10-11 09:24:56 | Re: Forms for entering data into postgresql |
| Previous Message | Víctor Cosqui | 2013-10-11 08:54:50 | Re: Doubt with physical storage being used by postgres when storing LOBs |