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 <marcus@coldfeetcreative.com>)
Ответы Re: pl/pgsql and Transaction Isolation  (Marcus Whitney <marcus@coldfeetcreative.com>)
Список 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 по дате отправления:

Предыдущее
От: Duane Lee - EGOVX
Дата:
Сообщение: Re: is it possible to for the planner to optimize this
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Join slow on "large" tables