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 increased shared_memory to 50GB, and also set: Umm, do you have a specific reason for not allowing the OS to cache your DB? Is it actually a 64-bit machine you're running on? > kern.ipc.shm_use_phys=1 > kern.ipc.semmap=512 > kern.ipc.shmall=65536 > kern.ipc.shmmax=68719476736 That shmall limits you to at most 256MB, maybe you want to change that also? I'd suggest making shared buffers at most a few GB and use the rest for caching. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment:
signature.asc
Description: Digital signature
