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?