How to prevent vacuum and reindex from deadlocking.

Поиск
Список
Период
Сортировка
От Robert Creager
Тема How to prevent vacuum and reindex from deadlocking.
Дата
Msg-id 20030810145010.23e10340.Robert_Creager@LogicalChaos.org
обсуждение исходный текст
Ответы Re: How to prevent vacuum and reindex from deadlocking.  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Список pgsql-general
I'm running 7.4Beta1 with pg_autovacuum.  In one of my operations which
is executed frequently, a REINDEX is done after a COPY.  Well, VACUUM's
are being executed by pg_autovacuum, and my app is loosing the deadlock.

Is there a way I can prevent this from happening?  I can obviously
acquire a LOCK before doing the REINDEX (which one?), but it looks like
this should be happening anyway by both the VACUUM and REINDEX
statements.

Help?
Rob

--
 14:38:15 up 9 days,  7:23,  4 users,  load average: 1.09, 1.10, 0.86

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Gregory S. Williamson"
Дата:
Сообщение: dbmirror -- recovery question
Следующее
От: Robert Creager
Дата:
Сообщение: 7.4Beta1 "failed to create socket: Address family not supported by protocol"