Re: missing chunk number 0 for toast value

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: missing chunk number 0 for toast value
Date: 2005-04-28 00:16:43
Message-ID: 200504271816.44050.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday April 27 2005 6:11 pm, Tom Lane wrote:
> "Ed L." <pgsql(at)bluepolka(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2005-04-28 00:40:34 I must be daft, but I can't figure out what is wrong with this
Previous Message Tom Lane 2005-04-28 00:11:29 Re: missing chunk number 0 for toast value