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
Hi, this query on TPCH 1G data gets about 5% improvement.
select count (*) from (select l_orderkey, l_partkey, l_comment,
count(l_tax) from lineitem group by 1, 2, 3) tmpt;
Regards,
-cktan
On Oct 28, 2007, at 1:17 PM, Luke Lonergan wrote:
We just applied this and saw a 5 percent speedup on a
