Skip site navigation (1) Skip section navigation (2)

Re: commit so slow program looks frozen

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Carlo Stonebanks" <stonec(dot)register(at)sympatico(dot)ca>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: commit so slow program looks frozen
Date: 2006-10-26 15:06:05
Message-ID: b42b73150610260806le117c55s126585ca6421cb0f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 10/26/06, Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca> wrote:
> This is pretty interesting - where can I read more on this? Windows isn't
> actually hanging, one single command line window is - from its behaviour, it
> looks like the TCL postgresql package is waiting for pg_exec to come back
> from the commit (I believe the commit has actually gone through).
>
> It could even be that there's something wrong with the TCL package, but from
> my understanding it is one of the most complete interfaces out there - which
> is weird, because TCL seems to be the most unpopular language in the
> community.

when it happens, make sure to query pg_locks and see what is going on
there lock issues are not supposed to manifest on a commit, which
releases locks, but you never know.  There have been reports of
insonsistent lock ups on windows (espeically multi-processor) which
you might be experiencing. Make sure you have the very latest version
of pg 8.1.x.  Also consider checking out 8.2 and see if you can
reproduce the behavior there...this will require compiling postgresql.

merlin

In response to

Responses

pgsql-performance by date

Next:From: Gavin HamillDate: 2006-10-26 15:06:09
Subject: Re: VACUUMs take twice as long across all nodes
Previous:From: Carlo StonebanksDate: 2006-10-26 14:48:00
Subject: Re: commit so slow program looks frozen

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group