Yes, I heard something similar, but it's the same problem, I think the
transaction log never reaches the disk. I tried -B1 but complains (it must
be 16 at least). Thank you for your help, anyway. Any other ideas?
Leandro Fanzone.
Nabil Sayegh wrote:
> 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