Re: CLOG Patch - Mailing list pgsql-performance

From Simon Riggs
Subject Re: CLOG Patch
Date
Msg-id 1186172987.4136.18.camel@ebony.site
Whole thread Raw
In response to CLOG Patch  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
Responses Re: CLOG Patch  ("Jignesh K. Shah" <J.K.Shah@Sun.COM>)
List pgsql-performance
On Fri, 2007-08-03 at 16:09 -0400, Jignesh K. Shah wrote:

> This patch seems to work well (both with 32 and 64 value but not with 16
> and the default 8).

Could you test at 24 please also? Tom has pointed out the additional
cost of setting this higher, even in workloads that don't benefit from
the I/O-induced contention reduction.

> Is there a way we can integrate this in 8.3?

I just replied to Josh's thread on -hackers about this.

> This will improve out of box performance quite a bit for high number of
> users (atleat 30% in my OLTP test)

Yes, thats good. Will this have a dramatic effect on a particular
benchmark, or for what reason might we need this? Tom has questioned the
use case here, so I think it would be good to explain a little more for
everyone. Thanks.

--
  Simon Riggs
  EnterpriseDB  http://www.enterprisedb.com


pgsql-performance by date:

Previous
From: "Jignesh K. Shah"
Date:
Subject: CLOG Patch
Next
From: Andrew Kroeger
Date:
Subject: Re: Performance problems with large telemetric datasets on 7.4.2