pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bob Lunney <bob_lunney@yahoo.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-performance@postgresql.org, Tom Wilcox <hungrytom@googlemail.com>
Subject: Re: requested shared memory size overflows size_t
Date: Thu, 10 Jun 2010 07:41:15 -0700 (PDT)
Message-ID: <994489.22729.qm@web39706.mail.mud.yahoo.com> (raw)
In-Reply-To: <AANLkTin9D34AnGHhiyjUtpWV_B7IaSctHdeHfTpqiipF@mail.gmail.com>

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@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
> 


      



view thread (32+ messages)  latest in thread

Message-ID: <994489.22729.qm@web39706.mail.mud.yahoo.com>
Permalink:  ../994489.22729.qm@web39706.mail.mud.yahoo.com/
Also on:    postgresql.org/message-id/994489.22729.qm@web39706.mail.mud.yahoo.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: bob_lunney@yahoo.com, robertmhaas@gmail.com, hungrytom@googlemail.com
  Subject: Re: requested shared memory size overflows size_t
  In-Reply-To: <994489.22729.qm@web39706.mail.mud.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox