Re: PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory
Hell, Robert wrote: I just found a bug report for that issue: http://www.freebsd.org/cgi/query-pr.cgi?pr=121423cat= Try asking on current@ - I think there were some patches available some time ago. -Original Message- From: Wojciech Puchar [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 10. Dezember 2008 18:30 To: Hell, Robert Cc: freebsd-questions@freebsd.org Subject: Re: PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory fails again with ENOMEM. Is there any easy way to use a shared memory segment which is larger than 2GB? getting two smaller ? :) no idea - maybe it's bug of SHM. as you already checked it please do sent-pr ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] signature.asc Description: OpenPGP digital signature
PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory
Hi, I'm trying to run PostgreSQL 8.3 on a FreeBSD 7.0 amd64 server with more than 2GB shared memory. The machine has 32GB RAM installed. After setting kern.ipc.shmmax and kern.ipc.shmall to the appropriate values, I still had no chance to start postgres with more than 2GB of shared memory. I wrote a small test which does the same as postgres: shmget and shmat: #include sys/ipc.h #include sys/shm.h #include stdio.h #include errno.h int main() { int shmid, memKey = 1; void *memAddress; unsigned long size = 2147483648UL; shmid = shmget(memKey, size, IPC_CREAT | IPC_EXCL); if (shmid 0) { printf(shmget failed: %d\n, errno); return 1; } memAddress = shmat(shmid, NULL, 0); if (memAddress == (void *) -1) { printf(shmat failed: %d\n, errno); } return 0; } I found out that shmget failed with ENOMEM in shmget_allocate_segment (sysv_shm.c) because of an overflow of size (requested shared memory in bytes): int i, segnum, shmid, size; ... size = round_page(uap-size); if (shm_committed + btoc(size) shminfo.shmall) { return (ENOMEM); } When changing size to an unsigned long shmget works - but now shmat then fails again with ENOMEM. Is there any easy way to use a shared memory segment which is larger than 2GB? Kind regards, Robert ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory
fails again with ENOMEM. Is there any easy way to use a shared memory segment which is larger than 2GB? getting two smaller ? :) no idea - maybe it's bug of SHM. as you already checked it please do sent-pr ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
RE: PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory
I just found a bug report for that issue: http://www.freebsd.org/cgi/query-pr.cgi?pr=121423cat= Thanks, Robert -Original Message- From: Wojciech Puchar [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 10. Dezember 2008 18:30 To: Hell, Robert Cc: freebsd-questions@freebsd.org Subject: Re: PostgreSQL on FreeBSD 7.0 amd64 with more than 2GB shared memory fails again with ENOMEM. Is there any easy way to use a shared memory segment which is larger than 2GB? getting two smaller ? :) no idea - maybe it's bug of SHM. as you already checked it please do sent-pr ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: more than 2gb of memory
with ulimit on i386 - i don't know if 2 or 3GB is a limit. on amd64 - essentially no limit On Thu, 3 Apr 2008, Victor M. Blood wrote: Hi, All. How to allow ussage more than 2gb of memory on freebsd per process? -- With all regards, Victor M. Blood. mailto: [EMAIL PROTECTED] FTN: 2:5024/[EMAIL PROTECTED], ICQ#3567656 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: more than 2gb of memory
On 03.04.2008, Wojciech Puchar wrote: with ulimit on i386 - i don't know if 2 or 3GB is a limit. on amd64 - essentially no limit ussage of amd is impossible, current machine is Intel Xeon. -- With all regards, Victor M. Blood. mailto: [EMAIL PROTECTED] FTN: 2:5024/[EMAIL PROTECTED], ICQ#3567656 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: more than 2gb of memory
On Thu, Apr 03, 2008 at 09:29:33AM CEST, Victor M. Blood [EMAIL PROTECTED] said: On 03.04.2008, Wojciech Puchar wrote: with ulimit on i386 - i don't know if 2 or 3GB is a limit. on amd64 - essentially no limit ussage of amd is impossible, current machine is Intel Xeon. Intel 64 bit processors of the pentium family (ie EMT 64) are compatible with amd64 arch. -- Erwan ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: more than 2gb of memory
On Thu, Apr 03, 2008 at 09:36:11AM CEST, Erwan David [EMAIL PROTECTED] said: On Thu, Apr 03, 2008 at 09:29:33AM CEST, Victor M. Blood [EMAIL PROTECTED] said: On 03.04.2008, Wojciech Puchar wrote: with ulimit on i386 - i don't know if 2 or 3GB is a limit. on amd64 - essentially no limit ussage of amd is impossible, current machine is Intel Xeon. Intel 64 bit processors of the pentium family (ie EMT 64) are compatible with amd64 arch. Here is what I use : from dmesg.boot CPU: Genuine Intel(R) CPU2160 @ 1.80GHz (1795.57-MHz K8-class CPU) Origin = GenuineIntel Id = 0x6f2 Stepping = 2 Features=0xbfebfbffFPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE Features2=0xe39dSSE3,RSVD2,MON,DS_CPL,EST,TM2,SSSE3,CX16,xTPR,PDCM AMD Features=0x20100800SYSCALL,NX,LM AMD Features2=0x1LAHF Cores per package: 2 uname -m amd64 -- Erwan ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: more than 2gb of memory
On Thursday 03 April 2008, Victor M. Blood wrote: On 03.04.2008, Wojciech Puchar wrote: with ulimit on i386 - i don't know if 2 or 3GB is a limit. on amd64 - essentially no limit ussage of amd is impossible, current machine is Intel Xeon. Depending on the type of Xeon, the use of amd64 _is_ possible. Does it support EMT64? If that is the case, it should have a line saying AMD Features = bla,LM,bla in your dmesg which means the use of FreeBSD-amd64 is supported. -- Pieter de Goeje ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: more than 2gb of memory
On 03.04.2008, Pieter de Goeje wrote: On Thursday 03 April 2008, Victor M. Blood wrote: On 03.04.2008, Wojciech Puchar wrote: with ulimit on i386 - i don't know if 2 or 3GB is a limit. on amd64 - essentially no limit ussage of amd is impossible, current machine is Intel Xeon. Depending on the type of Xeon, the use of amd64 _is_ possible. Does it support EMT64? If that is the case, it should have a line saying AMD Features = bla,LM,bla in your dmesg which means the use of FreeBSD-amd64 is supported. Hm, greater fanks! I'm do not known about this! -- With all regards, Victor M. Blood. mailto: [EMAIL PROTECTED] FTN: 2:5024/[EMAIL PROTECTED], ICQ#3567656 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
more than 2gb of memory
Hi, All. How to allow ussage more than 2gb of memory on freebsd per process? -- With all regards, Victor M. Blood. mailto: [EMAIL PROTECTED] FTN: 2:5024/[EMAIL PROTECTED], ICQ#3567656 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]