>> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
