Re: Possible to prevent transaction abort?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Possible to prevent transaction abort?
Date: 2009-05-02 15:08:00
Message-ID: gthnka$t8c$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adam B wrote on 02.05.2009 00:48:
> Strange indeed. Perhaps there's some background stuff happening that
> messes with the results (auto VACUUM?).
>
> In my mind, however, it makes sense that it would take longer: 2 extra
> operations against the server (save&release).

Typical case of "problem sits between keyboard and chair".

My import program had an additional parameter which was needed to enable the
savepoint. If that is set, the results are comparable to your test program (and
reproducable). So my fast results were not using savepoints.

Sorry for the confusion.

Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-05-02 15:48:21 Re: Tracking down a deadlock
Previous Message Bill Moseley 2009-05-02 14:43:18 Re: Tracking down a deadlock