admin管理员组文章数量:1359375
Postgresql: Add auto script to ANALYZE one of our table (get change frequently)
ANALYZE (SKIP_LOCKED ) MyTable;
However it still sometimes report WARNING: ODBC error. SQLSTATE: 55P03 --- lock not available. I suppose after add SKIP_LOCKEd option to the statement, it will skip these locked tables but it looks not work as expected.. any suggestion?
本文标签:
版权声明:本文标题:postgresql - ANALYZE (SKIP_LOCKED ) MyTable; still face warning : ODBC error. SQLSTATE: 55P03 --- lock not available - Stack Ove 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1743895323a2557678.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论