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

From Tom Lane
Subject Re: In 7.3.1, will I be able to reindex toast?
Date
Msg-id 28549.1045423753@sss.pgh.pa.us
Whole thread Raw
In response to Re: In 7.3.1, will I be able to reindex toast?  (Mario Weilguni <mweilguni@sime.com>)
List pgsql-general
Mario Weilguni <mweilguni@sime.com> writes:
> Am Samstag, 15. Februar 2003 16:49 schrieb Tom Lane:
>> It might be sufficient to insist on standalone reindexing just for the
>> three or four tables that have nailed-in-cache indexes.  I'm not sure
>> though.  Hiroshi, what do you think?

> And what about adding a column "indissystem" to pg_index and setting this to true for system indexes, false
otherwise? 
> Then there would be no need to hardwire the reindex logic.

If the nailed-in-cache property is what matters, then we need to look at
that, not at some boolean column that might or might not agree with it.
I'm not entirely sure what does matter here, though.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Index not used with IS NULL
Next
From: Tom Lane
Date:
Subject: Re: Aggregates with non-commutative transition functions