| From: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Łukasz Jagiełło <lukasz(dot)jagiello(at)gforces(dot)pl>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Problems with autovacuum |
| Date: | 2009-05-25 15:50:35 |
| Message-ID: | 2f4958ff0905250850j4c901c6br9bc26f2804bfaf37@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
2009/5/25 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
>
> So, in 2000 databases, there's only an average of 2 relations per db
> and 102 dead rows? Cause that's all you got room for with those
> settings.
>
> Whats the last 20 or so lines of vacuum verbose as run by a superuser say?
according to http://www.postgresql.org/docs/8.1/interactive/runtime-config-resource.html
max_fsm_relations applies only to tables and indices, and it says "in
database", so I presume that means per database. In which case, those
settings are ok.
It would be nice, to see if vacuum actually complains about it.
--
GJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-05-25 16:15:48 | Re: Problems with autovacuum |
| Previous Message | Scott Marlowe | 2009-05-25 15:32:20 | Re: Problems with autovacuum |