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