From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Katharina Koobs <katharina.koobs@uni-konstanz.de>
To: pgsql-performance@postgresql.org
Subject: Re: Increasing query time after updates
Date: Tue, 21 Jan 2014 21:45:43 +1300
Message-ID: <52DE33B7.7020106@catalyst.net.nz> (raw)
In-Reply-To: <001701cf1684$151fbf50$3f5f3df0$@uni-konstanz.de>
References: <000001cf1671$c5e023b0$51a06b10$@uni-konstanz.de>
<52DE2A97.60002@vmware.com>
<001701cf1684$151fbf50$3f5f3df0$@uni-konstanz.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 21/01/14 21:37, Katharina Koobs wrote:
> Dear Heikki,
> thank you for your valuable feedback. Regarding your questions: It
> gradually slower every day. The database size is increasing only
> slightly over time.
>
> I will try your hint regarding CLUSTERING. The difference in effect of
> VACUUM FULL in version 9.0 sounds very interesting. I will discuss the
> update to version 9.0 with my colleague.
>
> Any further idea or feedback is much appreciated.
>
>
Index bloat could be a factor too - performing a regular REINDEX on the
relevant tables could be worth a try.
Regards
Mark
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz, katharina.koobs@uni-konstanz.de
Subject: Re: Increasing query time after updates
In-Reply-To: <52DE33B7.7020106@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox