Michael Adler <[EMAIL PROTECTED]> writes: > Looking at the "Response Time Charts"
> 8.0.1/ARC > http://www.osdl.org/projects/dbt2dev/results/dev4-010/309/rt.html > 20050301 with 2Q patch > http://www.osdl.org/projects/dbt2dev/results/dev4-010/313/rt.html > It seems like the average response time has gone down, but the worse > case ceiling has raised about 35%. The worst cases are associated with checkpoints. I'm not sure why a checkpoint would have a greater effect on the 2Q system than an ARC system --- checkpoint doesn't request any new buffers so you'd think it'd be independent. Maybe this says that the bgwriter is less effective with 2Q, so that there are more dirty buffers remaining to be written at the checkpoint? But why? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
