Oracle vs PostgreSQL in real life
От | Jean-Paul ARGUDO |
---|---|
Тема | Oracle vs PostgreSQL in real life |
Дата | |
Msg-id | 20020227154618.A24424@singer.ird.idealx.com обсуждение исходный текст |
Ответы |
Re: Oracle vs PostgreSQL in real life
|
Список | 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
В списке pgsql-hackers по дате отправления: