From: Scott Marlowe <scott.marlowe@gmail.com>
To: Andrej Ricnik-Bay <andrej.groups@gmail.com>
Cc: sathiya psql <sathiya.psql@gmail.com>
Cc: bitaoxiao <bitaoxiao@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Max shared_buffers
Date: Thu, 3 Apr 2008 11:48:58 -0600
Message-ID: <dcc563d10804031048w1dd47d35t159446c53282076f@mail.gmail.com> (raw)
In-Reply-To: <b35603930804031016k4f1d2c28x1753da0e7cc7c651@mail.gmail.com>
References: <47F324B4.6010404@mansionfamily.plus.com>
<b42b73150804022136y23e320e7w86540f2264aad33e@mail.gmail.com>
<200804031256103599734@gmail.com>
<f966c2ee0804030310w3581a17byb2f46f9b276d11b@mail.gmail.com>
<dcc563d10804030949q64faad5ej2ca587faf4f5cae3@mail.gmail.com>
<b35603930804031016k4f1d2c28x1753da0e7cc7c651@mail.gmail.com>
On Thu, Apr 3, 2008 at 11:16 AM, Andrej Ricnik-Bay
<andrej.groups@gmail.com> wrote:
> On 04/04/2008, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> > Not entirely true. on 32 bit OS / software, the limit is just under 2
> > Gig.
>
> Where do you get that figure from?
>
> There's an architectural (theoretical) limitation of RAM at 4GB,
> but with the PAE (that pretty much any CPU since the Pentium Pro
> offers) one can happily address 64GB on 32-bit.
>
> Or are you talking about some Postgres limitation?
Note I was talking about running 32 bit postgresql (on either 32 or 64
bit hardware, it doesn't matter) where the limit we've seen in the
perf group over the years has been just under 2G.
I'm extrapolating that on 64 bit hardware, 64 bit postgresql's limit
would be similar, i.e. 2^63-x where x is some small number that keeps
us just under 2^63.
So, experience and reading here for a few years is where I get that
number from. But feel free to test it. It'd be nice to know you
could get >2Gig shared buffer on 32 bit postgresql on some
environment.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scott.marlowe@gmail.com, andrej.groups@gmail.com, sathiya.psql@gmail.com, bitaoxiao@gmail.com
Subject: Re: Max shared_buffers
In-Reply-To: <dcc563d10804031048w1dd47d35t159446c53282076f@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox