Re: hundreds of schema vs hundreds of databases - Mailing list pgsql-general

From Merlin Moncure
Subject Re: hundreds of schema vs hundreds of databases
Date
Msg-id b42b73150705301031m3ff42f84w31dc7e74fce7f65c@mail.gmail.com
Whole thread Raw
In response to Re: hundreds of schema vs hundreds of databases  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
On 5/30/07, Ron Johnson <ron.l.johnson@cox.net> wrote:
> On 05/30/07 01:38, Albe Laurenz wrote:
> > Ron Johnson wrote:
> >> Does PG set up buffers at the postmaster level or the database level?
> >>
> >> If at the database level, then you'll be allocating memory to
> >> databases that might not be in use at any one time, thus wasting it.
> >>   One database buffer pool would make more efficient use of RAM.
> >
> > Shared memory is allocated at the cluster level.
> > See
> > http://www.postgresql.org/docs/current/static/runtime-config-resource.ht
> > ml#RUNTIME-CONFIG-RESOURCE-MEMORY
>
> I read that page, but don't see any references to "cluster level".
> Maybe I am misinterpreting "cluster"?

Meaning the database cluster:
http://www.postgresql.org/docs/8.2/static/creating-cluster.html.

I can understand your confusion though.

merlin

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: jdbc pg_hba.conf error
Next
From: Richard Huxton
Date:
Subject: Re: Problem - any password accepted