[Pgpool-general] one of backends kicked after "VACUUM ANALYZE"

[Tatsuo Ishii]

>> I thought REINDEX is not performed under heavy load because it holds
>> strong lock.
> 
> My usage case would be using REINDEX TABLE periodically, as described
> here:
> 
> http://www.postgresql.org/docs/8.3/static/routine-reindex.html
> 
> 
> Of course it would be done during the least load, but in theory, a
> deadlock can still happen.

Why don't you use an explicit transatcion plus lock to avoid deadlock
for the first place?

BEGIN;
LOCK TABLE
REINDEX TABLE 
END;
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp