Re: Practical limit on number of tables ina single database

Hi Jim,

On 3/24/06, Jim Nasby <jnasby(at)pervasive(dot)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