Re: Storing hot members of PGPROC out of the band

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Storing hot members of PGPROC out of the band
Дата
Msg-id 201112170125.pBH1PpC07675@momjian.us
обсуждение исходный текст
Ответ на Re: Storing hot members of PGPROC out of the band  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Storing hot members of PGPROC out of the band  (Robert Haas <robertmhaas@gmail.com>)
Re: Storing hot members of PGPROC out of the band  (Jim Nasby <jim@nasby.net>)
Список pgsql-hackers
Robert Haas wrote:
> On that theory, I'm inclined to think that's not really a problem.
> We'll go nuts if we refuse to commit anything until it shows a
> meaningful win on every imaginable workload, and it seems like this
> can't really be worse than the status quo; any case where it is must
> be some kind of artifact.  We're better of getting rid of as much
> ProcArrayLock contention as possible, rather than keeping it around
> because there are corner cases where it decreases contention on some
> other lock.

Interesting conclusion, and it makes sense.  Seems once this is applied
we will have more places to look for contention improvements.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: JSON for PG 9.2
Следующее
От: Robert Haas
Дата:
Сообщение: Re: JSON for PG 9.2