Re: Free space mapping (was Re: Multi-Versions and Vacuum) - Mailing list pgsql-general

From Tom Lane
Subject Re: Free space mapping (was Re: Multi-Versions and Vacuum)
Date
Msg-id 25527.1030627778@sss.pgh.pa.us
Whole thread Raw
In response to Re: Free space mapping (was Re: Multi-Versions and Vacuum)  (Mark Kirkwood <markir@slingshot.co.nz>)
Responses Re: Free space mapping (was Re: Multi-Versions and Vacuum)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Securing sensitive information
Next
From: Jean-Christian Imbeault
Date:
Subject: BUG?: timestamp without TZ created as timestamp *with* TZ