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@xxxxxxxxx> wrote: > From: Robert Haas <robertmhaas@xxxxxxxxx> > Subject: Re: requested shared memory size overflows size_t > To: "Bob Lunney" <bob_lunney@xxxxxxxxx> > Cc: pgsql-performance@xxxxxxxxxxxxxx, "Tom Wilcox" <hungrytom@xxxxxxxxxxxxxx> > Date: Wednesday, June 9, 2010, 9:49 PM > On Wed, Jun 2, 2010 at 9:26 PM, Bob > Lunney <bob_lunney@xxxxxxxxx> > 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
