From: Justin <justin@emproshunts.com>
To: pgsql-performance@postgresql.org
Subject: [Fwd: Re: Max shared_buffers]
Date: Thu, 03 Apr 2008 13:21:27 -0500
Message-ID: <47F52027.8070503@emproshunts.com> (raw)
Scott Marlowe wrote:
> On Thu, Apr 3, 2008 at 4:10 AM, sathiya psql <sathiya.psql@gmail.com> wrote:
>
>> There is NO MAX....
>>
>> It is according to your hardware you have, and the db you have.
>>
>
> Not entirely true. on 32 bit OS / software, the limit is just under 2
> Gig. I'd imagine that the limit on 64 bit hardware / software is
> therefore something around 2^63-somesmallnumber which is, for all
> practical purposes, unlimited.
>
>
Its limited only by the hardware and OS you are running. Some OS's on
32bit allow for up to 4 gigs but you have to leave room for the OS and
other running processes. On 64 bit hardware it can be limited by the
Hardware along with OS where its artificially limited to 32gigs, 64 gigs
and 2TB seem to be the most common limits set by the hardware or OS.
But again you have to leave room in these setting for other processes if
not out memory errors will occur and may crash the server.
In general these setting are only limited by the Hardware and OS
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: justin@emproshunts.com
Subject: Re: [Fwd: Re: Max shared_buffers]
In-Reply-To: <47F52027.8070503@emproshunts.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