Re: Proposal: replace no-overwrite with Berkeley DB

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Benjamin Adida <ben(at)mit(dot)edu>, "Michael A(dot) Olson" <mao(at)sleepycat(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Proposal: replace no-overwrite with Berkeley DB
Date: 2000-05-15 19:55:08
Message-ID: 200005151955.PAA22495@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> If we go into this at all, we'd certainly *not* want to take the
> attitude that Berkeley DB is a closed box that we don't get to mess
> with. It's open source and we'd be contributing improvements to it,
> probably some pretty major ones. In effect we'd become partners with
> the Sleepycat guys --- and so another big issue is how comfortable we
> would be working together. But it could be a win-win proposition if
> we join forces to produce better software than either group could do
> alone.

Another option is to keep our heap table structure intact, and just
Sleepycat DB for our indexes. That may be a big win, with little
downside. Certainly something to think about. It may work better with
MVCC, and allow fast sequential scans and fast heap access from the
indexs, without having to go through the db structures to get to it.

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Mikheev, Vadim 2000-05-15 20:23:29 RE: WAL versus Postgres (or: what goes around, comes ar ound)
Previous Message Tom Lane 2000-05-15 19:50:03 Re: type conversion discussion