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

[Tomasz Chmielewski]

On 20.05.2011 17:46, Tatsuo Ishii wrote:
>>> 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;

That could be helpful, thank you.


-- 
Tomasz Chmielewski
http://wpkg.org