Re: transaction blocking inserts in postgresql 7.3 - Mailing list pgsql-general

From Chris Hutchinson
Subject Re: transaction blocking inserts in postgresql 7.3
Date
Msg-id IDEOKBCDGGIDOBADNGAPOECGDHAA.chris@hutchinsonsoftware.com
Whole thread Raw
In response to Re: transaction blocking inserts in postgresql 7.3  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Responses Re: transaction blocking inserts in postgresql 7.3  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
Thanks to everyone for their suggestions on dealing with inserts blocked by
index locking.

My eventual solution was to remove the REFERENCES constraints on the
affected tables and move referential integrity into the application - not
ideal, but faster to implement than the alternatives.

Suggested solutions were:
* Load file into temporary table, and insert into primary table from
temporary (Dennis Gearon, David Olberson)
* Convert data to insert statements and (I think) run each in a separate
transaction (Jeff Eckerman)


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Bug in contrib/intagg int_array_enum() ?
Next
From: Jonathan Bartlett
Date:
Subject: Re: About OIDs