Re: [HACKERS] bad performance on irix

2002-03-25 Thread Pete Forman
> performance analysis show high sleep waiting for resources IIRC there is a bottleneck on calls to sleep() or similar on IRIX SMP. All requests are dealt with on just one of the CPUs. I don't recollect whether there is a way to work around that or whether programs

[HACKERS] Re: Final call for platform testing

2001-04-04 Thread Pete Forman
> Solaris 2.7-8 Sparc7.1 2001-03-22, Marc Fournier I've reported Solaris 2.6 Sparc as working on a post-RC1 snapshot. -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.- by myself and does not represent [EMAIL P

[HACKERS] Re: Re: [PORTS] pgmonitor and Solaris

2001-03-30 Thread Pete Forman
ey all display the status in both SysV and BSD modes. On AIX there is one ps command which handles both styles. IRIX 6.2 and 6.5.4m through 6.5.10m have sendmail 8.8.8, 8.9.1, 8.9.3. No status is available. There do not appear to be any BSD-ish ps options. -- Pete Forman -./\.- Dis

Re: [HACKERS] RC1 core dumps in initdb on Solaris 2.6

2001-03-28 Thread Pete Forman
Pete Forman writes: > I've registered the result via the web form though the report is > not accurate. Can somebody update the Remarks or Version field to > indicate that I was using a snapshot rather than RC1 OOTB. Further to that request, please ignore/delete the existing Re

Re: [HACKERS] RC1 core dumps in initdb on Solaris 2.6

2001-03-28 Thread Pete Forman
Tom Lane writes: > Pete Forman <[EMAIL PROTECTED]> writes: > > The regression test is failing early on, during initdb. The core > > file indicates that there is a SIGBUS. Hopefully the bugs fixed > > as a result of the "More bogus alignment assumptions&q

[HACKERS] RC1 core dumps in initdb on Solaris 2.6

2001-03-27 Thread Pete Forman
x1, 0x3990d0, 0x0, 0x227818, 0x56), at 0x15da58 [11] PostgresMain(0x7, 0xefffecfc, 0x7, 0xefffecfc, 0x286930, 0x626f6f74), at 0x15f448 [12] main(0x7, 0xefffecfc, 0xefffed1c, 0x245000, 0x0, 0x0), at 0xf5494 (dbx) -- Pete Forman -./\.- Disclaimer: This post is originated Western

Re: [HACKERS] Fix for possible pg_dump core dump

2001-03-27 Thread Pete Forman
Philip Warner writes: > At 10:20 27/03/01 +0100, Pete Forman wrote: > >I've fixed this bug in 7.1RC1. It may have been causing core > >dumps by dereferencing a null function pointer. As it was the Sun > >compiler flagged it as an error. (SC5.0 on Solaris 2.6.)

[HACKERS] Fix for possible pg_dump core dump

2001-03-27 Thread Pete Forman
x) { return x; } int main(void) { int y = 0; f = g; if (*f) { y = f(1); } return y; } $ cc funcptr.c "funcptr.c", line 13: controlling expressions must have scalar type cc: acomp failed for funcptr.c -- Pete Forman -./\.- Di

[HACKERS] IANA registration

2001-03-26 Thread Pete Forman
with a reasonable grasp of the low level messages in PostgreSQL care to submit a registration? http://www.iana.org/ http://www.iana.org/cgi-bin/usr-port-number.pl http://www.isi.edu/in-notes/iana/assignments/port-numbers -- Pete Forman -./\.- Disclaimer: This post is

[HACKERS] Re: elog with automatic file, line, and function

2001-03-20 Thread Pete Forman
char __func__[] = "function-name"; Those other identifiers can be used in this sort of way. printf("Error in " __FILE__ " at line " __LINE__ "\n"); But you've got to do something like this for __func__. printf("Error in %

RE: [HACKERS] beta5 ...

2001-02-22 Thread Pete Forman
> think of anything else? Architecture. IRIX, Solaris and AIX allow applications and libraries to be built 32 or 64 bit. You may also like to add a field for configure options used. Or is this just for results OOTB? -- Pete Forman -./\.- Disclaimer: This post is originate

Re: [HACKERS] floating point representation

2001-02-20 Thread Pete Forman
e and a missing (optional) file. I'll correct those when the site allows uploads again. The files' contents are currently available at http://petef.8k.com/. -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.- by myself and does not represent [EMAIL PROTECTED] -./\.- opinion of Schlumberger, Baker http://www.crosswinds.net/~petef -./\.- Hughes or their divisions.

Re: [HACKERS] beta3 Solaris 7 (SPARC) port report

2001-01-29 Thread Pete Forman
run the regressions some > more? If that makes it go away, I'd say it pretty well points > straight into the Solaris kernel. My observations of Solaris UNIX domain socket problems were on single processor machines. -- Pete Forman -./\.- Disclaimer:

Re: [HACKERS] beta3 Solaris 7 (SPARC) port report [ Was: Lookingfor . . . ]

2001-01-26 Thread Pete Forman
hat some of the parameters that we wanted to tune were ignored in favour of hard coded values. In the end we rewrote our code to use Internet domain sockets (AF_INET). BTW, owing to a DNS error email to me has bounced over the last couple of days. It should be okay now if anything needs to

[HACKERS] Re: postgres memory management

2001-01-23 Thread Pete Forman
finding a process by name without the grep itself appearing is use something like "grep '[p]ostmaster'". -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.- by myself and does not represent [EMAIL PROTECTED] -.

Re: [HACKERS] FW: Postgresql on win32

2001-01-22 Thread Pete Forman
Tom Lane writes: > That'd be OK with me. I don't suppose Win32 has "sed" though :-( Cygwin does. We can worry about native support for PostgreSQL later ;-) -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.-

Re: AW: AW: AW: [HACKERS] Re: tinterval - operator problems on AIX

2001-01-22 Thread Pete Forman
ownloads a binary package it should not be expected to be able to take advantage of non standard features of the platform. It is reasonable that they should compile it from source to get the most from it. -- Pete Forman -./\.- Disclaimer: This post is origi

Re: AW: AW: AW: [HACKERS] Re: tinterval - operator problems on AIX

2001-01-18 Thread Pete Forman
I can't speak for gcc. -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.- by myself and does not represent [EMAIL PROTECTED] -./\.- opinion of Schlumberger, Baker http://www.crosswinds.net/~petef -./\.- Hughes or their divisions.

Re: AW: [HACKERS] Re: tinterval - operator problems on AIX

2001-01-12 Thread Pete Forman
Tom Lane writes: > Pete Forman <[EMAIL PROTECTED]> writes: > > Thinking about that a bit more, I think that tm_isdst should not > > be written into. > > IIRC, setting isdst to -1 was necessary to get the right behavior > across DST boundaries on more-mains

Re: AW: [HACKERS] Re: tinterval - operator problems on AIX

2001-01-12 Thread Pete Forman
localtime and mktime which depend on TZ. There is no dependency on PGTZ, unless somewhere else in postgres there is an equivalent of setenv(TZ=getenv(PGTZ)). -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.- by myself and does not represent

Re: AW: [HACKERS] Re: tinterval - operator problems on AIX

2001-01-12 Thread Pete Forman
amp;& a->tm_mon == b->tm_mon && a->tm_mday == b->tm_mday && a->tm_hour == b->tm_hour && a->tm_min == b->tm_min && a->tm_sec == b->tm_sec && a->tm_wday == b->tm_wday &a

Re: AW: AW: [HACKERS] Re: tinterval - operator problems on AIX

2001-01-11 Thread Pete Forman
Pete Forman writes: > One workaround would be to add 4*n to tm_year and subtract (365*4+1) > *24*60*60*n from the time_t returned. (All leap years are multiples > of 4 in the range 1901 to 2038. If tm_wday is wanted, that will need > to be adjusted as well.) FWIW, that should

Re: AW: AW: [HACKERS] Re: tinterval - operator problems on AIX

2001-01-11 Thread Pete Forman
ill need to be adjusted as well.) But don't you do time interval arithmetic using PostgreSQL date types rather than accepting the limitations of POSIX/UNIX? -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.- by myself and does n

Re: AW: [HACKERS] Re: tinterval - operator problems on AIX

2001-01-10 Thread Pete Forman
r this a bug report and a necessary fix > for 7.1. I have machines running AIX 4.1.5, 4.2.1, and 4.3.3 if you would like to send me your test programs. -- Pete Forman -./\.- Disclaimer: This post is originated WesternGeco -./\.- by myself and does not represen

Re: [HACKERS] pg_dump return status..

2001-01-08 Thread Pete Forman
Philip Warner writes: > At 09:36 8/01/01 +0000, Pete Forman wrote: > >There are no compiler errors, just run time errors if you rely on > >the return from sprintf() being the number of characters. > > All I need to know is how to detect an error. Does it return

Re: [HACKERS] patch: contrib/pgcrypto sanity

2001-01-08 Thread Pete Forman
es.h does not know about this. I guess that C99 forgot to > > specify _where_ they should be defined. > > Correction, they both have which probably is the right > location for this. is adequate to pick up uint*_t. is defined to include . Of course all this C99 stuff is new and

Re: [HACKERS] pg_dump return status..

2001-01-08 Thread Pete Forman
are no compiler errors, just run time errors if you rely on the return from sprintf() being the number of characters. The workaround is to put an extra -lc on the link line before the -lbsd if your code needs both standard sprintf() and some other BSD function. Ultrix is documented as having t

Re: [HACKERS] Question about Oracle compatibility

2000-11-28 Thread Pete Forman
r value with a length of zero as null. However, this may not continue to be true in future releases, and Oracle recommends that you do not treat empty strings the same as NULLs. -- Pete Forman -./\.- Disclaimer: This post is originated Western Geophysical -./\.-

[HACKERS] Re: Add support for

2000-11-23 Thread Pete Forman
Tom Lane writes: > Pete Forman wrote: > > The basic problem is that is a BSD header. The > > correct header for TCP internals such as TCP_NODELAY on a UNIX > > system is . By UNIX I mean UNIX95 (aka XPG4v2 or SUSv1) > > or later. The 2 files which conditionally

Re: [HACKERS] (download ANSI SQL benchmark?) Re: Postgres article

2000-11-21 Thread Pete Forman
on Linux) and Proprietary 2 (version 7.0, on NT). -- Pete Forman -./\.- Disclaimer: This post is originated Western Geophysical -./\.- by myself and does not represent [EMAIL PROTECTED] -./\.- the opinion of Baker Hughes or http://www.crosswinds.net/~petef -./\.- its divisions.

Re: [HACKERS] problems with configure

2000-11-09 Thread Pete Forman
, or if accept is mapped as a macro to another function. Whatever, I'd be happier if "void *" were mapped to "unsigned int*" as that is what the Solaris 7 library is expecting. But it's no big deal if you want to go with signed. -- Pete Forman -./\.- Di

Re: AW: [HACKERS] Unhappy thoughts about pg_dump and objects inherited from template1

2000-11-09 Thread Pete Forman
her had one read-only schema and created one schema per project managed. The client code accessed two or more schemata at a time. We used the term database to mean all the schemata. -- Pete Forman -./\.- Disclaimer: This post is originated Western Geophysical -./\.- by

Re: [HACKERS] problems with configure

2000-11-09 Thread pete . forman
igure from the current CVS sources on Solaris 7 with the following workaround. I presume that there is a better place to apply the change. CPPFLAGS="-D_XOPEN_SOURCE -D_XOPEN_SOURCE_EXTENDED" configure -- Pete Forman -./\.- Disclaimer: This post is originated Western Geo

Re: AW: [HACKERS] v7.0.3 *pre-release* ...

2000-11-07 Thread Pete Forman
Pete Forman writes: > The only remaining failure is geometry. The results I got were > nearly identical to geometry-powerpc-aix4.out. The only > differences were the order of rows returned by three of the tables. > I'll submit the results file to pgsql-patches. I'v

AW: [HACKERS] v7.0.3 *pre-release* ...

2000-11-07 Thread Pete Forman
ed there ought to be an entry added to the faq-aix. -- Pete Forman -./\.- Disclaimer: This post is originated Western Geophysical -./\.- by myself and does not represent [EMAIL PROTECTED] -./\.- the opinion of Baker Hughes or http://www.crosswinds.net/~petef -./\.- its divisions.

AW: [HACKERS] v7.0.3 *pre-release* ...

2000-11-07 Thread Pete Forman
licate symbol: .PQuntrace ld: 0711-224 WARNING: Duplicate symbol: .PQtrace ld: 0711-224 WARNING: Duplicate symbol: .setsockopt ld: 0711-224 WARNING: Duplicate symbol: setsockopt [and others] -- Pete Forman -./\.- Disclaimer: This post is originated Western Geo

Re: [HACKERS] v7.0.3 *pre-release* ...

2000-11-07 Thread Pete Forman
during a VACUUM. Killing the backend was the only way to continue. -- Pete Forman -./\.- Disclaimer: This post is originated Western Geophysical -./\.- by myself and does not represent [EMAIL PROTECTED] -./\.- the opinion of Baker Hughes or http://www.crosswinds.net/~petef -./\.- its divisions.

Re: [HACKERS] 7.0.3 branded

2000-11-03 Thread Pete Forman
Bruce Momjian writes: > I have marked 7.0.3 release tree. The new 7.0.3 items are listed > below. So have Jason's patches to build on Cygwin not made it in? On a related note, what tag should I give to cvs to get code from the 7.0.3 branch? Is it REL7_0_PATCHES? --

Re: [HACKERS] Re: Add support for

2000-10-25 Thread Pete Forman
en echo '%%' > conftest.l if $pgac_candidate -t conftest.l 2>/dev/null | grep FLEX_SCANNER >/dev/null 2>&1; then -- Pete Forman -./\.- Disclaimer: This post is originated Western Geophysical -./\.- by myself and does not represent [EMAIL PROTECTED] -./\.- the opinion of Baker Hughes or http://www.crosswinds.net/~petef -./\.- its divisions.

Re: [HACKERS] Re: Add support for

2000-10-24 Thread Pete Forman
ut cc-1035 cc: WARNING File = /usr/include/sys/endian.h, Line = 32 #error directive: " must be included before ." #error " must be included before ." ^ configure: failed program was: #line 4354 "configure" #include "confdefs.h" #include

[HACKERS] Re: Add support for

2000-10-23 Thread Pete Forman
{retry of message sent Fri, 20 Oct 2000 14:04:16 +0100 (BST)] Tom Lane writes: > Pete Forman wrote: > > The basic problem is that is a BSD header. The > > correct header for TCP internals such as TCP_NODELAY on a UNIX > > system is . By UNIX I mean UNIX95 (aka XPG