Re: Improving backend launch time by preloading relcache

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Improving backend launch time by preloading relcache
Дата
Msg-id 3C564CB6.8E4A0389@tpf.co.jp
обсуждение исходный текст
Ответ на Improving backend launch time by preloading relcache  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Improving backend launch time by preloading relcache
Список pgsql-hackers
Tom Lane wrote:
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > REINDEX uses the relfilenode mechanism since 7.1 which
> > lets the replacement of index files be under transactional
> > control. I think it's safe enough.
> 
> Okay, in that case tcop/utility is being too picky about all three
> cases, no?

Probably we don't have to keep the relhasindex info in the
db any longer and we had better keep some info about REINDEX
in memory local to the backend. In fact in the current
implementation the relhasindex is local to the backend
and any backend couldn't see the column committed to
the status off. 

> Hmm ... what that says is that unlinking pg_internal.init in
> setRelfilenode is the wrong place.

Possibly. I couldn't find the appropriate place(way) then
and so #ifdef's are still there.

regards,
Hiroshi Inoue


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

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: RFD: schemas and different kinds of Postgres objects
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: sequence indexes