Lock contention during inserts

Started by Reimeralmost 20 years ago2 messagesgeneral
Jump to latest
#1Reimer
carlosreimer@terra.com.br

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Reimer (#1)
Re: Lock contention during inserts

"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