Re: Lock contention during inserts

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Lock contention during inserts
Дата
Msg-id 5691.1150857779@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Lock contention during inserts  ("Carlos H. Reimer" <carlosreimer@terra.com.br>)
Список pgsql-general
"Carlos H. Reimer" <carlosreimer@terra.com.br> writes:
> During mass inserts, we have some locking contention in tables referenced by
> foreign keys. It�s a 8.0.3 box
> and I know that 8.1 solved this but I would like to know if there is an easy
> and safe way to only apply this patch to 8.0.3?

If it were a simple fix it would have been fixed many versions ago.
Update to 8.1.

            regards, tom lane

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

Предыдущее
От: "Carlos H. Reimer"
Дата:
Сообщение: Lock contention during inserts
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: multiple statement 'instead of' rule