====== PostgreSQL 異常修復紀錄 ======
===== 出現 ERROR:  missing chunk number 0 for toast value 74185 in pg_toast_2619 =====
  * 主要的原因是 ANALYZE 產生的 pg_statistic 有問題, 所以將 pg_statistic 砍掉重建就可以解決 Exp. 異常 table 是 user_tokens<cli>
DELETE FROM pg_catalog.pg_statistic;
VACUUM analyze user_tokens;
</cli>
  * 參考網址
    * 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


{{tag>pgsql tips}}