From: Kiriakos Tsourapas <ktsour@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Postgres becoming slow, only full vacuum fixes it
Date: Wed, 3 Oct 2012 16:39:04 +0300
Message-ID: <61492A85-AB61-4F8B-A59D-E1483FF51B73@gmail.com> (raw)
In-Reply-To: <5526E5B0-DDCD-4D47-91B7-B3D4CA11A83E@gmail.com>
References: <20120926113953.221020@gmx.com>
<34C83EA2-7004-4D37-9674-ADFB4A475C07@gmail.com>
<5526E5B0-DDCD-4D47-91B7-B3D4CA11A83E@gmail.com>
I am posting back to let you know that the DB is working fine since the changes in the autovacuum settings.
I am including the changes I made for later reference to anyone that may face similar issues.
Thank you all for your time and help !
On Sep 28, 2012, at 9:52, Kiriakos Tsourapas wrote:
> Dear all,
>
> Just letting you know that making the autovacuum policy more aggressive seems to have fixed the problem.
> It's been 4 days now and everything is running smoothly.
>
> Just a reminder, what I changed was :
> autovacuum_vacuum_scale_factor = 0.01
> autovacuum_analyze_scale_factor = 0.005
> making autovacuum run at 1% instead of 20% (the dafault) and the analyze run at 0,5% instead of 10%.
>
> Maybe it's more aggressive than needed... I will monitor and post back.
>
>
> Thank you all for your help.
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: ktsour@gmail.com
Subject: Re: Postgres becoming slow, only full vacuum fixes it
In-Reply-To: <61492A85-AB61-4F8B-A59D-E1483FF51B73@gmail.com>
* 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