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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Kirkwood <markir(at)slingshot(dot)co(dot)nz>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org, Andrew Sullivan <andrew(at)libertyrms(dot)info>
Subject: Re: Free space mapping (was Re: Multi-Versions and Vacuum)
Date: 2002-08-29 13:29:38
Message-ID: 25527.1030627778@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christian Imbeault 2002-08-29 13:39:24 BUG?: timestamp without TZ created as timestamp *with* TZ
Previous Message Johan Fredrik Øhman 2002-08-29 12:54:34 Postgresql data designer