Postgres Pro
Downloads
Home   >   mailing lists

Error when clustering a table - Mailing list pgsql-admin

From Benjamin Krajmalnik
Subject Error when clustering a table
Date
Msg-id F4E6A2751A2823418A21D4A160B68988613A41@fletch.stackdump.local
Whole thread Raw
Responses Re: Error when clustering a table  ("Benjamin Krajmalnik" <kraj@illumen.com>)
List pgsql-admin
Tree view

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?

pgsql-admin by date:

Previous
From: David Schnur
Date:
Subject: Re: VACUUM FULL memory requirements
Next
From: "Benjamin Krajmalnik"
Date:
Subject: Re: Error when clustering a table