From: | Leandro Fanzone <leandro(at)hasar(dot)com> |
---|---|
To: | |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Transactions |
Date: | 2000-12-05 14:48:12 |
Message-ID: | 3A2D002C.216E9491@hasar.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-12-05 15:21:04 | Re: Transactions |
Previous Message | Nabil Sayegh | 2000-12-05 14:40:26 | Re: Transactions |