Re: TRUNCATE locking problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: TRUNCATE locking problem
Дата
Msg-id 3032.1121696556@sss.pgh.pa.us
обсуждение исходный текст
Ответ на TRUNCATE locking problem  (Joe Maldonado <jmaldonado@webehosting.biz>)
Ответы Re: TRUNCATE locking problem  (Joe Maldonado <jmaldonado@webehosting.biz>)
Список pgsql-general
Joe Maldonado <jmaldonado@webehosting.biz> writes:
> It seems that TRUNCATE is first posting a lock on the table and then
> waiting for other transactions to finish before truncating the table
> thus blocking all other operations.

That's what it's supposed to do.  If you have a problem with the length
of the delay, find the (other) transaction that's accessing the table
for too long and fix that.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: TRUNCATE locking problem
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Changes to not deferred FK in 8.0.3 to 7.4?