Re: transaction blocking inserts in postgresql 7.3

From: "Chris Hutchinson" <chris(at)hutchinsonsoftware(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: transaction blocking inserts in postgresql 7.3
Date: 2003-03-27 23:10:43
Message-ID: IDEOKBCDGGIDOBADNGAPOECGDHAA.chris@hutchinsonsoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reynard Hilman 2003-03-27 23:16:56 Re: how to test whether postgres server is running?
Previous Message Greg Stark 2003-03-27 23:07:19 Re: Bug in contrib/intagg int_array_enum() ?