On Fri, Mar 24, 2006 at 06:56:19PM -0500, Tom Lane wrote:
> "Just Someone" <[EMAIL PROTECTED]> writes:
> > Actually, most table are VERY small. On each schema I would expect 4 -
> > 5 tables to go over 1000 records. The rest will be much smaller, with
> > most at under 100. And aside from 2-3 table
"Just Someone" <[EMAIL PROTECTED]> writes:
> Actually, most table are VERY small. On each schema I would expect 4 -
> 5 tables to go over 1000 records. The rest will be much smaller, with
> most at under 100. And aside from 2-3 tables, the activity will be
> pretty low (few records a day at the mos
Hi Jim,
Actually, most table are VERY small. On each schema I would expect 4 -
5 tables to go over 1000 records. The rest will be much smaller, with
most at under 100. And aside from 2-3 tables, the activity will be
pretty low (few records a day at the most extreme).
Can I use this to optimize th
On Fri, Mar 24, 2006 at 11:15:56AM -0800, Just Someone wrote:
> 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
>
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
Hi Jim,
> Just make sure you increase max_fsm_relations, and that max_fsm_pages is
> at least > max_fsm_relations, because each relation must get at least
> one page.
I increased it to 4 relations, should I go even higher?
--
Family management on rails: http://www.famundo.com - coming soon!
On Fri, Mar 24, 2006 at 02:33:39AM -0800, Just Someone wrote:
> Hi,
>
> I am creating a hosted solution that I want to base on separation by
> schemas. So that each hosted family we will have, will have a schema
> assigned to it (and a user). On login I will set the search path, and
> so each fami
On 3/24/06, Just Someone <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am creating a hosted solution that I want to base on separation by
> schemas. So that each hosted family we will have, will have a schema
> assigned to it (and a user). On login I will set the search path, and
> so each family will see
Hi,
I am creating a hosted solution that I want to base on separation by
schemas. So that each hosted family we will have, will have a schema
assigned to it (and a user). On login I will set the search path, and
so each family will see it's tables. This is all tested and works
fine.
But I would l
