Increasing query time after updates

Поиск
Список
Период
Сортировка
От Katharina Koobs
Тема Increasing query time after updates
Дата
Msg-id 000001cf1671$c5e023b0$51a06b10$@uni-konstanz.de
обсуждение исходный текст
Ответы Re: Increasing query time after updates  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Re: Increasing query time after updates  ("Tomas Vondra" <tv@fuzzy.cz>)
Список pgsql-performance

Hi,

 

We have a PostgreSQL DB, version 8.4 on a Suse Linux system.

Every night a script runs with several updates and inserts. The query time at day increases after

approximately 3 weeks from a few minutes to about an hour.

After export, drop and import the DB the query time is again at a few minutes.

 

We have tested vacuum full, vacuum analyze and reindex and get no improvement.

 

Has anyone an idea why the queries are getting slower and slower?

 

Thank you so much for your help!

 

 

The DB configuration:

 

Virtual server, 7GB RAM, DB size = 16GB

 

shared_buffers = 1024MB

temp_buffers = 32MB

work_mem = 8MB

checkpoint_segments = 20

effective_cache_size = 512MB

max_locks_per_transaction = 256

 

 

В списке pgsql-performance по дате отправления:

Предыдущее
От: ARCEnergo
Дата:
Сообщение: Time of query result delivery
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Increasing query time after updates