Re: Reducing Transaction Start/End Contention

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reducing Transaction Start/End Contention
Дата
Msg-id 25697.1185897959@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reducing Transaction Start/End Contention  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Reducing Transaction Start/End Contention
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Simon Riggs wrote:
>> 1. Increase size of Clog-specific BLCKSZ

>> 2. Perform ExtendClog() as a background activity

>> (1) and (2) can be patched fairly easily for 8.3. I have a prototype
>> patch for (1) on the shelf already from 6 months ago.

> Hmm, I think (1) may be 8.3 material but all the rest are complex enough
> that being left for 8.4 is called for.

NONE of this is 8.3 material.  Full stop.  Try to keep your eyes on the
ball people --- 8.3 is already months past feature freeze.

I don't even think that Simon has made a case that #1 is a good idea.
Increasing the page size will increase contention between transactions
trying to hit the same clog page, no?
        regards, tom lane


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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Machine available for community use
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Machine available for community use