Thread: Embedded postgres ?
How well is postgres suited for small applications ? 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. For a database of say a megabyte, could someone take a guess at how small an installation I could get postgres down to ? 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
On Wed, 10 Oct 2001 14:18:41 +0000 (UTC), John P. Looney <john@bartender.internal.antefacto.com> wrote: > How well is postgres suited for small applications ? > > 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. Better would be databases like Berley DB or GDBM. They are though not comparable to RDBMS like postgres, etc... > > For a database of say a megabyte, could someone take a guess at how small > an installation I could get postgres down to ? > Cheers, Henning -- Henning Follmann | 8 Jane Road Tel.: +1 908 656 7061 | New Providence, NJ 07974 H.Follmann@gmx.de | USA -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
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