RE: Is Oracle really so much faster - Mailing list pgsql-general

From Mikheev, Vadim
Subject RE: Is Oracle really so much faster
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D32DA@sectorbase1.sectorbase.com
Whole thread Raw
In response to Is Oracle really so much faster  (elwood@agouros.de (Konstantinos Agouros))
Responses PostgreSQL profiling?
List pgsql-general
> > > However the result was (running on 64bit Sol 7, E250/1Gig
> > > RAM) that Oracle was roughly twice as fast. Is this real
> > > or might there be stuff I could do, to improve postgres
> > > performance?
> >
> > PostgreSQL version?
> 7.0.2

Try 7.1 or use -F.

> > You didn't use -F, did you?
> What's -F ?

This option disables fsync(). It's not honest to use -F for
comparison with other DBMSes, but before 7.1 it was only means
to be comparable -:)

Vadim

pgsql-general by date:

Previous
From: Anand Raman
Date:
Subject: Re: plpgsql always returning null..
Next
From: Alex Pilosov
Date:
Subject: PostgreSQL profiling?