RE: Is Oracle really so much faster

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Konstantinos Agouros'" <elwood(at)agouros(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: RE: Is Oracle really so much faster
Date: 2001-02-02 18:42:56
Message-ID: 8F4C99C66D04D4118F580090272A7A234D32DA@sectorbase1.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2001-02-02 19:05:00 PostgreSQL profiling?
Previous Message Anand Raman 2001-02-02 18:39:17 Re: plpgsql always returning null..