Re: commit_delay, siblings - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: commit_delay, siblings
Date
Msg-id 1120081108.3940.32.camel@localhost.localdomain
Whole thread Raw
In response to Re: commit_delay, siblings  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, 2005-06-29 at 10:16 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > Group commit is a well-documented technique for improving performance,
> 
> The issue here is not "is group commit a good idea in the abstract?".
> It is "is the commit_delay implementation of the idea worth a dime?"
> ... and the evidence we have all points to the answer "NO".  We should
> not let theoretical arguments blind us to this.

OK, sometimes I sound too theoretical when I do my World History of
RDBMS notes, :-) ... all I meant was "lets hold off till we've measured
it".

> > I would ask that we hold off on their execution, at least for the
> > complete 8.1 beta performance test cycle.
> 
> I'm willing to wait a week while Tatsuo runs some fresh tests.  I'm
> not willing to wait indefinitely for evidence that I'm privately
> certain will not be forthcoming.

I'm inclined to agree with you, but I see no need to move quickly. The
code's been there a while now.

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Proposal: associative arrays for plpgsql (concept)
Next
From: Stephen Frost
Date:
Subject: Re: Open items