Re: Problems with precompiled pgsql on mac

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Elmers <p(dot)elmers(at)gmx(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Problems with precompiled pgsql on mac
Date: 2007-04-11 14:19:29
Message-ID: 14047.1176301169@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Peter Elmers <p(dot)elmers(at)gmx(dot)de> writes:
> Now i am ongoing to optimize the settings. Without changing the
> sysctl.conf or rc, i am able to get postgres running with the
> following settings:

> max_connections = 40
> shared_buffers=640kB

> Does anybody see any problems with theese settings?

Yeah, that's only 80 buffers, which is at least one order of magnitude
too low for reasonable performance, probably two orders. This would
do for a toy installation that wasn't working hard, but not for any
serious load.

Darwin's default SHMMAX is barely enough for one postmaster; you really
can't run two without fixing it.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sean Murphy 2007-04-11 16:25:53 Best compressed archive_command on Linux?
Previous Message Pankaj 2007-04-11 13:56:20 (pgsql-bugs) Ref. No: 3218: Problems in installing Postgresql on Windows