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