Re: Reducing Transaction Start/End Contention

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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +