Re: [PATCHES] Patch for seq scan & scan resistant bufmgr

2007-05-17 Thread Bruce Momjian
This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- CK Tan wrote: > Hi, > > I am submitting a patch for review that: > > 1. for small relation (smaller than 60% of buf

[PATCHES] Patch for seq scan & scan resistant bufmgr

2007-05-09 Thread CK Tan
Hi, I am submitting a patch for review that: 1. for small relation (smaller than 60% of bufferpool), use the current logic 2. for big relation: - use a ring buffer in heap scan - pin first 12 pages when scan starts - on consumption of every 4-page, read and pin the nex