On 10/13/2013 8:35 AM, akp geek wrote:
thanks for the advice. One question I have is if I increase the shared_buffers to 16GB, then it won't restart because for the 32 bit version of postgres , we can't have shared buffers more than 3.2 GB right ? ( this from various blogs that I have read )
um, on a 32 bit system, no application can have over ~ 2-3GB of user space, with the top 1-2GB taken by the kernel (this varies with operating system). out of that, I wouldn't use more than about 1GB of shared_buffers.
-- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
