Postgres Pro
Downloads
Home   >   mailing lists

Re: unexpected chunk number 2 (expected 0) for toast value ... inpg_toast_18536 - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: unexpected chunk number 2 (expected 0) for toast value ... inpg_toast_18536
Date
Msg-id 20200315211828.GP467@hermes.hilbert.loc
Whole thread Raw
In response to Re: unexpected chunk number 2 (expected 0) for toast value ... in pg_toast_18536  (Jan Wieck <jan@wi3ck.info>)
List pgsql-general
Tree view 
On Sun, Mar 15, 2020 at 05:04:06PM -0400, Jan Wieck wrote:

> Have you tried to reindex the table? Toast internally forces an index scan,
> so missing index tuples or an otherwise corrupted toast index would have
> the same symptoms as toast chunks actually missing.

We sure did, but thanks for reminding.

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: unexpected chunk number 2 (expected 0) for toast value ... in pg_toast_18536
Next
From: Björn Lundin
Date:
Subject: Order by and timestamp