Re: [HACKERS] Profile of current backend
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: meskes@topsystem.de (Michael Meskes)
Cc: scrappy@hub.org, pgsql-hackers@postgreSQL.org
Date: 1998-02-10T15:40:51Z
Lists: pgsql-hackers
> > 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