Re: [HACKERS] 64-bit pgsql

2003-09-12 Thread Bruce Momjian
You should find that the next daily snapshot and beta3 will properly detect Opteron/Itanium on your platform. I don't think we can help you with the compiler bugs, however. ;-) --- Jeroen Ruigrok/asmodai wrote: -On

Re: [HACKERS] 64-bit pgsql

2003-09-10 Thread Bruce Momjian
Jeroen Ruigrok/asmodai wrote: -On [20030905 20:52], Tom Lane ([EMAIL PROTECTED]) wrote: Alternatively, find out what symbols your compiler predeclares. If my theory is right then your pg_config_os.h file is failing to define HAS_TEST_AND_SET; why? Indeed, pg_config_os.h does not set

[HACKERS] 64-bit pgsql

2003-09-05 Thread Daniel
Hello, I'm a beginner here at the list, my name is Daniel Pellegrini, graduation student from Brazil with no experience about pgsql. First of all I'd like to say that I have tried other lists before, but I didn't get the answer, or the complete answer. I'm doing a research about DBMSs that run

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Rod Taylor
I'm doing a research about DBMSs that run on new PC 64-bit processors, like Intel Itanium and AMD Opteron. I'd like that you would help me in some questions. First, does pgsql support this architecture? According to Administrator's

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Jeroen Ruigrok/asmodai
-On [20030905 16:42], Rod Taylor ([EMAIL PROTECTED]) wrote: Download 7.4 beta 2 and run regression tests on those platforms. Report back any issues or successes. 7.4 Release candidates will come with a call for reports on platforms that pass the regression tests which are used to make up the

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Jeroen Ruigrok/asmodai
-On [20030905 17:22], Jeroen Ruigrok/asmodai ([EMAIL PROTECTED]) wrote: Well, on Itanium2 on FreeBSD 5.1 it compiles. I just need to get the semaphores to a higher value in order to actually do an initdb. Though, did 7.4 raise the bar on SysV IPC? On my other two boxes I haven't tweaked SysV

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Rod Taylor
On Fri, 2003-09-05 at 11:29, Jeroen Ruigrok/asmodai wrote: -On [20030905 17:22], Jeroen Ruigrok/asmodai ([EMAIL PROTECTED]) wrote: Well, on Itanium2 on FreeBSD 5.1 it compiles. I just need to get the semaphores to a higher value in order to actually do an initdb. Though, did 7.4 raise

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Tom Lane
Rod Taylor [EMAIL PROTECTED] writes: did 7.4 raise the bar on SysV IPC? On my other two boxes I haven't tweaked SysV IPC at all (semmni is at 10) and I get initdb. Is this beta 1 or beta 2? Beta 1 has a bug which may require more shared resources than what is available. Actually the bug is

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Jeroen Ruigrok/asmodai
-On [20030905 17:42], Rod Taylor ([EMAIL PROTECTED]) wrote: Is this beta 1 or beta 2? Beta 1 has a bug which may require more shared resources than what is available. Sorry, beta 2. Should've made that clear. -- Jeroen Ruigrok van der Werven asmodai(at)wxs.nl / asmodai PGP fingerprint: 2D92

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Jeroen Ruigrok/asmodai
-On [20030905 17:52], Tom Lane ([EMAIL PROTECTED]) wrote: Actually the bug is in beta2, not beta1. I'd suggest grabbing the current nightly snapshot (see /dev on the ftp servers) in preference to beta2, if you are on a machine with small SysV IPC limits. Using a snapshot of September the 4th:

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Tom Lane
Jeroen Ruigrok/asmodai [EMAIL PROTECTED] writes: Using a snapshot of September the 4th: creating template1 database in /p/scratch/asmodai/postgresql-snapshot/src/test/r egress/./tmp_check/data/base/1... FATAL: could not create semaphores: No space left on device DETAIL: Failed syscall was

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Jeroen Ruigrok/asmodai
-On [20030905 18:32], Tom Lane ([EMAIL PROTECTED]) wrote: If it dies even at max_connections 10, that is a *lower* setting than we ever supported before (the pre-7.4 default was 32, and you need 20 or more to run the parallel regression test). I suspect that you actually don't have SysV

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Tom Lane
Jeroen Ruigrok/asmodai [EMAIL PROTECTED] writes: So it does seem 7.4 places higher demand than 7.3.4 on the SysV IPC, It should not; there is something wrong here, not merely a documentation problem. I am wondering whether your 7.4 build fails to select a TAS() implementation --- if so, it

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Jeroen Ruigrok/asmodai
-On [20030905 20:52], Tom Lane ([EMAIL PROTECTED]) wrote: Alternatively, find out what symbols your compiler predeclares. If my theory is right then your pg_config_os.h file is failing to define HAS_TEST_AND_SET; why? Indeed, pg_config_os.h does not set anything for __ia64__. When I added

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Jeroen Ruigrok/asmodai
-On [20030905 19:12], Tom Lane ([EMAIL PROTECTED]) wrote: It should not; there is something wrong here, not merely a documentation problem. I am wondering whether your 7.4 build fails to select a TAS() implementation --- if so, it would fall back to implementing spinlocks as semaphores, which

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Tom Lane
Jeroen Ruigrok/asmodai [EMAIL PROTECTED] writes: So I guess the problem lies in the Itanium port. Or could I miss something subtle here? This strengthens my suspicion that we're not finding TAS code for the Itanium, but please see if you can strace or ktrace the postmaster to verify how many

Re: [HACKERS] 64-bit pgsql

2003-09-05 Thread Bruce Momjian
Tom Lane wrote: Jeroen Ruigrok/asmodai [EMAIL PROTECTED] writes: So I guess the problem lies in the Itanium port. Or could I miss something subtle here? This strengthens my suspicion that we're not finding TAS code for the Itanium, but please see if you can strace or ktrace the