Increasing query time after updates

From: "Katharina Koobs" <katharina(dot)koobs(at)uni-konstanz(dot)de>
To: <pgsql-performance(at)postgresql(dot)org>
Cc: "'Sebastian Vogt'" <Sebastian(dot)Vogt(at)uni-konstanz(dot)de>
Subject: Increasing query time after updates
Date: 2014-01-21 06:26:52
Message-ID: 000001cf1671$c5e023b0$51a06b10$@uni-konstanz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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


Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2014-01-21 08:06:47 Re: Increasing query time after updates
Previous Message ARCEnergo 2014-01-20 13:55:50 Time of query result delivery