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(at)slingshot(dot)co(dot)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
>
>
>