pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: lists@event-s.net
To: brian@shoptoit.ca
To: pgsql-performance@postgresql.org
Subject: Re: shared_buffers > 284263 on OS X
Date: Sat, 18 Nov 2006 18:48:07 +0100
Message-ID: <1hp0hfj.1w6pgseogv3b4M%lists@event-s.net> (raw)
In-Reply-To: <B242A585-E94C-4ECA-8FA9-DCE72E1D8838@shoptoit.ca>

Brian Wipf <brian@shoptoit.ca> wrote:

> I'm trying to optimize a PostgreSQL 8.1.5 database running on an  
> Apple G5 Xserve (dual G5 2.3 GHz w/ 8GB of RAM), running Mac OS X  
> 10.4.8 Server.
> 
> The queries on the database are mostly reads, and I know a larger  
> shared memory allocation will help performance (also by comparing it
> to the performance of the same database running on a SUSE Linux box,
> which has a higher shared_buffers setting).
> 
> When I set shared_buffers above 284263 (~ 2.17 GB) in the  
> postgresql.conf file, I get the standard error message when trying to
> start the db:

It might be, that you hit an upper limit in Mac OS X:

[galadriel: memtext ] cug $ ./test
test(291) malloc: *** vm_allocate(size=2363490304) failed (error code=3)
test(291) malloc: *** error: can't allocate region
test(291) malloc: *** set a breakpoint in szone_error to debug
max alloc = 2253 M

That seems near the size you found to work. 

I don't really know much about that, but it seems you just can't alloc
more memory than a bit over 2GB. So, be careful with my non-existing
knowledge about that ... ;-)

cug



view thread (21+ messages)  latest in thread

Message-ID: <1hp0hfj.1w6pgseogv3b4M%lists@event-s.net>
Permalink:  ../1hp0hfj.1w6pgseogv3b4M%25lists@event-s.net/
Also on:    postgresql.org/message-id/1hp0hfj.1w6pgseogv3b4M%lists@event-s.net

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: lists@event-s.net, brian@shoptoit.ca
  Subject: Re: shared_buffers > 284263 on OS X
  In-Reply-To: <1hp0hfj.1w6pgseogv3b4M%lists@event-s.net>
  References: <B242A585-E94C-4ECA-8FA9-DCE72E1D8838@shoptoit.ca> <1hp0hfj.1w6pgseogv3b4M%lists@event-s.net>

* 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