Re: Proposal: replace no-overwrite with Berkeley DB - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Proposal: replace no-overwrite with Berkeley DB
Date
Msg-id 200005151955.PAA22495@candle.pha.pa.us
Whole thread Raw
In response to Re: Proposal: replace no-overwrite with Berkeley DB  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: type conversion discussion
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: WAL versus Postgres (or: what goes around, comes ar ound)