hello to all,
I've a question regarding the folowing comments.
How to estimate vacuum aggressiveness ?
It's for me very deficulte to setup the autovaccum setting correctly. It
seems for me that it is not enough aggressive, but when I change the
settings the autovacuum process is almost always running.
So how to setup it, for around 40000 insert, update, delete per 5 minutes
regards
david
Scott Marlowe a écrit :
On Sat, Aug 23, 2008 at 6:59 PM, Loic Petit <tls.wydd@xxxxxxx> wrote:
1 table contains about 5 indexes : timestamp, one for each sensor type - 3,
and one for packet counting (measures packet dropping)
(I reckon that this is quite heavy, but a least the timestamp and the values
are really usefull)
But what's the update rate on these indexes and tables? I'm wondering
if you're not vacuuming aggresively enough to keep up with bursty
update patterns
