Re: Firebird 1.0 released

From: Denis Perchine <dyp(at)perchine(dot)com>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Firebird 1.0 released
Date: 2002-04-16 11:14:17
Message-ID: 200204160714.17453.dyp@perchine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 segmented key. Prefix compression removes the
leading bytes that match the previous key. Thus a duplicate value has no key
stored at all. Dense storage in indexes minimizes the depth of the btrees,
eliminating the advantage of other index types for most data.

Do we do this? How feasible is this?

On Tuesday 16 April 2002 00:35, Christopher Kings-Lynne wrote:
> 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.

--
Denis

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-04-16 11:32:12 Re: [HACKERS] YADP - Yet another Dependency Patch
Previous Message Tatsuo Ishii 2002-04-16 10:41:58 Re: multibyte support by default