When did we get to be so fast?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: When did we get to be so fast?
Date: 2003-08-07 16:39:30
Message-ID: 200308071639.h77GdUj15494@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2003-08-07 16:40:02 test
Previous Message Andreas Pflug 2003-08-07 16:38:43 Re: new psql \d command