Re: PostgreSQL Lite for low-end/embedded systems (16MB of total memory) - Mailing list pgsql-general

From Raphael Bossek
Subject Re: PostgreSQL Lite for low-end/embedded systems (16MB of total memory)
Date
Msg-id 20020630182208.GA17830@mars
Whole thread Raw
In response to Re: PostgreSQL Lite for low-end/embedded systems (16MB of total memory)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> Define your terms, please.  Is that 16M of RAM, or disk space?
RAM. 16MB for disk space would be a overkill for PostgreSQL I
think, you too :)

> How much of it is actually available for Postgres, as opposed
> to other stuff?
5MB of RAM

> What is the OS (ie, do you have a porting problem as well as a
> space problem)?
Linux 2.4.3 (libc 2.2.5) for PowerPC

> With the default parameter settings Postgres probably doesn't need more
> than 8M of RAM.
This is true. A simple `ps` shows this values :)

My intention is to optimize this values as mutch as possible. For
our application we need user friedly respond times and swapping showed
us in the past that it can lead to unacceptable results so I try to
optimize everything could be optimized in RAM usage. New requirements
in the product lead us to look for a database so PostgreSQL could be
a solution for our further comming problems while reinventing the wheel.

So can PostgreSQL be "tuned" in this direction and where to start?

--
Raphael Bossek <raphael.bossek@gmx.de>



pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade
Next
From: Tom Lane
Date:
Subject: Re: One source of constant annoyance identified