Re: [PERFORM] determining max_fsm_pages

2004-10-29 Thread Tom Lane
Patrick Hatcher <[EMAIL PROTECTED]> writes: > My question is this: I have about 8 databases running on this server. > When I do a vacuum full on each of these databases, there is a INFO > section that I assume is the total pages used for that database. Should > add ALL these individual pages

Re: [PERFORM] determining max_fsm_pages

2004-10-29 Thread Tatsuo Ishii
> Pg: 7.4.5 > 8G ram > 200G RAID5 > > I have my fsm set as such: > max_fsm_pages = 30 # min max_fsm_relations*16, 6 bytes each > max_fsm_relations = 500 # min 100, ~50 bytes each > > > I just did a vacuum full on one table and saw this result: > INFO: analyzing "cdm.cdm_fe

[PERFORM] determining max_fsm_pages

2004-10-29 Thread Patrick Hatcher
Pg: 7.4.5 8G ram 200G RAID5 I have my fsm set as such: max_fsm_pages = 30 # min max_fsm_relations*16, 6 bytes each max_fsm_relations = 500 # min 100, ~50 bytes each I just did a vacuum full on one table and saw this result: INFO: analyzing "cdm.cdm_fed_agg_purch" INFO: "cdm_