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.