Re: pgSql Memory footprint - Mailing list pgsql-general

From Tom Lane
Subject Re: pgSql Memory footprint
Date
Msg-id 29479.1063776293@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgSql Memory footprint  (Ish Ahluwalia <ahluwalia@erinc.com>)
List pgsql-general
Ish Ahluwalia <ahluwalia@erinc.com> writes:
> Thanks for the resply.  We're looking to use pgSql in a embedded systems
> environment especially for a telecom switch.  Memory may not be that big
> of a issue as we plan to have a reasonable size flash and decent RAM too
> (64 to 128 Mb - which is a lot for embedded systems).  The idea here is
> to use the database as a way to store information for all the processes
> that may be running.

You'd probably be happier with something like Berkeley DB.  PG isn't
really designed for that sort of thing --- just to start with, you don't
want to point it at flash RAM as "disk" storage, because your flash RAM
life expectancy of ~10000 write cycles won't last long.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: State of Beta 2
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Idea for improving speed of pg_restore