From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
---|---|
To: | "Molenda, Mark P" <mark(dot)molenda(at)eds(dot)com> |
Cc: | Pgsql-Novice "(pgsql-novice(at)postgresql(dot)org)" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Problem on Linux |
Date: | 2003-05-22 17:13:51 |
Message-ID: | 1053623630.628.6.camel@billy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Am Don, 2003-05-22 um 16.33 schrieb Molenda, Mark P:
> Is there a better way? And how do I tune the stock RedHat version? I
> really don't want to have to load it again from scratch (source).
Did you try a: "VACUUM ANALYZE" ?
It calculates indexes etc. automatically (depending on your usage).
Also you could try "EXPLAIN <your query>" to get a hint how postgresql
handles it and maybe to improve the querys manually.
HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : www.e-trolley.de
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : www.e-trolley.de
From | Date | Subject | |
---|---|---|---|
Next Message | Nabil Sayegh | 2003-05-22 17:16:13 | Re: timestamp data type? |
Previous Message | Nabil Sayegh | 2003-05-22 17:13:23 | Re: Problem on Linux |