Re: Improving backend launch time by preloading relcache - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Improving backend launch time by preloading relcache
Date
Msg-id 11584.1012280809@sss.pgh.pa.us
Whole thread Raw
In response to Re: Improving backend launch time by preloading relcache  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List 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 by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Improving backend launch time by preloading relcache
Next
From: Hiroshi Inoue
Date:
Subject: Re: Improving backend launch time by preloading relcache