Hi Jim,
On 3/24/06, Jim Nasby <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
