Hello Bill,
I have this one set to 512 in loader.conf
other params in loader.conf:
kern.ipc.semmni=1024
kern.ipc.semmns=1024
kern.ipc.semmnu=512
Kind regards,
Christiaan Willemsen
Bill Moran wrote:
In response to Christiaan Willemsen [EMAIL PROTECTED]:
#sysctl -a | grep shm
).
Kind regards,
Christiaan Willemsen
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello Shane,
All settings are as expected by both sysctl.conf and loader.conf
Shane Ambler wrote:
Christiaan Willemsen wrote:
Bill Moran wrote:
In response to Christiaan Willemsen [EMAIL PROTECTED]:
#sysctl -a | grep shm
kern.ipc.shm_allow_removed: 0
kern.ipc.shm_use_phys: 1
I still would like to allocate a bit more than 1 Gb of shared_memory on
FreeBSD. So if anyone has any pointers what settings I do need to make,
please let me know.
Kind regards,
Christiaan Willemsen
Christiaan Willemsen wrote:
Yes, it is a 64 bit machine, I'm sure of that:
file ../bin
Yes, I did ;)
Isak Hansen wrote:
On Mon, Nov 17, 2008 at 12:03 PM, Isak Hansen [EMAIL PROTECTED] wrote:
On Mon, Nov 17, 2008 at 9:51 AM, Christiaan Willemsen
[EMAIL PROTECTED] wrote:
I still would like to allocate a bit more than 1 Gb of shared_memory on
FreeBSD. So if anyone has any
#sysctl -a | grep shm
kern.ipc.shm_allow_removed: 0
kern.ipc.shm_use_phys: 1
kern.ipc.shmall: 68719476736
kern.ipc.shmseg: 128
kern.ipc.shmmni: 192
kern.ipc.shmmin: 1
kern.ipc.shmmax: 68719476736
Isak Hansen wrote:
On Mon, Nov 17, 2008 at 12:11 PM, Christiaan Willemsen
[EMAIL PROTECTED] wrote
memory. In fact, it only starts if I set the
shared_buffers to as little as 32MB!! So there is clearly something
wrong here... I hope you can tell me what.
PostgresSQL version 8.3.5, compiled on a fresh install of FreeBSD 7 with
no special options.
Kind regards,
Christiaan Willemsen
--
Sent
,
Christiaan Willemsen
Martijn van Oosterhout wrote:
On Fri, Nov 14, 2008 at 01:56:31PM +0100, Christiaan Willemsen wrote:
I'm trying to get postgressql running on FreeBSD with 64 GB of memory.
Postgres will the the only thing running, so I want it to use as much
memory as needed.
So I