Re: Reducing Transaction Start/End Contention

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Reducing Transaction Start/End Contention
Дата
Msg-id 20070914035219.GA12618@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Reducing Transaction Start/End Contention  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Reducing Transaction Start/End Contention  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Bruce Momjian wrote:
> 
> This has been saved for the 8.4 release:
> 
>     http://momjian.postgresql.org/cgi-bin/pgpatches_hold

I think the work on VIDs and latestCompletedXid make this completely
obsolete.

> ---------------------------------------------------------------------------
> 
> Simon Riggs wrote:
> > Jignesh Shah's scalability testing on Solaris has revealed further
> > tuning opportunities surrounding the start and end of a transaction.
> > Tuning that should be especially important since async commit is likely
> > to allow much higher transaction rates than were previously possible.
> > 
> > There is strong contention on the ProcArrayLock in Exclusive mode, with
> > the top path being CommitTransaction().


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: What is happening on buildfarm member dugong
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: PGparam extension version 0.4