>> According to the log there's something wrong going onb the master >> PostgreSQL(deadlock?) I think it's not related to pgpool-II. Can you >> find something related to the problem in the PostgreSQL log? > > Not really - although internet search for "postgres deadlock detected > reindex" shows quite a bit of hits - so I guess that would depend on > database usage.
Ok. > Putting the question the other way: is REINDEX TABLE safe, if made > directly on database backends, without going through pgpool? As I > understand, it does not change database data visible to the clients, > so should be safe. Yes, doing REINDEX directly is safe. -- 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
