When did we get to be so fast?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема When did we get to be so fast?
Дата
Msg-id 200308071639.h77GdUj15494@candle.pha.pa.us
обсуждение исходный текст
Ответы Re: When did we get to be so fast?  ("P.J. \"Josh\" Rovero" <rovero@sonalysts.com>)
Re: When did we get to be so fast?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: new psql \d command
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: new psql \d command