I tried to insert values into a table (created by
CREATE TABLE gaga42 (a bigint, b char varying);
) (inserted by
insert into gaga42 values (0,X);
(where X varies between '' and '1...1' (1000 chars))
). I used the standard configuration of PostgreSQL 7.1.3 on a OpenBSD 3.1
box with 384 MB main memory and a SCSI RAID disc and the following command
(gaga41.1.sql contains the inserts:
time csh -c "repeat 10 sh -c 'time psql -q gaga < gaga42.1.sql &'"
It took 20000 seconds and as I could see (top command) there were 12 postgres
processes which were disabling each other due to semwait conditions (I think
they used excessively semophores).
Is this bug fixed in 7.2.3?
Do you think OpenBSD 3.1 has problems with semaphores (should be an easy
feature (its a single processor machine))?
pgsql-bugs by date
|Next:||From: geva||Date: 2002-10-20 11:32:16|
|Subject: vacuum bug|
|Previous:||From: Peter Eisentraut||Date: 2002-10-18 22:11:04|
|Subject: Re: Bug #799: configure does not check for -lodbcinst|