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: Wed, 22 Jan 2014 07:53:20 +1300
Message-ID: <52DEC220.3010609@catalyst.net.nz> (raw)
In-Reply-To: <52DE33B7.7020106@catalyst.net.nz>
References: <000001cf1671$c5e023b0$51a06b10$@uni-konstanz.de>
<52DE2A97.60002@vmware.com>
<001701cf1684$151fbf50$3f5f3df0$@uni-konstanz.de>
<52DE33B7.7020106@catalyst.net.nz>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 21/01/14 21:45, Mark Kirkwood wrote:
> 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.
>
Sorry - I missed that you had tried reindex already.
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: <52DEC220.3010609@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