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

[Tomasz Chmielewski]

On 20.05.2011 17:14, Tatsuo Ishii wrote:

>> In other words, I think reindexing may be not safe when pgpool is
>> used; no matter if REINDEX commands are issued through pgpool or
>> not. The more busy the database is, the more likely it is to happen
>> (of course will depend on usage patterns, database construction etc.).
>>
>> Please correct me if I'm wrong.
>
> 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.


-- 
Tomasz Chmielewski
http://wpkg.org