For a 64 bit machine..does the higher shared buffer setting really offer a significant improvement over a 32 bit lower setting coupled with linux caching ? Is the postgres shared buffer algorithm superior to the linux caching algorithm to favor a switch to 64 bit
On Fri, Sep 11, 2009 at 9:50 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Nicolas Michel <nicolas.mic...@lemail.be> writes: >> - I have 16Go of RAM on that server (but 32bits OS with bigmem kernel ; >> so I set shared buffer to 350000 (~2,7GB) for a shmmax of 4000000000 >> (~3,8GB) > > On a 32-bit machine that's just insane. You've got something like 300MB > left over in the process address space (assuming the typical 1Gb for > kernel split). No wonder things are falling over. Try putting > shared_buffers somewhere around 1Gb. Or switch to 64-bit. > > regards, tom lane > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
