> With modern servers often shipping with 72GB of RAM now, that would make
> shared_buffers set to 18GB. This is an absolutely disastrous setting
> for PostgreSQL in its current state; I'm seeing servers with that much
> RAM that suffer enormous problems with a far lower shared_buffers than
> that in production. I'm working on a doc patch to address this better
> before 9.0 goes out but I assure you this simple rule of thumb is
> already nearing its end of life as a good one for big systems.
What's the problem with 18GB shared_buffers exactly?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp