Re: Oracle vs PostgreSQL in real life

On Wed, 2002-02-27 at 16:46, 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. 

What was the postgresql.conf set to ?

> 
> The "test" is a big batch that computes stuffs in the database. 

Could you run this batch in smaller chunks to see if PG is slow from the
start or does it slow down as it goes ?

> 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).

What kind of tps are these ? 

I.e. what does each t do ?

-------------
Hannu