Re: myProcLocks initialization

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: myProcLocks initialization
Дата
Msg-id 2719.1320030831@sss.pgh.pa.us
обсуждение исходный текст
Ответ на myProcLocks initialization  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: myProcLocks initialization
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I'd like to propose the attached patch, which initializes each
> PGPROC's myProcLocks just once at postmaster startup, rather than
> every time the PGPROC is handed out to a backend.  These lists should
> always be emptied before a backend shuts down, so a newly initialized
> backend will find the lists empty anyway.  Not reinitializing them
> shaves a few cycles.  In my testing, it saves about 1% of the cost of
> setting up and tearing down a connection, which is not a ton, but a
> cycle saved is a cycle earned.

That's not really enough to excite me, and the prospect of problems in
one session corrupting an unrelated later one is pretty scary from a
debugging standpoint.  How about at least an Assert that the lock is in
a clean state?
        regards, tom lane


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

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: myProcLocks initialization