You need to vacum (probably re-index) your tables
periodically to get the best performance.
These vacuming and indexing tools should already
be there with your PostgreSQL installation.
--Imad
www.EnterpriseDB.com
On 10/31/06, nineday <nine9day@xxxxxxxxx> wrote:
I have a trouble.
My DBMS is PostgreSQL which is accessory to Red hat 9.0.
At the initial stages, it was very quick when select ,but operated for
several months , it become to very slow ,especially in a pivotal table.
So,I exported data ,and recreate tables , finally import data, it get right
.
I do not know why. and what is the solution to my trouble
Thank you very much ~~
