Re: Problems with precompiled pgsql on mac

Peter Elmers <p.elmers@gmx.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