PostgreSQL 異常修復紀錄
出現 ERROR: missing chunk number 0 for toast value 74185 in pg_toast_2619
主要的原因是 ANALYZE 產生的 pg_statistic 有問題, 所以將 pg_statistic 砍掉重建就可以解決 Exp. 異常 table 是 user_tokens
DELETE FROM pg_catalog.pg_statistic;
VACUUM analyze user_tokens;
參考網址
https://gist.github.com/supix/80f9a6111dc954cf38ee99b9dedf187a
https://stackoverflow.com/questions/47533639/postgres-log-file-contains-missing-chunk-number-0-for-toast-value-815441-in-pg
pgsql
,
tips