Re: MySQL versus Postgres - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: MySQL versus Postgres
Date
Msg-id 20100813.090619.118535546.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: MySQL versus Postgres  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: MySQL versus Postgres
List pgsql-general
> 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

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: MySQL versus Postgres
Next
From: Greg Smith
Date:
Subject: Re: MySQL versus Postgres