Re: hundreds of schema vs hundreds of databases

On 5/30/07, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)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