Re: Reducing Transaction Start/End Contention - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Reducing Transaction Start/End Contention
Date
Msg-id 200709140359.l8E3xNl20766@momjian.us
Whole thread Raw
In response to Re: Reducing Transaction Start/End Contention  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Reducing Transaction Start/End Contention
Re: Reducing Transaction Start/End Contention
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PGparam extension version 0.4
Next
From: Bruce Momjian
Date:
Subject: Re: SQL feature requests