Postgres Pro
Downloads
Home   >   mailing lists

Re: requested shared memory size overflows size_t - Mailing list pgsql-performance

From Robert Haas
Subject Re: requested shared memory size overflows size_t
Date
Msg-id AANLkTin9D34AnGHhiyjUtpWV_B7IaSctHdeHfTpqiipF@mail.gmail.com
Whole thread Raw
In response to Re: requested shared memory size overflows size_t  (Bob Lunney <bob_lunney@yahoo.com>)
Responses Re: requested shared memory size overflows size_t  (Bob Lunney <bob_lunney@yahoo.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: No hash join across partitioned tables?
Next
From: Robert Haas
Date:
Subject: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?