Postgres Pro
Downloads
Home   >   mailing lists

Re: Limits to size of shared buffers? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Limits to size of shared buffers?
Date
Msg-id 26470.1029789778@sss.pgh.pa.us
Whole thread Raw
In response to Limits to size of shared buffers?  (Jeff Boes <jboes@nexcerpt.com>)
List pgsql-admin
Tree view 
Jeff Boes <jboes@nexcerpt.com> writes:
> Are there any limits to the size of the shared buffers parameter (as in,
> can Postgres go beyond a 2 GB size when I do something like

Probably not; IIRC the size of the shared memory segment is calculated
using signed integers, so it had better stay under 2Gb.

            regards, tom lane

pgsql-admin by date:

Previous
From: Jeff Boes
Date:
Subject: Limits to size of shared buffers?
Next
From: Robert Treat
Date:
Subject: Re: pg_dumpall and output formats?