Postgres Pro
Downloads
Home   >   mailing lists

does reindex need exclusive table access? - Mailing list pgsql-general

From Gauthier, Dave
Subject does reindex need exclusive table access?
Date
Msg-id 482E80323A35A54498B8B70FF2B8798004D5BD859A@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: does reindex need exclusive table access?
List pgsql-general
Tree view

v8.3.4 on linux.

 

Does "reindex table foo" require no other users accessing the foo table?  Trying to understand why this seems to be stalled when I attempt this on a live DB (if runs fine/fast on a copy of the DB that no one uses).

 

Should I run this inside a transaction?

 

Thanks in Advance !  

pgsql-general by date:

Previous
From: Tarlika Elisabeth Schmitz
Date:
Subject: Re: [PL/pgSQL] function call
Next
From: Bill Thoen
Date:
Subject: Need Help With a A Simple Query That's Not So Simple