Hi Jim,
On 3/24/06, Jim Nasby <jnasby@pervasive.com> wrote:
> You want max_fsm_relations to be greater than select count(*) from pg_class where
> relkind in ('i','t') *across all databases*. And you want max_fsm_pages to be bigger than
> that. That's the only way you can be assured that you'll be tracking free space info for
> every table.
So I need something like 2,000,000 in max_fsm_relations. So
max_fsm_pages now need to be 16 times that? That's how I read the
postgresql.conf comment.
> Taking a look at the last few lines of a vacuumdb -av would also be insightful, but I'm
> pretty certain that will only show what you need right *now*, not what you might need in
> the future.
Thanks!
Bye,
Guy
--
Family management on rails: http://www.famundo.com - coming soon!
My development related blog: http://devblog.famundo.com