| 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
| 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 |