Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group