Обсуждение: I have a question about Database management
My DBMS is PostgreSQL which is accessory to Red hat 9.0.
So,I exported data ,and recreate tables , finally import data, it get right .
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@gmail.com> 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 ~~
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of nineday
Sent: Tuesday, October 31, 2006 3:06 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] I have a question about Database management
My DBMS is PostgreSQL which is accessory to Red hat 9.0.
So,I exported data ,and recreate tables , finally import data, it get right .
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged. If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.
Thank you.
FADLD Tag
**********************************************************************
On Tue, Oct 31, 2006 at 19:05:58 +0800, nineday <nine9day@gmail.com> 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 ~~ You should probably also upgrade. The version of Postgres that came with RH9 is going to be very old now. You should probably upgrade the OS as well. While RH9 is supported by the Legacy project, they haven't exactly been cranking out lots of fixes, so you should be very careful if that system is exposed to attack over a network.