Re: Reducing Transaction Start/End Contention

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Reducing Transaction Start/End Contention
Дата
Msg-id 200709140359.l8E3xNl20766@momjian.us
обсуждение исходный текст
Ответ на Re: Reducing Transaction Start/End Contention  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Reducing Transaction Start/End Contention  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Reducing Transaction Start/End Contention  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera wrote:
> 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.

Please confirm, all of Simon's issues?
http://archives.postgresql.org/pgsql-hackers/2007-07/msg00948.php

---------------------------------------------------------------------------


> 
> > ---------------------------------------------------------------------------
> > 
> > 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: PGparam extension version 0.4
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: SQL feature requests