| From: | Jean-Paul ARGUDO <jean-paul(dot)argudo(at)idealx(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | sdinot(at)idealx(dot)com, jean-paul(dot)argudo(at)idealx(dot)com, dbarth(at)idealx(dot)com |
| Subject: | Oracle vs PostgreSQL in real life |
| Date: | 2002-02-27 14:46:18 |
| Message-ID: | 20020227154618.A24424@singer.ird.idealx.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Okay...
I'm very sceptic today.
I'm making a survey on Oracle 8.0 on NT4 remplacement with a RedHat 7.2/PG 7.2
The customer gave me stuff to migrate, like scripts in Pro*C Oracle that I
migrated successfully with ECPG. Other stuff with Connect by statments, thanks
to OpenACS guys, I migrated this Connect by statments too.
But finaly, with all my mind I explained all queries, made all good, I hope
everything has be done.
The "test" is a big batch that computes stuffs in the database. Here are the
timings of both Oracle and PG (7.2) :
Oracle on NT 4 : 45 minuts to go , 1200 tps (yes one thousand and two hundred
tps)
Linux Red Hat 7.2 with PostgreSQL 7.2 : hours to go (statistically, 45 hours),
80 tps (eighty tps).
Tests were made on the same machine, a pentium 3 600 MHz with 256 Megs RAM and
RAID 5.
We formatted the server and insstalled linux stuff after..
So what you think of SUCH difference between Oracle/NT and Linux/PG ?
I feel very bad in front of the customer, to tell there is a 1:15 ratio between
Oracle / Nt and Linux / PostgreSQL, since I'm real PG fan and DBA in french Open
Souce company...
Thanks a lot for support.
:-(((
--
Jean-Paul ARGUDO
| From | Date | Subject | |
|---|---|---|---|
| Next Message | F Harvell | 2002-02-27 14:51:03 | Re: eWeek Poll: Which database is most critical to |
| Previous Message | Oleg Bartunov | 2002-02-27 13:48:27 | Re: single task postgresql |