Re: requested shared memory size overflows size_t

Robert,
Please advise me: I just downloaded the source and compiled it. Sun Spark Solaris 9 is always 64 bit, I verified it
withsys admin. He may run 32 bit applications as well. Have I use some special option during compilation to verify that
compiledPostgreSQL is actually 64 bit app? 

Sincerely yours,


Yuri Levinsky, DBA
Celltick Technologies Ltd., 32 Maskit St., Herzliya 46733, Israel
Mobile: +972 54 6107703, Office: +972 9 9710239; Fax: +972 9 9710222


-----Original Message-----
From: Robert Haas [mailto:robertmhaas@gmail.com]
Sent: Tuesday, March 04, 2014 4:31 PM
To: Yuri Levinsky
Cc: Heikki Linnakangas; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] requested shared memory size overflows size_t

On Tue, Mar 4, 2014 at 6:05 AM, Yuri Levinsky <yuril@celltick.com> wrote:
> I changed postgresql.conf to decrease those parameters but no change:
> GMT54000FATAL:  requested shared memory size overflows size_t

I think this means you are running on a 32-bit operating system, or at least on a 32-bit build.  That means you can't
usemore than 4GB of address space per process, which has to fit shared_buffers and everything else.  Typically it's
bestnot to set shared_buffers above 2-2.5GB on such systems, but the real solution is to use a 64-bit PostgreSQL. 

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company