Hi All, OS: CentOS 7.6 PG: 11.11
Once we tried to vacuum full a table, got the error msg "ERROR: missing chunk number 0 for toast value", there is a doc as below for the select issue, but for our case select is no issue, what's the reason caused and how to fix this please? Thanks https://newbiedba.wordpress.com/2015/07/07/postgresql-missing-chunk-0-for-toast-value-in-pg_toast/ 1. vacuum full output: VACUUM FULL VERBOSE ANALYZE application.notes; INFO: vacuuming "application.notes" ERROR: missing chunk number 0 for toast value 183500290 in pg_toast_16977 2. explain select output: explain select * from application.notes; QUERY PLAN ------------------------------------------------------------------ Seq Scan on notes (cost=0.00..430924.43 rows=412443 width=767) Thanks and regards Sun Yi
