Re: Improving backend launch time by preloading relcache

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Improving backend launch time by preloading relcache
Дата
Msg-id 11584.1012280809@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Improving backend launch time by preloading relcache  (Hiroshi Inoue <Inoue@tpf.co.jp>)
Список pgsql-hackers
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> The change on tcop/utility.c seems to inhibit the execution
> of REINDEX of system indexes under postmaster which I allowed
> except some system indexes in 7.1.

That strikes me as a fairly dangerous idea.  Do you really
believe it's safe?  Also, why would it be safe to allow reindex
at the table level and not at the index level, which is what
the code did before I touched it?

> Especially setNewRelfilenode() unlinks the pg_internal.init
> file in case the relation is nailed.

Probably with this change I'm planning, it'll be necessary to unlink
pg_internal.init for any system relation, not only nailed ones.
Thanks for pointing that out.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Improving backend launch time by preloading relcache
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Improving backend launch time by preloading relcache