Re: Firebird 1.0 released

"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