Performance problems

From: marco <wedekind(at)mpi-halle(dot)mpg(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Performance problems
Date: 2003-04-25 14:53:39
Message-ID: 1051282419.1045.28.camel@rudolf.mpi-halle.mpg.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

I've a little performance problem with psql 7.2.3.

I have a little database with approx. eight tables. They have two or six
columns and less than 2000 rows.

Three of them are regularly updated by a small C++-tool. It inserts or
updates entries of these three tables. All entries of one of these
tables are deleted with "Delete from..." everytime the tools runs (e.g.
every 20 minutes).

I'm using indices on all tables.

Now I can observe the following phenomenon:

The total runtime of the tool is increasing up to a certain peak and
then it drops to the half of the peak.
The time interval from one peak to the next is also increasing as well
as the total value of the peak.

But the total time for database access is not only increasing for write
access but also for read access.

The time it takes to Select things from the database is increasing too.

I unfortunately don't understand the whole thing totally, but if I dump
the database (with pg_dump), delete it and restore it, the time values
for reading and writing have decreased to a normal level and begin to
increase again.

It seems to me, that I do sth. fundamentally wrong :( But even after
searching google and the postgresql archives I don't see the light at
all...

Please help me out here.

Thanks and best regards

Marco Wedekind

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Manuel Durán Aguete 2003-04-25 15:05:59 Re: Performance problems
Previous Message Joe Conway 2003-04-25 14:35:51 Re: Returning with a userd defined type (PL/pgSQL)