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
