Error when clustering a table

From: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Error when clustering a table
Date: 2009-12-14 19:17:22
Message-ID: F4E6A2751A2823418A21D4A160B68988613A41@fletch.stackdump.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 in
pg_toast_145099

SQL state: XX000

Any idea how this can be remediated?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2009-12-14 19:27:55 Re: Error when clustering a table
Previous Message David Schnur 2009-12-14 19:14:58 Re: VACUUM FULL memory requirements