Re: In 7.3.1, will I be able to reindex toast? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: In 7.3.1, will I be able to reindex toast?
Date
Msg-id 200302142135.h1ELZxU08143@candle.pha.pa.us
Whole thread Raw
In response to Re: In 7.3.1, will I be able to reindex toast?  (Jeffrey Baker <jwbaker@acm.org>)
List pgsql-general
Jeffrey Baker wrote:
> On Fri, Feb 14, 2003 at 04:05:12PM -0500, Bruce Momjian wrote:
> >
> > I see in the 7.3 release notes:
> >
> >    Allow REINDEX of TOAST tables (Tom)
>
> Thank you Bruce, I mentioned that in my opening email.  The
> question is, does it *actually* work, and if so how do you
> invoke it.  Demonstrably, you cannot invoke reindex on an
> actual toast table, because it fails with an error.
>
> So you invoke REINDEX on your user table and the TOAST is
> automatically reindexed as well?

No, TOAST tables have to be reindexes separately.  It does require an
exclusive lock.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: In 7.3.1, will I be able to reindex toast?
Next
From: Jeff Eckermann
Date:
Subject: Re: "iscachable" functions