From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
---|---|
To: | Bekar Bartaia <bbartaia(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: The database slows down after a few weeks |
Date: | 2007-07-26 17:17:20 |
Message-ID: | 20070726131720.358a50b5.wmoran@potentialtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In response to Bekar Bartaia <bbartaia(at)yahoo(dot)com>:
> Hello
>
> We have a problem with our database. It is accessed by
> Java using Hibernate. When the program has been
> running for a couple of weeks some transactions are
> delayed and are executed up to an hour later than then
> they are first called.
What is your maintenance schedule? Specifically: vacuum
and analyze? What is the output of vacuum verbose when
you are experiencing the problem?
> If the computer is restarted it will take about a week
> before the problems appear again.
>
> If the following sequence of commands is executed
> (reinserting the data) then it will take a couple of
> weeks before the problem appears again.
>
> pg_dump > file.sql
> dropdb
> createdb
> psql < file.sql
>
> Is this behaviour something seen before and in that
> case: how to get around it? I also need to know why it
> is happening so that when I have a solution I can
> guarantee that the problem will not appear again.
>
> The system with the problem is unfortunately placed
> abroad with very limited remote access. Therefore "Try
> this, and try that"-solutions are not possible in this
> case. I have a hard time reproducing the error on my
> local system which makes the problem so much harder.
>
> If no cause can be found: Are there any other useful
> tips?
>
> Versions running:
> Linux Fedora Core 3
> psql (PostgreSQL) 7.4.8
> jdk1.5.0_02
>
>
>
> ____________________________________________________________________________________
> Luggage? GPS? Comic books?
> Check out fitting gifts for grads at Yahoo! Search
> http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
--
Bill Moran
http://www.potentialtech.com
From | Date | Subject | |
---|---|---|---|
Next Message | Kaloyan Iliev | 2007-07-26 17:19:12 | NOTICE Acepted as Error After Upgrade |
Previous Message | Bekar Bartaia | 2007-07-26 16:48:20 | The database slows down after a few weeks |