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

From Albe Laurenz
Subject Re: hundreds of schema vs hundreds of databases
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB2031291E1@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to hundreds of schema vs hundreds of databases  (olivier <om@oliviermigeon.com>)
Responses Re: hundreds of schema vs hundreds of databases
List pgsql-general
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

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: PFC
Date:
Subject: Re: SELECT from mytbl;
Next
From: Ron Johnson
Date:
Subject: Re: hundreds of schema vs hundreds of databases