Bruce Momjian wrote:
I was just testing the threaded ecpg, and ran some performance tests.
Without using threads, I am seeing 100,000 inserts of a single word into
a simple table take 12 seconds:
CREATE TABLE test_thread(message TEXT);
giving me 8333 inserts per second. That seems very high.
I remember testing on older hardware and seeing around 60 inserts per
second. Have we improved our performance that much, or is it the
hardware improving over the years.
My hardware list listed on my homepage, shown below.
This is with 7.4, default everything.
I ran a suite of pgbench runs (100 different client/transaction
count combinations) 5 times to compare 7.3.4 and 7.4b1.
7.4b1 was (on average) 31% faster than 7.3.4.
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: [EMAIL PROTECTED] www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
