Performance problems
От | marco |
---|---|
Тема | Performance problems |
Дата | |
Msg-id | 1051282419.1045.28.camel@rudolf.mpi-halle.mpg.de обсуждение исходный текст |
Ответы |
Re: Performance problems
Re: Performance problems Re: Performance problems Re: Performance problems |
Список | 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
В списке pgsql-general по дате отправления: