Strange - seems to have sorted itself out.
I turned off a scheduled vacuum of the table and within a few minutes I
sorted itself out.
I have reduced the frequency of the vacuuming task which is being
carried out via pgagent.
From: Benjamin Krajmalnik
Sent: Monday, December 14, 2009 12:28
Additional info:
When I perform a vacuum full, this is the information I am getting:
INFO: vacuuming "public.tblksaura"
INFO: "tblksaura": found 89 removable, 238907 nonremovable row versions
in 59808 pages
DETAIL: 200792 dead row versions cannot be removed yet.
Nonremovable row versi
I am trying to cluster a table for which vacuum full is not reducing its
size.
When I do so, I am getting the following error:
ERROR: missing chunk number 0 for toast value 207869115 in
pg_toast_145099
** Error **
ERROR: missing chunk number 0 for toast value 207869115
