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 |
