Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 11 Oct 2001 18:24:23 +0900 (JST)
From:      "Daniel O'Connor" <doconnor@gsoft.com.au>
To:        Marcel Prisi <marcel-lists@virtua.ch>
Cc:        freebsd-stable@FreeBSD.ORG, freebsd-isp@FreeBSD.ORG
Subject:   RE: PostgreSQL & shared memory
Message-ID:  <XFMail.20011011182423.doconnor@gsoft.com.au>
In-Reply-To: <006001c1516b$db2637b0$8d01a8c0@gastroleader.com>

next in thread | previous in thread | raw e-mail | index | archive | help

On 10-Oct-2001 Marcel Prisi wrote:
>  about 400-500 connections to PostgreSQL ? What about shared memory & FreeBSD
>  kernel ?

You can tune the shared memory/semaphore options in PGSQL using sysctl which
may help you a bit.. ie ->
[chowder 18:20] ~ > sysctl -a | grep shm
kern.ipc.shmmax: 33554432
kern.ipc.shmmin: 1
kern.ipc.shmmni: 192
kern.ipc.shmseg: 128
kern.ipc.shmall: 8192
kern.ipc.shm_use_phys: 0

Also, man 7 tuning :)

---
Daniel O'Connor software and network engineer
for Genesis Software - http://www.gsoft.com.au
"The nice thing about standards is that there
are so many of them to choose from."
  -- Andrew Tanenbaum

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-isp" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?XFMail.20011011182423.doconnor>