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(at)candle(dot)pha(dot)pa(dot)us