Re: [HACKERS] FunctionCall2 performance

2004-10-07 Thread Mark Wong
On Wed, Oct 06, 2004 at 01:27:26PM -0400, Alvaro Herrera wrote: > On Wed, Oct 06, 2004 at 10:01:42AM -0700, Mark Wong wrote: > > On Mon, Oct 04, 2004 at 02:42:43PM -0400, Greg Stark wrote: > > > Mark Wong <[EMAIL PROTECTED]> writes: > > > > > > > Links to results are here: > > > > 7.5devel - http:

Re: [HACKERS] FunctionCall2 performance

2004-10-06 Thread Alvaro Herrera
On Wed, Oct 06, 2004 at 10:01:42AM -0700, Mark Wong wrote: > On Mon, Oct 04, 2004 at 02:42:43PM -0400, Greg Stark wrote: > > Mark Wong <[EMAIL PROTECTED]> writes: > > > > > Links to results are here: > > > 7.5devel - http://www.osdl.org/projects/dbt2dev/results/dev4-010/128/ > > > 8.0beta3 - http:

Re: [HACKERS] FunctionCall2 performance

2004-10-06 Thread Mark Wong
On Mon, Oct 04, 2004 at 02:42:43PM -0400, Greg Stark wrote: > Mark Wong <[EMAIL PROTECTED]> writes: > > > Links to results are here: > > 7.5devel - http://www.osdl.org/projects/dbt2dev/results/dev4-010/128/ > > 8.0beta3 - http://www.osdl.org/projects/dbt2dev/results/dev4-010/180/ > > Are those cy

Re: [HACKERS] FunctionCall2 performance

2004-10-04 Thread Greg Stark
Mark Wong <[EMAIL PROTECTED]> writes: > Links to results are here: > 7.5devel - http://www.osdl.org/projects/dbt2dev/results/dev4-010/128/ > 8.0beta3 - http://www.osdl.org/projects/dbt2dev/results/dev4-010/180/ Are those cyclic spikes an artifact of the load of the tests? Or are they artifacts of

[HACKERS] FunctionCall2 performance

2004-10-04 Thread Mark Wong
I was comparing the oprofile results of our OLTP workload between 7.5devel and 8.0beta3 test and noticed a new FunctionCall2 in the 8.0beta3 profile that's on the top of the list for PostgreSQL. I see about an 32% decrease in overall performance. Any suggestions for determining if FunctionCall2