Search Postgresql Archives

Re: missing chunk number 0 for toast value

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wednesday April 27 2005 6:11 pm, Tom Lane wrote:
> "Ed L." <pgsql@xxxxxxxxxxxxx> 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


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux