Search Postgresql Archives

The database slows down after a few weeks

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

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/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux