Re: Oracle vs PostgreSQL in real life

Hi Jean-Paul,

I know you've probably done this, but I'll ask just in case.

Did you tune the memory of the PostgreSQL server configuration?

i.e. the postgresql.conf file?

If so, what are the values you changed from default?

:-)

Regards and best wishes,

Justin Clift

Jean-Paul ARGUDO wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi