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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: In 7.3.1, will I be able to reindex toast?
Дата
Msg-id 28549.1045423753@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: In 7.3.1, will I be able to reindex toast?  (Mario Weilguni <mweilguni@sime.com>)
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Index not used with IS NULL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Aggregates with non-commutative transition functions