On Wed, Dec 05, 2007 at 02:27:05PM +0100, Benjamin Sobotta wrote:
> > Hello,
> > 
> > I'm to test PostgreSQL on a 7-BETA3. The box has 12GB of memory in it,
> > I've adjusted the sysctls, but postgresql always fails to allocate the
> > SHM if it's bigger then 2GB.
> > 
> > How can I make it to allocate more SHM than 2G at once?
> > 
> > sysctl.conf:
> > kern.ipc.shmall=1572864
> > kern.ipc.shmmax=6442450944
> > kern.ipc.semmap=1024
> > kern.ipc.shm_use_phys=1
> > 
> > /boot/loader.conf:
> > zfs_load="YES"
> > vm.kmem_size="1073741824"
> > vm.kmem_size_max="1073741824"
> > kern.ipc.semmni=1024
> > kern.ipc.semmns=2048
> > kern.ipc.semmnu=1024
> > 
> > I've also hit a similar issue with qemu, but that wasn't shared memory,
> > I had just tried to make it allocate more than 2GBs for a single vm, but
> > that also failed. Still haven't figured out why was that.
> > 
> > Sincerely,
> > 
> > Gergely Czuczy
> > mailto: [EMAIL PROTECTED]
> > 
> > -- 
> > Weenies test. Geniuses solve problems that arise.
> 
> Hi!
> 
> I'm not sure if this is helpful, as I dont run FBSD 7 as of yet. Further I'm 
> not very familiar with the topic. But I had a similiar problem with MySQL on 
> 6.2. What helped for me was play with 
> 
> kern.maxdsiz
> kern.dfldsiz
> kern.maxssiz
> 
> in loader.conf. 
Thanks. These sysctls seems no to be available on an amd64, but
I've seen similar ones under the ia32 layer:
compat.ia32.maxdsiz:
compat.ia32.maxssiz:

So, this wasn't the one...

Sincerely,

Gergely Czuczy
mailto: [EMAIL PROTECTED]

-- 
Weenies test. Geniuses solve problems that arise.

Attachment: pgp6RP5O0dAN3.pgp
Description: PGP signature

Reply via email to