Re: Increasing query time after updates - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Increasing query time after updates
Date
Msg-id 52DE33B7.7020106@catalyst.net.nz
Whole thread Raw
In response to Re: Increasing query time after updates  ("Katharina Koobs" <katharina.koobs@uni-konstanz.de>)
Responses Re: Increasing query time after updates  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-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



pgsql-performance by date:

Previous
From: "Katharina Koobs"
Date:
Subject: Re: Increasing query time after updates
Next
From: "Tomas Vondra"
Date:
Subject: Re: Increasing query time after updates