Thread

RE: [HACKERS] Profile of current backend

Michael Meskes <meskes@topsystem.de> — 1998-02-10T15:53:22Z

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