Re: [PERFORM] Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?

to allocate memory with any 64-bit size. So, it improves the performance. On 6/14/15, Joe Conway wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 06/13/2015 10:43 AM, Joshua D. Drake wrote: >> >> On 06/13/2015 10:27 AM, Kaijiang Chen wrote: >>> Hi

[PERFORM] Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?

Hi, I am using postgresql 9.2.10 on centos 6.2, 64 bit version. The server has 512 GB mem. The jobs are mainly OLAP like. So I need larger work_mem and shared buffers. From the source code, there is a constant MaxAllocSize==1GB. So, I wonder whether work_mem and shared buffers can exceed 2GB in th