Re: PostgreSQL as a filesystem

From: "Christopher Nelson" <paradox(at)BBHC(dot)ORG>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL as a filesystem
Date: 2005-04-18 21:22:19
Message-ID: 79A4CBFE19FBA8428782AA6B5E64E27802804CC1@server3.bbhclan.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry for the misnomer. :-D Thanks for answering my question so
quickly!

> "Christopher Nelson" <paradox(at)BBHC(dot)ORG> writes:
> > I'm developing a hobby OS and I'm looking into file systems. I've
> > thought about writing my own, and that appeals, but I'm also very
> > interested in the database-as-a-filesystem paradigm. It would be
nice
> > to not have to write all of the stuff that goes into the DBMS (e.g.
> > parsers, query schedulers, etc) myself.
>
> > So I was wondering what sort of filesystem requirements Postgre has.
>
> There are DB's you could use for this, but Postgres (not "Postgre",
> please, there is no such animal) isn't one of them :-(. We really
> assume we are sitting on top of a full-spec file system --- we want
> space management for variable-size files, robust storage of directory
> information, etc.
>
> Also, the things you typically expect to do with a filesystem, such as
> drop many-megabytes files into it without blinking, don't match up
very
> well with the stuff that's fast in Postgres.
>
> Bottom line is that it'd probably be doable, but it'd be a pain and
> probably not perform real well...
>
> regards, tom lane

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Kopciuch 2005-04-18 21:29:26 Re: tsearch2
Previous Message Tom Lane 2005-04-18 21:18:38 Re: PostgreSQL as a filesystem