Horton
Menu

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mark Kirkwood <markir@slingshot.co.nz>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, pgsql-general@postgresql.org, Andrew Sullivan <andrew@libertyrms.info>
Date: 2002-08-29T13:29:38Z
Lists: pgsql-general 
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