Leandro Fanzone <leandro(at)hasar(dot)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