Re: hundreds of schema vs hundreds of databases

From: "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at>
To: "Ron Johnson *EXTERN*" <ron(dot)l(dot)johnson(at)cox(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: hundreds of schema vs hundreds of databases
Date: 2007-05-30 06:38:35
Message-ID: AFCCBB403D7E7A4581E48F20AF3E5DB2031291E1@EXADV1.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-05-30 07:07:38 Re: hundreds of schema vs hundreds of databases
Previous Message PFC 2007-05-30 05:42:29 Re: SELECT <all fields except "bad_field"> from mytbl;