Re: pl/pgsql and Transaction Isolation - Mailing list pgsql-performance

From Tom Lane
Subject Re: pl/pgsql and Transaction Isolation
Date
Msg-id 25924.1086668975@sss.pgh.pa.us
Whole thread Raw
In response to pl/pgsql and Transaction Isolation  (Marcus Whitney <marcus@coldfeetcreative.com>)
Responses Re: pl/pgsql and Transaction Isolation  (Marcus Whitney <marcus@coldfeetcreative.com>)
List pgsql-performance
Marcus Whitney <marcus@coldfeetcreative.com> writes:
>   I have an instance where I have a series of pl/pgsql calls, that report stat
> results to a common table.  When other queries try to hit the stat table
> (with DML commands; SELECT, INSERT, UPDATE, DELETE etc.) they are forced to
> wait in a queue until the pl/pgsql has finished executing.

This is quite hard to believe, unless your pl/pgsql is doing something
as unfriendly as LOCKing the table.

Do you want to post a more complete description of your problem?

            regards, tom lane

pgsql-performance by date:

Previous
From: Duane Lee - EGOVX
Date:
Subject: Re: is it possible to for the planner to optimize this
Next
From: Tom Lane
Date:
Subject: Re: Join slow on "large" tables