Re: Transactions - Mailing list pgsql-novice

From Tom Lane
Subject Re: Transactions
Date
Msg-id 14426.976029664@sss.pgh.pa.us
Whole thread Raw
In response to Transactions  (Leandro Fanzone <leandro@hasar.com>)
List pgsql-novice
Leandro Fanzone <leandro@hasar.com> writes:
> BEGIN TRANSACTION
> INSERT INTO test VALUES('any #n');
> COMMIT TRANSACTION

> leaves me with no records inserted at all after an abrupt reset on the
> server.

Are you perhaps starting the postmaster with "-o -F" (no fsync)?
If so, don't use that switch.  It buys performance at the cost
of not being secure against server system crashes.

            regards, tom lane

pgsql-novice by date:

Previous
From: Leandro Fanzone
Date:
Subject: Re: Transactions
Next
From: Helge Bahmann
Date:
Subject: Re: Transactions