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