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

[Tatsuo Ishii]

>> According to the log there's something wrong going onb the master
>> PostgreSQL(deadlock?) I think it's not related to pgpool-II. Can you
>> find something related to the problem in the PostgreSQL log?
> 
> Not really - although internet search for "postgres deadlock detected
> reindex" shows quite a bit of hits - so I guess that would depend on
> database usage.

Ok.

> Putting the question the other way: is REINDEX TABLE safe, if made
> directly on database backends, without going through pgpool? As I
> understand, it does not change database data visible to the clients,
> so should be safe.

Yes, doing REINDEX directly is safe.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp