Re: [GENERAL] beginners autovacuum question

2011-01-06 Thread Scott Marlowe
On Wed, Jan 5, 2011 at 6:08 PM, u235sentinel wrote: > I'm tracking a problem with our tables being bloated and was curious if > someone regularly kills autovacuum jobs, will autovacuum later reattempt to > vacuum the table it was killed under? > > I've made autovacuum more aggressive and given mor

Re: [GENERAL] beginners autovacuum question

2011-01-05 Thread Devrim GÜNDÜZ
Hi, On Wed, 2011-01-05 at 18:08 -0700, u235sentinel wrote: > I'm tracking a problem with our tables being bloated and was curious > if someone regularly kills autovacuum jobs, will autovacuum later > reattempt to vacuum the table it was killed under? In 8.3+, autovacuum kills itself if when it c

[GENERAL] beginners autovacuum question

2011-01-05 Thread u235sentinel
I'm tracking a problem with our tables being bloated and was curious if someone regularly kills autovacuum jobs, will autovacuum later reattempt to vacuum the table it was killed under? I've made autovacuum more aggressive and given more worker threads. Yet for some reason we're not keeping u