Re: Firebird 1.0 released
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Cc: "Hackers" <pgsql-hackers@postgresql.org>
Date: 2002-04-16T05:11:19Z
Lists: pgsql-hackers
"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 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