From: Bruno Wolff III <bruno@wolff.to>
To: nineday <nine9day@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: I have a question about Database management
Date: Mon, 6 Nov 2006 22:38:15 -0600
Message-ID: <20061107043815.GA21764@wolff.to> (raw)
In-Reply-To: <65c8bc260610310305g752746a6w7e765fa60ac7457b@mail.gmail.com>
References: <65c8bc260610310305g752746a6w7e765fa60ac7457b@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bruno@wolff.to, nine9day@gmail.com
Subject: Re: I have a question about Database management
In-Reply-To: <20061107043815.GA21764@wolff.to>
References: <65c8bc260610310305g752746a6w7e765fa60ac7457b@mail.gmail.com> <20061107043815.GA21764@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox