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
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 |