Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group