Re: vacuum locking - Mailing list pgsql-performance

From Rob Nagler
Subject Re: vacuum locking
Date
Msg-id 16272.30527.120343.547492@jump.bivio.com
Whole thread Raw
In response to Re: vacuum locking  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-performance
Manfred Koizar writes:
> ISTM you are VACCUMing too aggressively.  You are reclaiming less than
> 1% and 0.005%, respectively, of tuples.  I would increase FSM settings
> to ca. 1000 fsm_relations, 100000 fsm_pages and VACUUM *less* often,
> say every two hours or so.

I did this.  We'll see how it goes.

> ... or configure autovacuum to VACUUM a table when it has 10% dead
> tuples.

This solution doesn't really fix the fact that VACUUM consumes the
disk while it is running.  I want to avoid the erratic performance on
my web server when VACUUM is running.

mfg,
Rob


pgsql-performance by date:

Previous
From: Murthy Kambhampaty
Date:
Subject: Re: [ADMIN] backup/restore - another area.
Next
From: Rob Nagler
Date:
Subject: Re: vacuum locking