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
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)