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

Dual-CPU slower then Single under HP?

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Dual-CPU slower then Single under HP?
Date: 2001-06-06 17:23:49
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Morning all ...

	Have a client that is running an HP server, specs as follows:

> HP-UX 11.00 HP 9000 L-200, Dual CPU (400MHz - 64 bit),
> OS Disk: 9GB U2W-LVD SCSI, 10K rpm

	They are trying to determine whether or not it will be able to
handle their environment, and we're trying to help them from the PgSQL
side of things ...

	They've got one of the HP developers working side-by-side with
them, looking at the hardware itself, and they've found:

" Running two concurrent Psql/Postgres processes made things worse. They
are blocking each other on semaphores. Elapsed time went from 4m:30s to
6m:15s (100K inserts)."

	The 4m:30s is running one process for 100K inserts ... with two
CPUs/processes, it increases the time to process by almost 40% ... ?

	Does this make sense?

	Looking at disk IO during the inserts, its pretty much dead ...
other then the occasional 'burst' to disk, the disks are quiet, so its all
getting tied up in CPU ...

	Thoughts?  Suggestions?  Other things to investigate that I'm not
thinking of?

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org


pgsql-hackers by date

Next:From: Peter EisentrautDate: 2001-06-06 17:28:01
Subject: elog(NOIND)?
Previous:From: Feng TianDate: 2001-06-06 16:16:59
Subject: Adding some new operators

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