Re: Free space mapping (was Re: Multi-Versions and Vacuum)

I have run into this problem before.  Both the toast index and toast
table are considered internal objects because they begin with pg_, and
thus you can't run reindex on them directly without running a single
process server.  The workaround it to run reindex on the table that owns
the toast index/table, this will cause the toast index to also be rebuilt.

thanks,
--Barry

Tom Lane wrote:

 >Mark Kirkwood <markir@slingshot.co.nz> writes:
 >
 >
 >>With respect to the REINDEX workaround -  having to re-start your server
 >>single process for it is a bit fatal if you are  24/7 shop
 >>
 >>
 >
 >You don't have to do that for a TOAST table, do you?  It should be okay
 >to do the reindex in multiuser mode.
 >
 >(Now that I think about it, the code might think that a toast table is a
 >system table, in which case we ought to loosen the check a little.)
 >
 >
        regards, tom lane
 >
 >---------------------------(end of broadcast)---------------------------
 >TIP 6: Have you searched our list archives?
 >
 >http://archives.postgresql.org
 >
 >
 >