Postgres Pro
Downloads
Home   >   mailing lists

Re: Lock contention during inserts - Mailing list pgsql-general

From Tom Lane
Subject Re: Lock contention during inserts
Date
Msg-id 5691.1150857779@sss.pgh.pa.us
Whole thread Raw
In response to Lock contention during inserts  ("Carlos H. Reimer" <carlosreimer@terra.com.br>)
List pgsql-general
Tree view 
"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 by date:

Previous
From: "Carlos H. Reimer"
Date:
Subject: Lock contention during inserts
Next
From: "Merlin Moncure"
Date:
Subject: multiple statement 'instead of' rule