Re: The database slows down after a few weeks - Mailing list pgsql-general

From Damian C
Subject Re: The database slows down after a few weeks
Date
Msg-id 2bbc8f530707261336h4ec44c65n237e26e6d8dee515@mail.gmail.com
Whole thread Raw
In response to Re: The database slows down after a few weeks  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 7/27/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Bekar Bartaia <bbartaia@yahoo.com> writes:
>
> > Versions running:
> > Linux Fedora Core 3
> > psql (PostgreSQL) 7.4.8
> > jdk1.5.0_02
>
> The first tip I'd give you is to get onto something newer than PG 7.4.
> Fedora 3 is pretty long in the tooth as well.

Although unlikely to be related to your problem or its solution, but
jdk1.5.0_02 is certainly not recommended. The "5" series is currently
at 1.5.0_12.  Also, it is likely that an update to JRE6 (currently
1.6.0_02 Build 06) would yield few problems and significant
performance gains for a 10 minute effort.
-Damian

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: The database slows down after a few weeks
Next
From: John Koller
Date:
Subject: Re: Question about Postgres