Re: In 7.3.1, will I be able to reindex toast?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mario Weilguni <mweilguni(at)sime(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: In 7.3.1, will I be able to reindex toast?
Date: 2003-02-16 19:29:13
Message-ID: 28549.1045423753@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mario Weilguni <mweilguni(at)sime(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-16 19:36:09 Re: Aggregates with non-commutative transition functions
Previous Message Stephan Szabo 2003-02-16 18:12:45 Re: Index not used with IS NULL