> -----Original Message----- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > > Alexander Loginov <[EMAIL PROTECTED]> writes: > > I have only one small question. Can I do REINDEX during inserting > > of information into tables. Or I must block somehow updating of > > tables. > > Hmmm ... it looks like REINDEX only grabs AccessShareLock on the target > relation, which seems very wrong.
Sorry I couldn't find where AccessShareLock is grabbed now. AccessExclusiveLock is acquired in reindex_index but do you mean it's too late ? regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
