| From: | Nabil Sayegh <nas(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:23 |
| Message-ID: | 1053623603.611.2.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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nabil Sayegh | 2003-05-22 17:13:51 | Re: Problem on Linux |
| Previous Message | Renê Salomão | 2003-05-22 16:38:38 | Re: Installing PlPerl |