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