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

Поиск
Список
Период
Сортировка
От Raphael Bossek
Тема Re: PostgreSQL Lite for low-end/embedded systems (16MB of total memory)
Дата
Msg-id 20020630182208.GA17830@mars
обсуждение исходный текст
Ответ на Re: PostgreSQL Lite for low-end/embedded systems (16MB of total memory)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade
Следующее
От: Tom Lane
Дата:
Сообщение: Re: One source of constant annoyance identified