Re: Possible to prevent transaction abort?

From: Adam B <adamb(at)videx(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Possible to prevent transaction abort?
Date: 2009-05-01 22:48:41
Message-ID: 49FB7C49.4010400@videx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="" text="#000000">
Strange indeed.&nbsp; Perhaps there's some background stuff happening that
messes with the results (auto VACUUM?).<br>
<br>
In my mind, however, it makes sense that it would take longer: 2 extra
operations against the server (save&amp;release).<br>
<br>
Thomas Kellerer wrote:
<blockquote cite="mid:gtfs47$9j3$1(at)ger(dot)gmane(dot)org" type="cite">Adam B
wrote on 01.05.2009 22:59:
<br>
<blockquote type="cite">Perhaps I'm doing something wrong.&nbsp; I'm
consistently taking over 20s for the following test case.&nbsp; (Without
savepoints it takes under 10s)
<br>
<br>
</blockquote>
<br>
That's really strange. I can reproduce your results on my computer (25
vs. 65 seconds).
<br>
<br>
When running my import program against your table, I don't see a big
difference between the savepoint solution and the one without (I added
a row to the import file that would fail to make sure I was really
using savepoints)
<br>
<br>
My import program is doing more or less the same thing as your code, so
I have
<br>
no idea what's going on here.
<br>
<br>
There was one strange thing though: I had one run where it took a lot
longer with the savepoint than without. But I could not reproduce that,
all other tests where&nbsp; approx. the same runtime with or without
savepoints.
<br>
<br>
Very strange.
<br>
<br>
Might be worth posting to the JDBC list, to see if this is a driver
issue....
<br>
<br>
Thomas
<br>
<br>
<br>
</blockquote>
<br>
<BR />
<BR />
<HR />
Videx&nbsp;Inc.&nbsp;1105&nbsp;N.&nbsp;E.&nbsp;Circle&nbsp;Blvd.&nbsp;Corvallis&nbsp;OR&nbsp;97330&nbsp;(541)&nbsp;758-0521<BR />
CONFIDENTIAL&nbsp;COMMUNICATION:&nbsp;The&nbsp;email&nbsp;message&nbsp;and&nbsp;any&nbsp;attachments&nbsp;are&nbsp;intended&nbsp;only&nbsp;for&nbsp;the&nbsp;addressee.&nbsp;&nbsp;They&nbsp;may&nbsp;be&nbsp;privileged,&nbsp;confidential,&nbsp;and&nbsp;protected&nbsp;from&nbsp;disclosure.&nbsp;If&nbsp;you&nbsp;are&nbsp;not&nbsp;the&nbsp;intended&nbsp;recipient,&nbsp;any&nbsp;dissemination,&nbsp;distribution,&nbsp;or&nbsp;copying&nbsp;is&nbsp;expressly&nbsp;prohibited.&nbsp;&nbsp;If&nbsp;you&nbsp;received&nbsp;this&nbsp;email&nbsp;message&nbsp;in&nbsp;error,&nbsp;please&nbsp;notify&nbsp;the&nbsp;sender&nbsp;immediately&nbsp;by&nbsp;replying&nbsp;to&nbsp;this&nbsp;e-mail&nbsp;message&nbsp;or&nbsp;by&nbsp;telephone<BR />
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 2.5 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam B 2009-05-01 22:49:49 Re: Possible to prevent transaction abort?
Previous Message Tomas Vondra 2009-05-01 22:28:03 Re: 08P01: unexpected EOF on client connection