Re: [GENERAL] Perfomance decreasing

[Tom Lane]

Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> One backend would be blocked by another one because reindex_relation
> calls reindex_index and reindex_index grabs an ExclusiveLock on the
> relation.
> Am I missing anything ?

It'd be okay if you *held* the lock throughout.  Grabbing and releasing
it isn't safe IMHO.  Just for one problem, what if someone else tries
to drop the relation in one of those intervals where you're not holding
a lock?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl