Re: [GENERAL] Future of PostgreSQL

On Sun, 26 Dec 1999, Howie wrote:

> On Sat, 25 Dec 1999, Bruce Momjian wrote:
>
> > >
> > >
> > > On Sat, 25 Dec 1999, Bruce Momjian wrote:
> > > > My big question is, what new challenges will we face as
> > > > we become more popular?
> > >
> > > Plug-in Oracle 7 compatibility.
> >
> > I believe we are adding Oracle compatibility as possible. We are
> > working on write-ahead log, long tuples, foreign keys, and outer joins.
> > Anything else?
>
> tablespace support ( which isnt a trivial task ), groups ( pgsql has this
> sort of functionality already, but i dont think its to the extent that
> Oracle does ), some additional grants ( 'grant connect to' ), 'alter table
> <table> add constraint <constraint definition>'...
>
> tablespace support would put pgsql soooo far ahead of most other rdbmses.

Yes. A tablespace is good feature for robus SQL engine. And (IMHO):

- raw i/o device storage manager
- replication
- privilege for columns, lock
- better speed, speed ... and speed :-)
- on-the-fly backup (from any logs)

Karel