True, plus there are the other issues of increased checkpoint times and I/O, bgwriter tuning, etc. It may be better to
letthe OS cache the files and size shared_buffers to a smaller value.
Bob Lunney
--- On Wed, 6/9/10, Robert Haas <robertmhaas@gmail.com> wrote:
> From: Robert Haas <robertmhaas@gmail.com>
> Subject: Re: [PERFORM] requested shared memory size overflows size_t
> To: "Bob Lunney" <bob_lunney@yahoo.com>
> Cc: pgsql-performance@postgresql.org, "Tom Wilcox" <hungrytom@googlemail.com>
> Date: Wednesday, June 9, 2010, 9:49 PM
> On Wed, Jun 2, 2010 at 9:26 PM, Bob
> Lunney <bob_lunney@yahoo.com>
> wrote:
> > Your other option, of course, is a nice 64-bit linux
> variant, which won't have this problem at all.
>
> Although, even there, I think I've heard that after 10GB
> you don't get
> much benefit from raising it further. Not sure if
> that's accurate or
> not...
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise Postgres Company
>