Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> Hmmm.... I'm slightly worried that frequently-churning small tables will
> be made even slower by this. What do you think?
> 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
Surely you mean log(N).
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Simon Riggs||Date: 2006-04-26 17:29:13|
|Subject: Re: Avoiding redundant fetches of btree index metapages|
|Previous:||From: Gevik Babakhani||Date: 2006-04-26 16:48:15|
|Subject: Regarding TODO item "%Add a separate TRUNCATE permission"|