Re: WIP: buffer manager rewrite (take 2)

On Wed, Feb 16, 2005 at 07:50:28PM -0500, Tom Lane wrote:
> Second iteration of buffer manager rewrite. This uses the idea of a
> usage counter instead of just a recently-used flag bit. I allowed the
> counter to go up to 5, but some playing around with that value would
> be interesting. (Tweak BM_MAX_USAGE_COUNT in
> src/include/storage/buf_internals.h, then recompile the files in
> src/backend/storage/buffer/.) Also there are more GUC variables now
> for controlling the bgwriter.
>

I see a huge performance increase, when applied to CVS from 20050301.

Baseline against 8.0.1:
http://www.osdl.org/projects/dbt2dev/results/dev4-010/309/
throughput 3639.97

CVS from 20050301:
http://www.osdl.org/projects/dbt2dev/results/dev4-010/314/
throughput 5483.01
I only ran this for 30 minutes, as opposed to 60, but it looks
promising.

So about a 50% increase in throughput for my test. Not to shabby. ;)

Mark