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 <[email protected]> wrote: > From: Robert Haas <[email protected]> > Subject: Re: [PERFORM] requested shared memory size overflows size_t > To: "Bob Lunney" <[email protected]> > Cc: [email protected], "Tom Wilcox" <[email protected]> > Date: Wednesday, June 9, 2010, 9:49 PM > On Wed, Jun 2, 2010 at 9:26 PM, Bob > Lunney <[email protected]> > 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 > -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
