Re: [HACKERS] Firebird 1.0 released

2002-04-16 Thread Denis Perchine
Hi, I was interested in this: Firebird's indexes are very dense because they compress both the prefix and the suffix of each key. Suffix compression is simply the elimination of trailing blanks or zeros, depending on the data type. Suffix compression is performed on each segment of a

Re: [HACKERS] Firebird 1.0 released

2002-04-16 Thread Tom Lane
Denis Perchine [EMAIL PROTECTED] writes: I was interested in this: Firebird's indexes are very dense because they compress both the prefix and the suffix of each key. Suffix compression is simply the elimination of trailing blanks or zeros, depending on the data type. Suffix compression is

Re: [HACKERS] Firebird 1.0 released

2002-04-16 Thread Richard Tucker
page splits. -regards richt -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane Sent: Tuesday, April 16, 2002 9:48 AM To: Denis Perchine Cc: Hackers Subject: Re: [HACKERS] Firebird 1.0 released Denis Perchine [EMAIL PROTECTED] writes: I

[HACKERS] Firebird 1.0 released

2002-04-15 Thread Christopher Kings-Lynne
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. http://www.ibphoenix.com/ibp_act_db.html The relevant extract: Multi-version concurrency control uses back versions of modified

Re: [HACKERS] Firebird 1.0 released

2002-04-15 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] 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