Re: [ADMIN] Why auto vacuum almost running all the time on one toast table?

2012-06-12 Thread Tom Lane
Rural Hunter writes: > v9.1.3 on Ubuntu 10.04 server. I have one table which has frequent > insert and weekly deletion, no update. Recently, I found the auto vacuum > on the toast table of it almost running all the time. each run took > around 1 hour. I don't think there are so many inerts so t

[ADMIN] Why auto vacuum almost running all the time on one toast table?

2012-06-12 Thread Rural Hunter
v9.1.3 on Ubuntu 10.04 server. I have one table which has frequent insert and weekly deletion, no update. Recently, I found the auto vacuum on the toast table of it almost running all the time. each run took around 1 hour. I don't think there are so many inerts so that it reaches the auto vacuu