Re: postgres 9.0.4 configuration and performance issue

On 10/13/2013 1:45 PM, Sergey Konoplev wrote:

On Sun, Oct 13, 2013 at 8:35 AM, akp geek<akpgeek@gmail.com>  wrote:

>thanks for the advice. One question I have is if I increase the
>shared_buffers to 16GB, then it won't restart because for the 32 bit version
>of postgres , we can't have shared buffers more than 3.2 GB right ? ( this
>from various blogs that I have read )

Hm.. looks like I missed this fact. Is it possible to install the 64bit one?

indeed, I note the original post also states he has 64GB ram.  Its crazy to run a 32bit kernel even with PAE with that large of a physical memory.   the PAE page tables all have to fit in 1GB kernel address space, and 32bit style PAE page tables sufficient to utilize 64gb physical memory will about kill you.   Even without the PAE page table size issue, no process can see more than 3GB of this memory, making it quite hard to fully utilize the system.

updating this system to a 64bit kernel and 64bit postgres will result in much higher performance overall.   if the OP is in fact already running a 64bit kernel, he should upgrade postgres to 64bit.  note, this will require a dump/initdb/restore as they aren't binary compatible.

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general