Re: numeric test on RiscPC

Patrick Welche <prlw1@newn.cam.ac.uk> writes:
> I have just found to my surprise:
> ============== running regression test queries        ==============
> parallel group (13 tests):  char name int2 text float4 oid int4 varchar int8 float8 boolean bit numeric

>   PID USERNAME PRI NICE   SIZE   RES STATE      TIME   WCPU    CPU COMMAND
> 27747 prlw1     72    4   596K  276K RUN      277.7H 98.10% 98.10% sh

> 277.7H being just over 11.5 days!

> Have any of you tried
>  PostgreSQL 7.2 on acorn32-unknown-netbsd1.5ZB, compiled by GCC egcs-1.1.2
> on an Acorn RiscPC with a SA-110? (This is the well known "halting problem" :) )

Looks like Acorn's shell has the same bug documented to exist in HPUX's
shell (see doc/FAQ_HPUX :-() ... it gets confused when it has to manage
more than about a dozen child processes.

On HPUX I can work around this by telling pg_regress to use ksh instead.
If you have any other shells besides plain sh, give them a try.

            regards, tom lane