does reindex need exclusive table access?

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: does reindex need exclusive table access?
Date: 2011-10-31 18:51:50
Message-ID: 482E80323A35A54498B8B70FF2B8798004D5BD859A@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Denne 2011-10-31 22:01:19 Re: Server move using rsync
Previous Message Tom Lane 2011-10-31 18:41:49 Re: Query planner always has exactly half of the rows in the table as "plan rows" with new GIST operator class