Postgres Pro
Downloads
Home   >   mailing lists

Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux? - Mailing list pgsql-performance

From Kaijiang Chen
Subject Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
Date
Msg-id CAAkGvS-Ck3NoMz0i7Y__+2u2LOZzZexznRiZYy1eKdrEW5qU6Q@mail.gmail.com
Whole thread Raw
Responses Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
List pgsql-performance
Tree view
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 the 64 bit Linux server?

Thanks and regards,
Kaijiang

pgsql-performance by date:

Previous
From: "ktm@rice.edu"
Date:
Subject: Re: pg bouncer issue what does sv_used column means
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?