common area

From: Michael Meskes <meskes(at)topsystem(dot)de>
To: pgsql-hackers(at)postgresql(dot)org (PostgreSQL Hacker)
Subject: common area
Date: 1998-02-27 09:48:42
Message-ID: 199802270948.KAA27359@gauss.topsystem.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

It seems we need something like that too. I've just run the new perftest
program against PostgreSQL and Oracle. It does:

1) insert 1407 tuples into two tables
2) select one attribute from one table
3) select one attribute from the join og both tables
4) updates one attribute in one table.

Here are the results:

Oracle:
I needed 24 seconds and 1937 microseconds for the insert test.
I needed 1 seconds and 600641 microseconds for the selection&projection test.
I needed 1 seconds and 703673 microseconds for the join test.
I needed 2 seconds and 404709 microseconds for the update test.

PostgreSQL with -F:
I needed 10 seconds and 297716 microseconds for the insert test.
I needed 28 seconds and 964208 microseconds for the selection&projection test.
I needed 83 seconds and 931762 microseconds for the join test.
I needed 0 seconds and 588390 microseconds for the update test.

Michael

--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes(at)topsystem(dot)de | Europark A2, Adenauerstr. 20
meskes(at)debian(dot)org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 1998-02-27 10:05:22 Re: [HACKERS] Snapshot 26Feb98 - another minor showstopper
Previous Message Maurice Gittens 1998-02-27 08:57:11 Howto add a field to each postgresql tuple