Thread: Call for platform testing
I have not recorded successful tests for the following platforms (I've included the names of folks who reported for the last release, in case they are still able to test or want to hand it off to someone else): AIX Gilles Darold BeOS Cyril Velter HPUX (have 10.20 from Tom; anyone tested 11.0 or higher?) IRIX Robert Bruccoleri Linux/arm Mark Knox Linux/s390 Neale Ferguson Linux/sparc Ryan Kirkpatrick NetBSD/arm32 Patrick Welche NetBSD/m68k Henry Hotz (not tested since 7.0; obsolete platform?) NetBSD/PPC Henry Hotz NetBSD/VAX Tom I. Helbekkmo NetBSD/x86 Giles Lean QNX (did I get a definitive report for 4.x already?) SCO Unixware Larry Rosenman Solaris/x86 Mathijs Brands SunOS Tatsuo Ishii (old release; still relevant?) Windows/Cygwin Jason Tishler Windows/native Magnus Hagander (clients only) The following platforms have been reported as successfully running PostgreSQL 7.2: BSD/OS Bruce FreeBSD Chris Kings-Lynne Linux/Alpha Tom Linux/MIPS Hisao Shibuya Linux/PPC Tom Linux/x86 Thomas (and many others ;) MacOS-X Tom NetBSD/Alpha Thomas Thai OpenBSD/sparc Brandon Palmer OpenBSD/x86 Brandon Palmer Solaris/sparc Andrew Sullivan Tru64 Alessio Bragadini (anyone tested 5.0 or higher?) Have I missed any success reports? Have I left out any platforms known to be good or bad (or which *should* be reported)? Sorry if I've missed anything; over time there is a lot flying around for which I'm not sure the result (AIX and QNX come to mind for examples). - Thomas
> Have I missed any success reports? Have I left out any platforms known > to be good or bad (or which *should* be reported)? Sorry if I've missed > anything; over time there is a lot flying around for which I'm not sure > the result (AIX and QNX come to mind for examples). QNX6 will fail in 7.2.X. We have patches for 7.3. I believe AIX is fine thanks to work done a few weeks ago by Tatuso and others. However, I am not totally sure. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
> QNX6 will fail in 7.2.X. We have patches for 7.3. I believe AIX is > fine thanks to work done a few weeks ago by Tatuso and others. However, > I am not totally sure. I have been troubled by 7.2b3/AIX 5L combo. The parallel regression test hangs in the middle of the test. It seems backend goes into an idle state and it happens nothing after that. I have been on a business trip till this week end. I will start to dig into more next week. -- Tatsuo Ishii
> QNX6 will fail in 7.2.X. We have patches for 7.3. I believe AIX is > fine thanks to work done a few weeks ago by Tatuso and others. However, > I am not totally sure. 7.2b3 passes "make check" on AIX 4.3 with both xlc and gcc. 1 Rounding difference (last digit) and 3 0 vs -0 in the geometry tests when using gcc (both gcc and xlc show -0s, only different ones). The PG_FUNCTION_INFO_V1 macro produces an annoying warning, that I cannot interpret: xlc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -DREFINT_VERBOSE -I. -I../../src/include -I/us r/local/include -c -o autoinc.o autoinc.c 8 | extern Pg_finfo_record * pg_finfo_autoinc (void); Pg_finfo_record * pg_finfo_a utoinc (void) { static Pg_finfo_record my_finfo = { 1 }; return &my_finfo; }; ........................................................................ ...... ........................................................................ ....a a - 1506-137 (E) Declaration must declare at least one declarator, tag, or the members of an enumeration. Andreas
I've upgraded to OpenUNIX 8, and all is well. It probably passes on UW 7 as well, but I can no longer test it. LER * Thomas Lockhart <lockhart@fourpalms.org> [011127 23:06]: > I have not recorded successful tests for the following platforms (I've > included the names of folks who reported for the last release, in case > they are still able to test or want to hand it off to someone else): > > AIX Gilles Darold > BeOS Cyril Velter > HPUX (have 10.20 from Tom; anyone tested 11.0 or higher?) > IRIX Robert Bruccoleri > Linux/arm Mark Knox > Linux/s390 Neale Ferguson > Linux/sparc Ryan Kirkpatrick > NetBSD/arm32 Patrick Welche > NetBSD/m68k Henry Hotz (not tested since 7.0; obsolete platform?) > NetBSD/PPC Henry Hotz > NetBSD/VAX Tom I. Helbekkmo > NetBSD/x86 Giles Lean > QNX (did I get a definitive report for 4.x already?) > SCO Unixware Larry Rosenman > Solaris/x86 Mathijs Brands > SunOS Tatsuo Ishii (old release; still relevant?) > Windows/Cygwin Jason Tishler > Windows/native Magnus Hagander (clients only) > > > The following platforms have been reported as successfully running > PostgreSQL 7.2: > > BSD/OS Bruce > FreeBSD Chris Kings-Lynne > Linux/Alpha Tom > Linux/MIPS Hisao Shibuya > Linux/PPC Tom > Linux/x86 Thomas (and many others ;) > MacOS-X Tom > NetBSD/Alpha Thomas Thai > OpenBSD/sparc Brandon Palmer > OpenBSD/x86 Brandon Palmer > Solaris/sparc Andrew Sullivan > Tru64 Alessio Bragadini (anyone tested 5.0 or higher?) > > > Have I missed any success reports? Have I left out any platforms known > to be good or bad (or which *should* be reported)? Sorry if I've missed > anything; over time there is a lot flying around for which I'm not sure > the result (AIX and QNX come to mind for examples). > > - Thomas > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
> I've upgraded to OpenUNIX 8, and all is well. > It probably passes on UW 7 as well, but I can no longer test it. I'm not familiar with SCO products. Is OU 8 the successor to UW 7, or is it a different product line? Do I need two entries in the list? I'm still not clear on the differences between that and OpenServer 5 (other than version of course) and whether that should (still) be listed as "untested and possibly unsupported". Hmm. Looking at Caldera's web site, it lists all three as separate products :( If these product lines are feature-compatible, could we just list "SCO" as supported, and in the comments mention "tested on OpenUnix 8"? Anyone else running other variants of SCO? - Thomas
> 7.2b3 passes "make check" on AIX 4.3 with both xlc and gcc. > 1 Rounding difference (last digit) and 3 0 vs -0 in the geometry tests > when using gcc (both gcc and xlc show -0s, only different ones). Thanks Andreas. Tatsuo is continuing testing on AIX 5.x, so I'll continue to list 4.3 as supported for now. - Thomas
> MacOS 10.1.1 passes. Thanks Gavin! - Thomas > ====================== > All 79 tests passed. > ====================== > > [localhost:~/postgresql-7.2b3] swm% uname -a > Darwin localhost 5.1 Darwin Kernel Version 5.1: Tue Oct 30 00:06:34 PST > 2001; root:xnu/xnu-201.5.obj~1/RELEASE_PPC Power Macintosh powerpc
* Thomas Lockhart <lockhart@fourpalms.org> [011128 08:28]: > > I've upgraded to OpenUNIX 8, and all is well. > > It probably passes on UW 7 as well, but I can no longer test it. > > I'm not familiar with SCO products. Is OU 8 the successor to UW 7, or is > it a different product line? Do I need two entries in the list? I'm > still not clear on the differences between that and OpenServer 5 (other > than version of course) and whether that should (still) be listed as > "untested and possibly unsupported". OU8 is UW 7 + LKP (Linux Kernel Personality) + Bug Fixes. OSR5 is the old Sco 3.2 stuff, and is a totally different beast/codeset. > > Hmm. Looking at Caldera's web site, it lists all three as separate > products :( > > If these product lines are feature-compatible, could we just list "SCO" > as supported, and in the comments mention "tested on OpenUnix 8"? I would POSSIBLY combine OU8 and UW7, but NOT OSR5. > > Anyone else running other variants of SCO? > > - Thomas -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
On Wed, Nov 28, 2001 at 05:01:08AM +0000, Thomas Lockhart allegedly wrote: > Solaris/x86 Mathijs Brands Unfortunately I don't have a Solaris/x86 development box anymore :( Cheers, Mathijs
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes: > The PG_FUNCTION_INFO_V1 macro produces an annoying warning, that I > cannot interpret: > xlc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -DREFINT_VERBOSE -I. > -I../../src/include -I/usr/local/include -c -o autoinc.o autoinc.c > 8 | extern Pg_finfo_record * pg_finfo_autoinc (void); > Pg_finfo_record * pg_finfo_a > utoinc (void) { static Pg_finfo_record my_finfo = { 1 }; return > &my_finfo; }; > ........................................................................ > ...... > ........................................................................ > ....a > a - 1506-137 (E) Declaration must declare at least one declarator, tag, > or the members of > an enumeration. It's not so much the macro as the semicolon after it. I get "Empty declaration" warnings from HP's cc for those lines myself. Kind of annoying, but not writing the semicolon in the source sounds uglier. Is it worth adding a dummy declaration to the macro just to shut up these compilers? We could probably make the macro produce bogus extern declarations, say PG_FUNCTION_INFO_V1(foo) produces extern Pg_finfo_record * pg_finfo_foo (void); Pg_finfo_record * pg_finfo_foo (void) { static Pg_finfo_record my_finfo = { 1 }; return &my_finfo; } extern int pg_finfo_foo_dummy which would satisfy even the most pedantic compiler ... unless it chose to warn about unreferenced extern declarations, but I don't think any do. regards, tom lane
> OU8 is UW 7 + LKP (Linux Kernel Personality) + Bug Fixes. OK, I'll just do one entry for both UW and OU. Love those name changes :( > OSR5 is the old Sco 3.2 stuff, and is a totally different > beast/codeset. Maybe I'll just remove mention of it altogether. Either it is supportable because it is Unix-y and somewhat compatible with other SCO products, or it isn't, but it isn't worth guessing at either way unless someone can test it. - Thomas
> Windows/Cygwin Jason Tishler Only the "privileges" test failed when running "serial_schedule". When running "parallel_schedule" there are random failures with errors "cannot access some file with a table/index/...". So I think that PostgreSQL is OK, but the Cygwin/Windows layer is not. We should try to find what's wrong when multiple backends are running. system: CYGWIN_NT-5.0 CERT 1.3.5(0.47/3/2) 2001-11-13 23:16 i686 unknown with cygipc 1.11 Dan
> Regression test on Irix 6.5.13 installed with MIPSPro 7.30 =======================2 of 79 tests failed. ======================= geometry and join *** ./expected/geometry-irix.out Wed Oct 11 06:55:58 2000 --- ./results/geometry.out Wed Nov 28 17:55:25 2001 *************** *** 127,133 **** | (-5,-12) | [(10,-10),(-3,-4)] | (-1.60487804878049,-4.64390243902439) | (10,10) | [(10,-10),(-3,-4)] | (2.39024390243902,-6.48780487804878) | (0,0) | [(-1000000,200),(300000,-40)]| (0.0028402365895872,15.384614860264) ! | (-10,0) | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140473) | (-3,4) | [(-1000000,200),(300000,-40)]| (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-1000000,200),(300000,-40)]| (5.09647083221496,15.3836744976925) | (-5,-12) | [(-1000000,200),(300000,-40)] |(-4.99494420845634,15.3855375281616) --- 127,133 ---- | (-5,-12) | [(10,-10),(-3,-4)] | (-1.60487804878049,-4.64390243902439) | (10,10) | [(10,-10),(-3,-4)] | (2.39024390243902,-6.48780487804878) | (0,0) | [(-1000000,200),(300000,-40)]| (0.0028402365895872,15.384614860264) ! | (-10,0) | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140472) | (-3,4) | [(-1000000,200),(300000,-40)]| (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-1000000,200),(300000,-40)]| (5.09647083221496,15.3836744976925) | (-5,-12) | [(-1000000,200),(300000,-40)] |(-4.99494420845634,15.3855375281616) *************** *** 443,452 **** FROM CIRCLE_TBL; six | polygon -----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ! | ((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138139,-1.49999999995138)) | ((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983794)) | ((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028)) ! | ((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138139,0.500000000048617)) | ((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162)) | ((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983794)) (6rows) --- 443,452 ---- FROM CIRCLE_TBL; six | polygon -----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ! | ((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138)) | ((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983794)) | ((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028)) ! | ((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617)) | ((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162)) | ((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983794)) (6rows) *************** *** 459,465 **** | ((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175)) | ((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.7106781191961,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917)) | ((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586)) ! | ((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586708),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752)) | ((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261)) | ((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917)) (6rows) --- 459,465 ---- | ((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175)) | ((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.7106781191961,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917)) | ((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586)) ! | ((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752)) | ((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261)) | ((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917)) (6rows) ====================================================================== *** ./expected/join.out Thu Dec 14 23:30:45 2000 --- ./results/join.out Wed Nov 28 17:57:11 2001 *************** *** 1731,1738 **** | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | - | | | null | | | 0 | zero | (13 rows) SELECT '' AS "xxx", * --- 1731,1738 ---- | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | + | | | null | (13 rows) SELECT '' AS "xxx", * *************** *** 1750,1757 **** | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | - | | | null | | | 0 | zero | (13 rows) SELECT '' AS "xxx", * --- 1750,1757 ---- | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | + | | | null | (13 rows) SELECT '' AS "xxx", * *************** *** 1799,1806 **** | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | - | | | null | | | 0 | zero | | | | | | | | | 0 (15 rows) --- 1799,1806 ---- | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | + | | | null | | | | | | | | | 0 (15 rows) *************** *** 1820,1827 **** | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | - | | | null | | | 0 | zero | | | | | | | | | 0 (15 rows) --- 1820,1827 ---- | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | + | | | null | | | | | | | | | 0 (15 rows) ======================================================================
regression test on irix 6.5.12 with MIPSpro Compilers: Version 7.3.1.2m (this platform is 8-r10000 ip25 processors, previous is 8 -r12000 ip35 processors) ======================= 2 of 79 tests failed. ======================= again join and geometry(it also failed in postgres 7.1.3) *** ./expected/geometry-irix.out Wed Oct 11 06:55:58 2000 --- ./results/geometry.out Wed Nov 28 17:55:25 2001 *************** *** 127,133 **** | (-5,-12) | [(10,-10),(-3,-4)] | (-1.60487804878049,-4.64390243902439) | (10,10) | [(10,-10),(-3,-4)] | (2.39024390243902,-6.48780487804878) | (0,0) | [(-1000000,200),(300000,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0) | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140473) | (-3,4) | [(-1000000,200),(300000,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-1000000,200),(300000,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-1000000,200),(300000,-40)] | (-4.99494420845634,15.3855375281616) --- 127,133 ---- | (-5,-12) | [(10,-10),(-3,-4)] | (-1.60487804878049,-4.64390243902439) | (10,10) | [(10,-10),(-3,-4)] | (2.39024390243902,-6.48780487804878) | (0,0) | [(-1000000,200),(300000,-40)] | (0.0028402365895872,15.384614860264) ! | (-10,0) | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140472) | (-3,4) | [(-1000000,200),(300000,-40)] | (-2.99789812267519,15.3851688427303) | (5.1,34.5) | [(-1000000,200),(300000,-40)] | (5.09647083221496,15.3836744976925) | (-5,-12) | [(-1000000,200),(300000,-40)] | (-4.99494420845634,15.3855375281616) *************** *** 443,452 **** FROM CIRCLE_TBL; six | polygon -----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ! | ((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138139,-1.49999999995138)) | ((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983794)) | ((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028)) ! | ((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138139,0.500000000048617)) | ((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162)) | ((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983794)) (6 rows) --- 443,452 ---- FROM CIRCLE_TBL; six | polygon -----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ! | ((-3,0),(-2.59807621135076,1.50000000000442),(-1.49999999999116,2.59807621135842),(1.53102359017709e-11,3),(1.50000000001768,2.59807621134311),(2.59807621136607,1.4999999999779),(3,-3.06204718035418e-11),(2.59807621133545,-1.50000000003094),(1.49999999996464,-2.59807621137373),(-4.59307077053127e-11,-3),(-1.5000000000442,-2.5980762113278),(-2.59807621138138,-1.49999999995138)) | ((-99,2),(-85.6025403783588,52.0000000001473),(-48.9999999997054,88.602540378614),(1.00000000051034,102),(51.0000000005893,88.6025403781036),(87.6025403788692,51.9999999992634),(101,1.99999999897932),(87.6025403778485,-48.0000000010313),(50.9999999988214,-84.6025403791243),(0.999999998468976,-98),(-49.0000000014732,-84.6025403775933),(-85.6025403793795,-47.9999999983794)) | ((-4,3),(-3.33012701891794,5.50000000000737),(-1.49999999998527,7.3301270189307),(1.00000000002552,8),(3.50000000002946,7.33012701890518),(5.33012701894346,5.49999999996317),(6,2.99999999994897),(5.33012701889242,0.499999999948437),(3.49999999994107,-1.33012701895622),(0.999999999923449,-2),(-1.50000000007366,-1.33012701887967),(-3.33012701896897,0.500000000081028)) ! | ((-2,2),(-1.59807621135076,3.50000000000442),(-0.499999999991161,4.59807621135842),(1.00000000001531,5),(2.50000000001768,4.59807621134311),(3.59807621136607,3.4999999999779),(4,1.99999999996938),(3.59807621133545,0.499999999969062),(2.49999999996464,-0.59807621137373),(0.999999999954069,-1),(-0.500000000044197,-0.598076211327799),(-1.59807621138138,0.500000000048617)) | ((90,200),(91.3397459621641,205.000000000015),(95.0000000000295,208.660254037861),(100.000000000051,210),(105.000000000059,208.66025403781),(108.660254037887,204.999999999926),(110,199.999999999898),(108.660254037785,194.999999999897),(104.999999999882,191.339745962088),(99.9999999998469,190),(94.9999999998527,191.339745962241),(91.3397459620621,195.000000000162)) | ((0,0),(13.3974596216412,50.0000000001473),(50.0000000002946,86.602540378614),(100.00000000051,100),(150.000000000589,86.6025403781036),(186.602540378869,49.9999999992634),(200,-1.02068239345139e-09),(186.602540377848,-50.0000000010313),(149.999999998821,-86.6025403791243),(99.999999998469,-100),(49.9999999985268,-86.6025403775933),(13.3974596206205,-49.9999999983794)) (6 rows) *************** *** 459,465 **** | ((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175)) | ((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.7106781191961,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917)) | ((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586)) ! | ((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586708),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752)) | ((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261)) | ((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917)) (6 rows) --- 459,465 ---- | ((-3,0),(-2.12132034355423,2.12132034356506),(1.53102359017709e-11,3),(2.12132034357588,2.1213203435434),(3,-3.06204718035418e-11),(2.12132034353258,-2.12132034358671),(-4.59307077053127e-11,-3),(-2.12132034359753,-2.12132034352175)) | ((-99,2),(-69.7106781184743,72.7106781188352),(1.00000000051034,102),(71.7106781191961,72.7106781181135),(101,1.99999999897932),(71.7106781177526,-68.7106781195569),(0.999999998468976,-98),(-69.7106781199178,-68.7106781173917)) | ((-4,3),(-2.53553390592372,6.53553390594176),(1.00000000002552,8),(4.5355339059598,6.53553390590567),(6,2.99999999994897),(4.53553390588763,-0.535533905977846),(0.999999999923449,-2),(-2.53553390599589,-0.535533905869586)) ! | ((-2,2),(-1.12132034355423,4.12132034356506),(1.00000000001531,5),(3.12132034357588,4.1213203435434),(4,1.99999999996938),(3.12132034353258,-0.121320343586707),(0.999999999954069,-1),(-1.12132034359753,-0.121320343521752)) | ((90,200),(92.9289321881526,207.071067811884),(100.000000000051,210),(107.07106781192,207.071067811811),(110,199.999999999898),(107.071067811775,192.928932188044),(99.9999999998469,190),(92.9289321880082,192.928932188261)) | ((0,0),(29.2893218815257,70.7106781188352),(100.00000000051,100),(170.710678119196,70.7106781181135),(200,-1.02068239345139e-09),(170.710678117753,-70.7106781195569),(99.999999998469,-100),(29.2893218800822,-70.7106781173917)) (6 rows) ====================================================================== *** ./expected/join.out Thu Dec 14 23:30:45 2000 --- ./results/join.out Wed Nov 28 17:57:11 2001 *************** *** 1731,1738 **** | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | - | | | null | | | 0 | zero | (13 rows) SELECT '' AS "xxx", * --- 1731,1738 ---- | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | + | | | null | (13 rows) SELECT '' AS "xxx", * *************** *** 1750,1757 **** | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | - | | | null | | | 0 | zero | (13 rows) SELECT '' AS "xxx", * --- 1750,1757 ---- | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | + | | | null | (13 rows) SELECT '' AS "xxx", * *************** *** 1799,1806 **** | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | - | | | null | | | 0 | zero | | | | | | | | | 0 (15 rows) --- 1799,1806 ---- | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | + | | | null | | | | | | | | | 0 (15 rows) *************** *** 1820,1827 **** | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | - | | | null | | | 0 | zero | | | | | | | | | 0 (15 rows) --- 1820,1827 ---- | 6 | 6 | six | | 7 | 7 | seven | | 8 | 8 | eight | | | 0 | zero | + | | | null | | | | | | | | | 0 (15 rows) ======================================================================
7.2b3 compiles and passes all tests on Linux/Sparc64. I updated the regression test database. -Doug -- Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863
Luis Amigo <lamigo@atc.unican.es> writes: > again join and geometry(it also failed in postgres 7.1.3) The join discrepancy is probably an artifact of your local qsort() behaving slightly differently for equal keys than everyone else's. Curious that it only affects these few queries, though. Geometry differences in the low-order digits are par for the course. I wouldn't even stop to think about it, except that I see that you are already using a platform-specific geometry comparison file (geometry-irix.out). Some digging in the CVS logs and mail archives shows that that file was submitted by Pete Forman in Oct 2000, and he was using > Architecture (example: Intel Pentium) : SGI MIPS 8000 > > Operating System (example: Linux 2.0.26 ELF) : IRIX 6.5.5m > > PostgreSQL version (example: PostgreSQL-7.1): PostgreSQL-7.1 > > Compiler used (example: gcc 2.8.0): MIPSPro 7.3 Not clear at this point if the differences in your results are due to hardware, library version, or compiler version differences. regards, tom lane
Tom Lane wrote: > Luis Amigo <lamigo@atc.unican.es> writes: > > again join and geometry(it also failed in postgres 7.1.3) > > The join discrepancy is probably an artifact of your local qsort() > behaving slightly differently for equal keys than everyone else's. > Curious that it only affects these few queries, though. > > Geometry differences in the low-order digits are par for the course. > I wouldn't even stop to think about it, except that I see that you > are already using a platform-specific geometry comparison file > (geometry-irix.out). Some digging in the CVS logs and mail archives > shows that that file was submitted by Pete Forman in Oct 2000, and > he was using > > > Architecture (example: Intel Pentium) : SGI MIPS 8000 > > > > Operating System (example: Linux 2.0.26 ELF) : IRIX 6.5.5m > > > > PostgreSQL version (example: PostgreSQL-7.1): PostgreSQL-7.1 > > > > Compiler used (example: gcc 2.8.0): MIPSPro 7.3 > > Not clear at this point if the differences in your results are due to > hardware, library version, or compiler version differences. > > regards, tom lane I've reviewed the results, join differences seem to be conceptual differences, expected result gives higher value to NULL that 0 (personally I think 0 is bigger than NULL). Geometry differences are architectural round up differences (I think that MIPS 10000 and 12000 may have corrected previous errors or might be a different point-of-view about rounding)
> > OU8 is UW 7 + LKP (Linux Kernel Personality) + Bug Fixes. > > OK, I'll just do one entry for both UW and OU. Love those name changes > :( If the first name doesn't succeed, try, try again. :-) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
> regression test on irix 6.5.12 with MIPSpro Compilers: Version 7.3.1.2m > (this platform is 8-r10000 ip25 processors, previous is 8 -r12000 ip35 processors) > > ======================= > 2 of 79 tests failed. > ======================= > again join and geometry(it also failed in postgres 7.1.3) Got both reports. Counts as good from my pov... Thanks! - Thomas
OK, the list is getting smaller fast (thanks for all of the responses!). Here is what I have left currently (note the addition of NetBSD/sparc, which I had inadvertently omitted from the first list): BeOS Cyril Velter Linux/arm Mark Knox Linux/s390 Neale Ferguson NetBSD/arm32 Patrick Welche NetBSD/m68k Bill Studenmund (will test) NetBSD/sparc Matthew Green (left off the first list) NetBSD/VAX Tom I. Helbekkmo QNX (did I get a definitive report for 4.x already?) SunOS Tatsuo Ishii (old release; still relevant?) Windows/Cygwin Daniel Horak (OK in serial test, trouble with parallel test?) Windows/native Magnus Hagander (clients only) I'm curious about the Windows/Cygwin trouble, and if others see it too, since the -cygwin mailing list seems to report happiness with 7.1.3. Tatsuo, do you think that we should still track SunOS explicitly? Are there any other platforms we are running on? - Thomas The following platforms have been reported as successfully running PostgreSQL 7.2: AIX Andreas Zeugswetter (Tatsuo working on 5L?) BSD/OS Bruce FreeBSD Chris Kings-Lynne HPUX Tom (anyone tested 11.0 or higher?) IRIX Luis Amigo Linux/Alpha Tom Linux/MIPS Hisao Shibuya Linux/PPC Tom Linux/sparc Doug McNaught Linux/x86 Thomas (and many others ;) MacOS-X Gavin Sherry NetBSD/Alpha Thomas Thai NetBSD/PPC Bill Studenmund NetBSD/x86 Bill Studenmund OpenBSD/sparc Brandon Palmer OpenBSD/x86 Brandon Palmer SCO OpenUnix Larry Rosenman Solaris/sparc Andrew Sullivan Solaris/x86 Martin Renters Tru64 Alessio Bragadini (trouble with 5.1?)
Thomas Lockhart wrote: > > regression test on irix 6.5.12 with MIPSpro Compilers: Version 7.3.1.2m > > (this platform is 8-r10000 ip25 processors, previous is 8 -r12000 ip35 processors) > > > > ======================= > > 2 of 79 tests failed. > > ======================= > > again join and geometry(it also failed in postgres 7.1.3) > > Got both reports. Counts as good from my pov... > > Thanks! > > - Thomas I also count them as good but I think that someone may change expected, cause two platforms with different OS, architecture and compilers are giving same result.
Thomas Lockhart writes: > > OSR5 is the old Sco 3.2 stuff, and is a totally different > > beast/codeset. > > Maybe I'll just remove mention of it altogether. Either it is > supportable because it is Unix-y and somewhat compatible with other SCO > products, or it isn't, but it isn't worth guessing at either way unless > someone can test it. This seems to be a little drastic, just because one company ships two separate products and everyone is confused about why they would do that. Quite a few people do use OpenServer (successfully, after a few patches against 7.1 which made it into 7.2), but if no one ends up submitting a test result it will simply stay in the unsupported area. -- Peter Eisentraut peter_e@gmx.net
Tom Lane wrote: > Luis Amigo <lamigo@atc.unican.es> writes: > > again join and geometry(it also failed in postgres 7.1.3) > > The join discrepancy is probably an artifact of your local qsort() > behaving slightly differently for equal keys than everyone else's. > Curious that it only affects these few queries, though. > > Geometry differences in the low-order digits are par for the course. > I wouldn't even stop to think about it, except that I see that you > are already using a platform-specific geometry comparison file > (geometry-irix.out). Some digging in the CVS logs and mail archives > shows that that file was submitted by Pete Forman in Oct 2000, and > he was using > > > Architecture (example: Intel Pentium) : SGI MIPS 8000 > > > > Operating System (example: Linux 2.0.26 ELF) : IRIX 6.5.5m > > > > PostgreSQL version (example: PostgreSQL-7.1): PostgreSQL-7.1 > > > > Compiler used (example: gcc 2.8.0): MIPSPro 7.3 > > Not clear at this point if the differences in your results are due to > hardware, library version, or compiler version differences. > > regards, tom lane I've been searching for info that could explain round-up difference in geometry. I believe i've found a reasonable explanation, there is a architecture disroupt between old MIPS3 FPUs and newer MIPS4 FPUs.(so I'm almost sure that is the explanation). I would like to know if is there anyone else running on IRIX, so we can discuss these and other results from another point of view. Thanks for all your heavy working. best wishes.
Luis Amigo <lamigo@atc.unican.es> writes: > I've been searching for info that could explain round-up difference in > geometry. > I believe i've found a reasonable explanation, there is a architecture > disroupt between old MIPS3 FPUs > and newer MIPS4 FPUs.(so I'm almost sure that is the explanation). > I would like to know if is there anyone else running on IRIX, so we can > discuss these and other results from another point of view. I sent mail earlier to Pete Forman, who submitted the existing geometry-irix comparison file. He hasn't responded yet. If Pete's lost interest then I'd be willing to adopt your results as the standard geometry-irix file. If he's still interested then we'd need to figure out a way for the resultmap mechanism to distinguish older and newer MIPS hardware in order to accommodate two sets of IRIX geometry results. Got any idea how to do that? (Does config.guess produce any relevant info?) regards, tom lane
On Wed, 28 Nov 2001, Larry Rosenman wrote: > I've upgraded to OpenUNIX 8, and all is well. > > It probably passes on UW 7 as well, but I can no longer test it. 7.2b3 does run ok on uw711 (regression test shows no error) [snip] -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)
Tom Lane wrote: > Luis Amigo <lamigo@atc.unican.es> writes: > > > I believe i've found a reasonable explanation, there is a architecture > > disroupt between old MIPS3 FPUs > > and newer MIPS4 FPUs.(so I'm almost sure that is the explanation). > > If Pete's lost interest then I'd be willing to adopt your results as > the standard geometry-irix file. If he's still interested then we'd > need to figure out a way for the resultmap mechanism to distinguish > older and newer MIPS hardware in order to accommodate two sets of > IRIX geometry results. Got any idea how to do that? (Does config.guess > produce any relevant info?) > > regards, tom lane First I have to apologize, I said MIPS3 and MIPS4 architecture, MIPS are proccesor instructions set no architecture, and r8000 CPUs have MIPS4 instructions set. I should have said old 8010 FPUs and newer 10010 and 12010 FPUs. I think there are only three possible reasons in differences: 1.- FPUs architecture. 2.- compiler specific optimization( It's only possible if Pete turned on extensive optimization for 8000), because we are compiling with full-compatibility options -rx directives optimize cache and memory use but does not affect proccessors.) 3.-If regress is sending binary data to disk and later retrieving the data and writing output files, there "might" be rounding up differences between what was written and readed. I still believe this difference is made by FPUs config.guess only says mips-sgi-irix6.5 I think we can make two results choosing FPUs from hinv but we don´t have another r8000 to test Pete's results nor another r10000 or 12000 to test our results. I would try to test in our 4 r10000 IP27 to be sure that our results are right. regards Luis Amigo
> 7.2b3 does run ok on uw711 (regression test shows no error) Thanks! I'll update the list. - Thomas
Luis Amigo writes: > I still believe this difference is made by FPUs > config.guess only says mips-sgi-irix6.5 If your uname -m gives any clue about the processor type we might want to create a patch for config.guess. -- Peter Eisentraut peter_e@gmx.net
Peter Eisentraut wrote: > Luis Amigo writes: > > > I still believe this difference is made by FPUs > > config.guess only says mips-sgi-irix6.5 > > If your uname -m gives any clue about the processor type we might want to > create a patch for config.guess. > > -- > Peter Eisentraut peter_e@gmx.net uname -m returns IP25 what is SGI platform, it's about cache sizes and internal net issues, I'm not sure that would work, I think it's more reliable to do: congrio 39% hinv -t cpu CPU: MIPS R10000 Processor Chip Revision: 2.5 CPU: MIPS R10000 Processor Chip Revision: 2.5 CPU: MIPS R10000 Processor Chip Revision: 2.5 CPU: MIPS R10000 Processor Chip Revision: 2.5 CPU: MIPS R10000 Processor Chip Revision: 2.6 CPU: MIPS R10000 Processor Chip Revision: 2.6 CPU: MIPS R10000 Processor Chip Revision: 2.6 CPU: MIPS R10000 Processor Chip Revision: 2.6 or congrio 40% hinv -t fpu FPU: MIPS R10010 Floating Point Chip Revision: 2.5 FPU: MIPS R10010 Floating Point Chip Revision: 2.5 FPU: MIPS R10010 Floating Point Chip Revision: 2.5 FPU: MIPS R10010 Floating Point Chip Revision: 2.5 FPU: MIPS R10010 Floating Point Chip Revision: 2.6 FPU: MIPS R10010 Floating Point Chip Revision: 2.6 FPU: MIPS R10010 Floating Point Chip Revision: 2.6 FPU: MIPS R10010 Floating Point Chip Revision: 2.6 as you wish best regards
Luis Amigo <lamigo@atc.unican.es> writes: > uname -m returns IP25 what is SGI platform, it's about cache sizes and > internal net issues, I'm not sure that would work, I think it's more > reliable to do: > congrio 39% hinv -t cpu > congrio 40% hinv -t fpu I'm not eager to add such a platform-dependent test to the resultmap code, especially not when the issue is just the geometry results; we already know that the long-term answer there must be to display fewer digits in the test output. Also, we don't know what this program will report for older MIPS boxes anyway. (Pete Forman hasn't responded to my ping, so I'm inclined to assume that he's not actively tracking Postgres development anymore; we can't expect help from him to check it on the older boxes.) I'd be willing to just commit the newer-hardware IRIX results as geometry-irix for 7.2. Somebody's got to put up with a discrepancy, and it may as well be the older boxes. Comments? regards, tom lane
Tom Lane wrote: > Luis Amigo <lamigo@atc.unican.es> writes: > > uname -m returns IP25 what is SGI platform, it's about cache sizes and > > internal net issues, I'm not sure that would work, I think it's more > > reliable to do: > > congrio 39% hinv -t cpu > > congrio 40% hinv -t fpu > > I'm not eager to add such a platform-dependent test to the resultmap > code, especially not when the issue is just the geometry results; we > already know that the long-term answer there must be to display fewer > digits in the test output. Also, we don't know what this program will > report for older MIPS boxes anyway. (Pete Forman hasn't responded to my > ping, so I'm inclined to assume that he's not actively tracking Postgres > development anymore; we can't expect help from him to check it on the > older boxes.) > > I'd be willing to just commit the newer-hardware IRIX results as > geometry-irix for 7.2. Somebody's got to put up with a discrepancy, > and it may as well be the older boxes. > > Comments? > > regards, tom lane I'm completely with you, I don´t think that would be useful to mantain such firmware dependecies, but I think that it might be useful to document this and problems with gcc, now we all remember this issue, but in two months all will be forgotten. We had here a lot of trouble installing our first 7.1.3 postgres because it wasn´t documented that gcc simply doesn´t run. I swear that when I had time I will try to compile with gcc and new libgcc links to try to fix this problem.
> I almost forget: best wishes and regards
Luis Amigo <lamigo@atc.unican.es> writes: > I'm completely with you, I don�t think that would be useful to mantain such > firmware dependecies, but I think that it might be useful to document this > and problems with gcc, now we all remember this issue, but in two months > all will be forgotten. > We had here a lot of trouble installing our first 7.1.3 postgres because it > wasn�t documented that gcc simply doesn�t run. I swear that when I had time > I will try to compile with gcc and new libgcc links to try to fix this > problem. Would you like to make up a FAQ_IRIX document similar to the ones we have for some other platforms (see, eg, doc/FAQ_HPUX)? It doesn't need to be long or fancy, just cover the things you wish you'd known sooner. regards, tom lane