Re: requested shared memory size overflows size_t

True, plus there are the other issues of increased checkpoint times and I/O, bgwriter tuning, etc. It may be better to let the OS cache the files and size shared_buffers to a smaller value.

Bob Lunney

--- On Wed, 6/9/10, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> From: Robert Haas <robertmhaas(at)gmail(dot)com>
> Subject: Re: [PERFORM] requested shared memory size overflows size_t
> To: "Bob Lunney" <bob_lunney(at)yahoo(dot)com>
> Cc: pgsql-performance(at)postgresql(dot)org, "Tom Wilcox" <hungrytom(at)googlemail(dot)com>
> Date: Wednesday, June 9, 2010, 9:49 PM
> On Wed, Jun 2, 2010 at 9:26 PM, Bob
> Lunney <bob_lunney(at)yahoo(dot)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
>