RE: [HACKERS] Profile of current backend

The numbers are from 6.3.

Michael

--
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.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@candle.pha.pa.us]
> Sent:    Tuesday, February 10, 1998 4:41 PM
> To:    meskes@topsystem.de
> Cc:    scrappy@hub.org; pgsql-hackers@postgreSQL.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@candle.pha.pa.us