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>, 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 15:57:53
Message-ID: 8092.1030636673@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I said:
> 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.)

REINDEX did think that. CVS tip doesn't think it anymore ;-)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Brannen 2002-08-29 15:58:30 Re: [Pgreplication-general] Master/Slave is in town!
Previous Message Patrick FICHE 2002-08-29 15:42:55 Re: join problem or maybe group :(