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?

本文标签: