Re: Improving backend launch time by preloading relcache

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: Improving backend launch time by preloading relcache
Дата
Msg-id 3C58B162.70E9C6A8@tpf.co.jp
обсуждение исходный текст
Ответ на Re: Improving backend launch time by preloading relcache  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
Ответы Re: Improving backend launch time by preloading relcache  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> 
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > Anyway there seems no point on changing REINDEX.
> > The only thing I have to do is to remove the needless
> > check in tcop/utility.c as soon as 7.2 is released.
> 
> I don't believe it's needless, and I suggest you not remove it,
> until we do something about making the pg_internal unlink happen
> at the right time.  With the unlink where it is, I think it's quite
> unsafe to reindex system indexes in a live database.

Currently there are just a few relations info kept in
pg_internal.init and they are all nailed. I'm not
allowing REINDEX for nailed relations though there's
a #ifdef'd trial implementation. I'm intending the
change for 7.2.1 not 7.3. If it isn't allowed in 7.2.x
I would strongly object to the 7.2 release itself.

regards,
Hiroshi Inoue


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: RFD: schemas and different kinds of Postgres objects
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Improving backend launch time by preloading relcache