Обсуждение: Lock contention during inserts

Поиск
Список
Период
Сортировка

Lock contention during inserts

От
"Carlos H. Reimer"
Дата:
Hello,

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?

Reimer


Re: Lock contention during inserts

От
Tom Lane
Дата:
"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