Re: [HACKERS] Profile of current backend

> > I (and others) had done some benchmarking on simple inserts (6 months ago?) and
> > had concluded that the speed was similar to other commercial systems (I was
> > comparing against Ingres). I recall getting ~50TPS.
> >
> > This was all before Bruce did his work on startup and runtime speeds. You
> > really think your performance is that far off? You are doing selects on the big
> > table before inserting? Do you have indices set up?? Our results were for
> > inserts on a heap table, which has the least overhead...
>
>     Just curious, but do you have -F set to disable fsync()?  We
> really really should disable that by default :(

Agreed.  But maybe we should wait until we get pg_log syncing so we have
30-second reliability.  Don't know where that fits on Vadim's list.

--
Bruce Momjian
maillist@candle.pha.pa.us