RE: [HACKERS] Profile of current backend

The numbers are from 6.3.

Michael

--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes(at)topsystem(dot)de | Europark A2, Adenauerstr. 20
meskes(at)debian(dot)org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10

> -----Original Message-----
> From: Bruce Momjian [SMTP:maillist(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Tuesday, February 10, 1998 4:41 PM
> To: meskes(at)topsystem(dot)de
> Cc: scrappy(at)hub(dot)org; pgsql-hackers(at)postgreSQL(dot)org
> Subject: Re: [HACKERS] Profile of current backend
>
> >
> > The Hermit Hacker writes:
> > > Just curious, but do you have -F set to disable fsync()? We
> > > really really should disable that by default :(
> >
> > I tried with -F and it runs nicely. No difference to see between
> PostgreSQL
> > and Oracle. I just ran another test which includes table creation,
> inserts
> > and drop (source follows). Here's the result:
> >
> > Oracle 7.3.3.4.0:
> > I needed 21 seconds and -345682 microseconds for this test
> >
> > PostgreSQL without -F:
> > I needed 152 seconds and -623545 microseconds for this test
> >
> > PostgreSQL with -F:
> > I needed 5 seconds and 84411 microseconds for this test
> >
> > Whow!
> >
>
>
> This is good news. Is this with 6.3 or 6.2.1?
>
> --
> Bruce Momjian
> maillist(at)candle(dot)pha(dot)pa(dot)us