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.