Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0EE329FB1DE for ; Tue, 7 Nov 2006 00:38:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 13072-06 for ; Tue, 7 Nov 2006 04:38:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id F08709F9312 for ; Tue, 7 Nov 2006 00:38:20 -0400 (AST) Received: (qmail 22744 invoked by uid 500); 7 Nov 2006 04:38:15 -0000 Date: Mon, 6 Nov 2006 22:38:15 -0600 From: Bruno Wolff III To: nineday Cc: pgsql-admin@postgresql.org Subject: Re: I have a question about Database management Message-ID: <20061107043815.GA21764@wolff.to> Mail-Followup-To: Bruno Wolff III , nineday , pgsql-admin@postgresql.org References: <65c8bc260610310305g752746a6w7e765fa60ac7457b@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <65c8bc260610310305g752746a6w7e765fa60ac7457b@mail.gmail.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/41 X-Sequence-Number: 23568 On Tue, Oct 31, 2006 at 19:05:58 +0800, nineday 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.