Tomasz Rakowski wrote:
I see autovacuum process starting in avarage every 5 minutes
(table contains 30.000 records, and update rate is about 1000records /min).
But what is strange is that the number of pages allocated to the table
are constant (at least for this hour: 500)
and number of pages allocated to indexes are constantly growing (109 ->
145, 92 -> 250!!!, 194->256)
But as I stated in first post after a while it gets worse and worse
(thousands of allocated pages for the same number of records..)
You might want to reduce the autovacuum naptime. Every 5 min may not be
frequent enough for you. Also, you might want make sure your FSM
settings are high enough.
