Re: Postgres becoming slow, only full vacuum fixes it

From: Kiriakos Tsourapas <ktsour(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres becoming slow, only full vacuum fixes it
Date: 2012-09-28 06:52:10
Message-ID: 5526E5B0-DDCD-4D47-91B7-B3D4CA11A83E@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeremy Harris 2012-09-28 10:38:07 Re: hardware advice
Previous Message Scott Marlowe 2012-09-27 23:57:47 Re: hardware advice