From: Stephen Conley <cheetah@tanabi.org>
To: Uwe Bartels <uwe.bartels@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: requested shared memory size overflows size_t
Date: Tue, 15 Jul 2008 17:26:52 -0400
Message-ID: <8752fe670807151426s3cab7a9dt49b8e180295bbda3@mail.gmail.com> (raw)
In-Reply-To: <18881.1216131953@sss.pgh.pa.us>
References: <8ea917510807150326l29c4d7e3g722623d6a7bea8d@mail.gmail.com>
<18881.1216131953@sss.pgh.pa.us>
Hey there;
As Tom notes before maybe you're not using the right postgres. Solaris 10
comes with a postgres, but on SPARC it's 32 bit compiled (I can't speak to
x86 Solaris though).
Assuming that's not the problem, you can be 100% sure if your Postgres
binary is actually 64 bit by using the file command on the 'postgres'
executable. A sample from 64 bit SPARC looks like this:
postgres: ELF 64-bit MSB executable SPARCV9 Version 1, UltraSPARC3
Extensions Required, dynamically linked, not stripped
But x86 should show something similar. I have run Postgres up to about 8
gigs of RAM on Solaris without trouble. Anyway, sorry if this is obvious /
not helpful but good luck :)
Steve
On Tue, Jul 15, 2008 at 10:25 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Uwe Bartels" <uwe.bartels@gmail.com> writes:
> > When trying to to set shared_buffers greater then 3,5 GB on 32 GB x86
> > machine with solaris 10 I running in this error:
> > FATAL: requested shared memory size overflows size_t
>
> > The solaris x86 ist 64-bit and the compiled postgres is as well 64-bit.
>
> Either it's not really a 64-bit build, or you made an error in your
> math. What did you try to set shared_buffers to, exactly? Did you
> increase any other parameters at the same time?
>
> regards, tom lane
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
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: cheetah@tanabi.org, uwe.bartels@gmail.com
Subject: Re: requested shared memory size overflows size_t
In-Reply-To: <8752fe670807151426s3cab7a9dt49b8e180295bbda3@mail.gmail.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