On Tue, Mar 01, 2005 at 04:57:11PM -0500, Tom Lane wrote:
> Mark Wong <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
