Re: missing chunk number 0 for toast value - Mailing list pgsql-general

From Ed L.
Subject Re: missing chunk number 0 for toast value
Date
Msg-id 200504271816.44050.pgsql@bluepolka.net
Whole thread Raw
In response to Re: missing chunk number 0 for toast value  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wednesday April 27 2005 6:11 pm, Tom Lane wrote:
> "Ed L." <pgsql@bluepolka.net> writes:
> > Does this shed any light?  pg_toast_6221538 is the relevant
> > toast table...
> >
> > $ psql -c "set enable_indexscan=off; select chunk_seq,
> > length(chunk_data) from pg_toast.pg_toast_6221538 where
> > chunk_id = 19319495 order by chunk_seq;"
> >  chunk_seq | length
> > -----------+--------
> > (0 rows)
>
> Doesn't look very promising :-(

Sorry...what does that mean?  Not promising that reindexing the
toast table would help because there is no data there?

Ed


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: missing chunk number 0 for toast value
Next
From: "Dann Corbit"
Date:
Subject: I must be daft, but I can't figure out what is wrong with this