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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
