Re: PostgreSQL as a filesystem - Mailing list pgsql-general

From Christopher Nelson
Subject Re: PostgreSQL as a filesystem
Date
Msg-id 79A4CBFE19FBA8428782AA6B5E64E27802804CC1@server3.bbhclan.org
Whole thread Raw
In response to PostgreSQL as a filesystem  ("Christopher Nelson" <paradox@BBHC.ORG>)
Responses Re: PostgreSQL as a filesystem  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Sorry for the misnomer.  :-D Thanks for answering my question so
quickly!

> "Christopher Nelson" <paradox@BBHC.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

pgsql-general by date:

Previous
From: "Andy Kopciuch"
Date:
Subject: Re: tsearch2
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL as a filesystem