Re: Firebird 1.0 released

"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)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 split
logic so that when splitting a page that is rightmost on its tree
level, we split 2/3 to the left and 1/3 to the new right page,
rather than the even split we use elsewhere. The idea is that when
faced with a steadily increasing series of inserted keys (such as
sequence or timestamp values), we'll end up with a btree that's
about 2/3ds full not 1/2 full, which is much closer to the desired
steady-state load for a btree. Per suggestion from Ann Harrison of
IBPhoenix.

regards, tom lane