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

-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, 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 wor

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

On 06/13/2015 10:27 AM, Kaijiang Chen wrote: 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

[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