Gregory Stark <[EMAIL PROTECTED]> writes: > If we find it's overkill then what we should consider doing is raising > BM_MAX_USAGE_COUNT. That's effectively tuning the percentage of the lru chain > that we decide we try to keep clean.
Yeah, I don't believe anyone has tried to do performance testing for different values of BM_MAX_USAGE_COUNT. It would be interesting to try that after all the dust settles. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match