"Tom Lane" <tgl@sss.pgh.pa.us> writes
> Steve Crawford <scrawford@pinpointresearch.com> writes:
> > On Monday 21 March 2005 11:40 am, Tom Lane wrote:
> >> However, given that there are 9334 tuples in 82282 pages, I'd say
> >> that autovacuum has already failed Steve rather badly :-(. There
> >> shouldn't be more than a couple hundred pages given that number of
> >> rows. Perhaps the FSM settings are too small?
>
Seems this is another question pointing to the inproper setting of
"can-be-avoided" shared memory parameters. Maybe we should eliminate GUC
parameters related to the FSM. Can we follow Alvaro's idea like spilling
some data of FSM into disk while keeping the indices and maybe part of data
in the memory? So no free page would be discarded due to no space to record
them in FSM? Also, in this handling, efficiency should not be a problem.
Regards,
Qingqing
