Re: Transactions

Leandro Fanzone wrote:

> I'm having problems with transactions, lately. I'm checking
> power-failure conditions on my psql-based programs, and found that a
> simple loop with

I found this article at dejanews:

"[...] I see about a 50x to 100x performace increase with the inserts.
This is because the default PostgreSQL setting is to write any commit
through the disk cache directly onto disk.  If you don't use 'begin'
and 'commit' then every operation is a transaction and therefore written
to disk immediately. [...]"

cu
--
 Nabil Sayegh