10 concurrent clients / pure insert SQL scripts (each 100000 lines)

From: Arne Woerner <woerner(at)mediabase-gmbh(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: 10 concurrent clients / pure insert SQL scripts (each 100000 lines)
Date: 2002-10-19 12:49:54
Message-ID: 200210191249.g9JCnsuN005099@gargano.local.mediabase-gmbh.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi!

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))?

Thank you.

Bye
Arne

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message geva 2002-10-20 11:32:16 vacuum bug
Previous Message Peter Eisentraut 2002-10-18 22:11:04 Re: Bug #799: configure does not check for -lodbcinst