> > My script doesn't really lock anything, it must just be a natural
> > side-effect of the REINDEX command,
>
> According to
>
>
<http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/locking-tables.
html>
>
> CREATE INDEX gets a ShareLock. Which will block UPDATE, DELETE and
> INSERT. So, not _quite_ as bad as VACUUM FULL, but not something to
> do in the middle of a busy day.
During the REINDEX-run I see plenty "SELECT (waiting)" with ps. So I can
confirm this.
Greetings,
Bjoern