On Tue, Mar 01, 2005 at 04:57:11PM -0500, Tom Lane wrote:
> Mark Wong <markw(at)osdl(dot)org> writes:
> > About a 6% increase, but if you look at the performance over time,
> > it's degrading steadily.  The latter throughput peaks near 5000.
> 
> Curious.  The immediate question is "does it ever flatten out, and
> if so at what TPM rate compared to 8.0.1?"  Could you run the same
> test for a longer duration?

The comparison was against 8.0.1, or did you mean 8.0.1 with the 2Q
patch?  I can run a longer duration and see how it looks.

> Also, I suppose the large spike at 30 minutes is from a checkpoint?

Yes, checkpoint_timeout is set to 1800 seconds.

Mark

In response to

• Re: 8.0.X and the ARC patent at 2005-03-01 21:57:11 from Tom Lane

Responses

• Re: 8.0.X and the ARC patent at 2005-03-01 22:17:07 from Tom Lane

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2005-03-01 22:13:06
	Subject: Re: [HACKERS] snprintf causes regression tests to fail
Previous:	From: Nicolai Tufar	Date: 2005-03-01 21:59:10
	Subject: Re: [HACKERS] snprintf causes regression tests to fail