DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=hWSZTB9xTPg9PcI6ERHRoF5auv9p0QgszgRtsG1/oDN2g5YROhhFMDEhZ2bl4PQTnTpueahwmlhsxMFmpJQWw0pLnrmg3U/C9slXq1d0uzIkmvZxFwznds2UguHJhcAahLh+chHa01WbBbUTozbcAURVthw+uk/3WUbJ1js0jSU=
	;
Message-ID: <20061028160550.13511.qmail@web38906.mail.mud.yahoo.com>
Date: Sat, 28 Oct 2006 09:05:50 -0700 (PDT)
From: Brett Schwarz <brett_schwarz@yahoo.com>
Subject: Re: pg_exec commit causes extremely long delays
To: Carlo Stonebanks <stonec.register@sympatico.ca>,
	pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=ascii
Content-Transfer-Encoding: quoted-printable

I do something similiar, but I don't see these delays. Do you have more det=
ails about your circumstance? pgtcl version, PG version, how big the table =
is, what kind of processing is being done in the script, etc. Have you trie=
d simply debugging in the script to see where the bottleneck may lay? For e=
xample, doing a simply puts with clock at various points in the script.=0A =
=0A--brett=0A=0A----- Original Message ----=0AFrom: Carlo Stonebanks <stone=
c.register@sympatico.ca>=0ATo: pgsql-interfaces@postgresql.org=0ASent: Tues=
day, October 24, 2006 6:10:55 PM=0ASubject: [INTERFACES] pg_exec commit cau=
ses extremely long delays=0A=0AI have a TCL app which has severe delays - m=
easured in tens of minutes at =0Aleast - running "pg_exec $conn "commit".=
=0A=0AThe delays are so long that I used to think the app was hopelessly fr=
ozen. =0ABy accident, I left the app alone in its frozen state and came bac=
k a good =0Aeal later and seen that it was running again. The application l=
oops through =0Aan import file, reading one row at a time, and issues a bun=
ch of inserts and =0Aupdates to various tables. There's a simple pg_exec $c=
onn "start =0Atransaction" at the beginning of the loop and the commit at t=
he end.=0A=0AThere are a minimum of four apps running at the same time, all=
 reading =0Adifferent sections of the same table, all writing to the same d=
b and the =0Asame tables. The other apps seem unaffected by the one app tha=
t freezes.=0A=0AAny thoughts on the cause and possible solutions would be a=
ppreciated.=0A=0ACarlo =0A=0A=0A=0A---------------------------(end of broad=
cast)---------------------------=0ATIP 6: explain analyze is your friend=0A=
=0A=0A=0A=0A