| From: | Matthew O'Connor <matthew(at)zeut(dot)net> |
|---|---|
| To: | Tomasz Rakowski <mourawi(at)yahoo(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: autovacumm not working ? |
| Date: | 2007-06-28 04:05:53 |
| Message-ID: | 468333A1.10806@zeut.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luki Rustianto | 2007-06-28 04:51:02 | Pg7.4.x plpgsql trigger execution order bug |
| Previous Message | Alvaro Herrera | 2007-06-28 01:36:00 | Re: varchar(n) VS text |