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 <tgl@xxxxxxxxxxxxx> wrote: > Nicolas Michel <nicolas.michel@xxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
