Postgres Pro
Downloads
Home   >   mailing lists

How to prevent vacuum and reindex from deadlocking. - Mailing list pgsql-general

From Robert Creager
Subject How to prevent vacuum and reindex from deadlocking.
Date
Msg-id 20030810145010.23e10340.Robert_Creager@LogicalChaos.org
Whole thread Raw
Responses Re: How to prevent vacuum and reindex from deadlocking.  (Robert Creager <Robert_Creager@LogicalChaos.org>)
List pgsql-general
Tree view 
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
Attachment

pgsql-general by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: dbmirror -- recovery question
Next
From: Robert Creager
Date:
Subject: 7.4Beta1 "failed to create socket: Address family not supported by protocol"