Re: [HACKERS] Postgres Speed or lack thereof

Tom Lane wrote:
> 
> Vadim Mikheev <vadim@krs.ru> writes:
> > For the table with single int4 column & 2000 INSERTs I have:
> 
> > BEGIN/END:            3.5sec          ~600insert/sec
> > Without:            151sec            ~13insert/sec
> 
> > (IDE disk!)
> 
> > I guess that you don't use -F flag..?
> 
> *Do* use -F, you meant of course.  You're right, I do.  With an

Actually no -:)

> fsync after every transaction, I'm sure my test would've been much
> slower.

Just use BEGIN/END to run all queries in single transaction -:)

> However, with a UPS and an OS that only crashes about once every
> other year, I feel pretty secure using -F ...

However, it's easy to crash Postgres itself and lose
committed transactions -:(

Vadim