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

From: Kaijiang Chen <chenkaijiang(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
Date: 2015-06-13 17:27:53
Message-ID: CAAkGvS-Ck3NoMz0i7Y__+2u2LOZzZexznRiZYy1eKdrEW5qU6Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2015-06-13 17:43:04 Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
Previous Message ktm@rice.edu 2015-06-12 21:57:03 Re: pg bouncer issue what does sv_used column means