On Thu, Oct 11, 2001 at 09:08:51AM -0400, Henning Follmann mentioned:
> > I don't know it's architecture too well, though even with a very small
> > database, it seems to use a huge number of files, which are all quite
> > large, for the small amount of information in it.
> Well, this is not for what postgres was designed for.
> For embedded systems you are looking for databases that are optimised
> for running completely in memory. Also a SQL engine is maybe not well
> suited for embedded devices.
Well, these days "embedded" means a lot more than 64k of RAM...
I was hoping to be able to run a full RDBMS from a RAM disk. Though,
postgres seems to have the strange idea of a new file for each update.
This seems to chew through disk space.
As well as tuning for massive systems, can you tune it to a small system?
> Better would be databases like Berley DB or GDBM. They are though not
> comparable to RDBMS like postgres, etc...
Indeed. We are using TDB at the moment; nice, small...but it doesn't
quite support joins or triggers :)
John
--
_______________________________________
John Looney Chief Scientist
a n t e f a c t o t: +353 1 8586004
www.antefacto.com f: +353 1 8586014
