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