X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id CAE58925070 for ; Tue, 20 May 2003 15:25:47 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 73926-08 for ; Tue, 20 May 2003 15:25:41 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id F10369251B1 for ; Tue, 20 May 2003 15:25:35 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4KJPUU6001105; Tue, 20 May 2003 15:25:30 -0400 (EDT) To: "Eric Anderson Vianet SAO" Cc: pgsql-sql@postgresql.org Subject: Re: missing chunk number 0 for toast value 32067496 In-reply-to: <009101c31ed8$e4a89ad0$0701a8c0@netterm> References: <009101c31ed8$e4a89ad0$0701a8c0@netterm> Comments: In-reply-to "Eric Anderson Vianet SAO" message dated "Tue, 20 May 2003 11:05:38 -0300" Date: Tue, 20 May 2003 15:25:29 -0400 Message-ID: <1104.1053458729@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/399 X-Sequence-Number: 13564 "Eric Anderson Vianet SAO" writes: > When I try vacuum (vacuumdb -e -f -z -v -t table -d database) it works unti= > ll certain point.=20 > so, it return=B4s the error "missing chunk for toast value 32067496" > how could i fix it? You could try reindexing the toast table associated with whichever table is getting the failure. Not sure that will help, but it's worth trying. regards, tom lane