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

Поиск
Список
Период
Сортировка
От Kaijiang Chen
Тема Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
Дата
Msg-id CAAkGvS-Ck3NoMz0i7Y__+2u2LOZzZexznRiZYy1eKdrEW5qU6Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "ktm@rice.edu"
Дата:
Сообщение: Re: pg bouncer issue what does sv_used column means
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?