Re: When did we get to be so fast?

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: rovero@sonalysts.com    www.sonalysts.com    215 Parkway North
Work: (860)326-3671 or 442-4355                     Waterford CT 06385
***********************************************************************