Dave Cramer wrote: > reindex table user_profile; > ERROR: deadlock detected > DETAIL: Process 32450 waits for AccessExclusiveLock on relation > 194689112 of database 163880909; blocked by process 31236. > Process 31236 waits for AccessShareLock on relation 194689110 of > database 163880909; blocked by process 32450.
I don't find this very surprising ... I would suggest using "reindex index" for each index instead. I'm not sure if REINDEX TABLE is supposed to be deadlock-free. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly