Search Postgresql Archives

Re: PostgreSQL as a filesystem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Sorry for the misnomer.  :-D Thanks for answering my question so
quickly!
 
> "Christopher Nelson" <paradox@xxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux