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

Tatsuo Ishii ishii at sraoss.co.jp
Sat May 14 11:19:10 UTC 2011


> On 14.05.2011 11:13, Tatsuo Ishii wrote:
>> This is repeated asked question. See discussion:
>> http://lists.pgfoundry.org/pipermail/pgpool-general/2011-February/003460.html
>>
>> Bottom line is, "you should not execute VACUUM via pgpool. Connect
>> PostgreSQL directry and execute VACUUM".
> 
> Thank you.

You are welcome.

> Are there any other commands which should not be executed through
> pgpool? For example, is REINDEX TABLE safe to execute through pgpool?

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


More information about the Pgpool-general mailing list