"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> The Firebird guys have gotten around to releasing 1.0. If you read this
> front page spiel, you'll notice that they use MVCC, but with an overwriting
> storage manager.
Yup. I've had a couple of long chats with Ann Harrison at the recent
"OSDB summit" meetings. I think we each came away enlightened about the
other implementation, but not in any large hurry to change our own.
I did steal at least one idea from her, though. (rummages in CVS logs)
ah, here's a hit:
2001-09-29 19:49 tgl
* src/backend/access/nbtree/nbtinsert.c: Tweak btree page splitlogic so that when splitting a page that is rightmost on
itstreelevel, we split 2/3 to the left and 1/3 to the new right page,rather than the even split we use elsewhere. The
ideais that whenfaced with a steadily increasing series of inserted keys (such assequence or timestamp values), we'll
endup with a btree that'sabout 2/3ds full not 1/2 full, which is much closer to the desiredsteady-state load for a
btree. Per suggestion from Ann Harrison ofIBPhoenix.
regards, tom lane