Re: 8.0.X and the ARC patent - Mailing list pgsql-hackers

From Mark Wong
Subject Re: 8.0.X and the ARC patent
Date
Msg-id 20050301220642.GA3383@osdl.org
Whole thread Raw
In response to Re: 8.0.X and the ARC patent  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 8.0.X and the ARC patent
List pgsql-hackers
On Tue, Mar 01, 2005 at 04:57:11PM -0500, Tom Lane wrote:
> Mark Wong <markw@osdl.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.0.X and the ARC patent
Next
From: "Joshua D. Drake"
Date:
Subject: logging as inserts