Horton

Re: Seq scans roadmap

Heikki Linnakangas <heikki@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki@enterprisedb.com>
To: Luke Lonergan <LLonergan@greenplum.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>, Simon Riggs <simon@enterprisedb.com>, Zeugswetter Andreas ADI SD <ZeugswetterA@spardat.at>, "CK.Tan" <cktan@greenplum.com>, Jeff Davis <pgsql@j-davis.com>
Date: 2007-05-15T09:42:28Z
Lists: pgsql-hackers 
Luke Lonergan wrote:
> 32 buffers = 1MB with 32KB blocksize, which spoils the CPU L2 cache
> effect.
> 
> How about using 256/blocksize?

Sounds reasonable. We need to check the effect on the synchronized 
scans, though.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com