Re: pl/pgsql and Transaction Isolation

От: Tom Lane
Тема: Re: pl/pgsql and Transaction Isolation
Дата: ,
Msg-id: 25924.1086668975@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: pl/pgsql and Transaction Isolation  (Marcus Whitney)
Ответы: Re: pl/pgsql and Transaction Isolation  (Marcus Whitney)
Список: pgsql-performance

Marcus Whitney <> 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 по дате сообщения:

От: Manfred Koizar
Дата:
Сообщение: Re: Use of Functional Indexs and Planner estimates
От: Marcus Whitney
Дата:
Сообщение: Re: pl/pgsql and Transaction Isolation