Simon Riggs <[EMAIL PROTECTED]> writes: > Hmmm.... I'm slightly worried that frequently-churning small tables will > be made even slower by this. What do you think?
How so? > So we would be able to cache other items also? Only to the extent that you can guarantee a stale cache entry isn't a problem. We've already done the analysis involved for the existing metapage entries, but anything else would require more thought. (And more cache flush events.) > For that case we'd save N block accesses to locate the rightmost leaf > page. Surely you mean log(N). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org