Re: transaction blocking inserts in postgresql 7.3

Поиск
Список
Период
Сортировка
От Chris Hutchinson
Тема Re: transaction blocking inserts in postgresql 7.3
Дата
Msg-id IDEOKBCDGGIDOBADNGAPOECGDHAA.chris@hutchinsonsoftware.com
обсуждение исходный текст
Ответ на Re: transaction blocking inserts in postgresql 7.3  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Ответы Re: transaction blocking inserts in postgresql 7.3
Список 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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Bug in contrib/intagg int_array_enum() ?
Следующее
От: Jonathan Bartlett
Дата:
Сообщение: Re: About OIDs