Not sure about PG in that environment. Have you thought about something like H2 java database? https://www.h2database.com/html/main.html
That is included as the standarDB in a vehicle tracking system we use, although we have re[placed with PG. On Mon, 5 Oct 2020 at 11:20, Thorsten Schöning <tschoen...@am-soft.de> wrote: > Hi all, > > TL;DR: > > Does anyone actually use Postgres with ARM based low performance > hardware and only 256 MiB of RAM? What are your experiences in other > stripped down environments? Is there some lower RAM limit with which > using Postgres doesn't make any sense anymore? Is Postgres able to > compete with SQLite regaridng lower performance boundaries or is there > some point at which SQLite will be the better choice, because Postgres > needs some more resources to work properly? > > Thanks! > > Background: > > I have some server side backend exposing web services and storing data > in Postgres. The stored data are telegrams from smart metering > devices, lots of them, mostly small. The provided web services take > care of generating reports etc. based on those telegrams. > > It's now considered to put large parts of that backend onto some ARM > based IoT device, simply because that device would do a lot of the > same things. The available backend is Java-based, so it would simply > be possible as well and I already ran things on some Raspi-like > hardware and things worked pretty well. OTOH, the targetted hardware > is less capable than some Raspi, we talk about only 256 MiB of RAM > currently. The exact details of the hardware are not clear yet. > > In the easiest case, the newly created device would only need to store > some hundreds of telegrams per day in some known time window and > forward those telegrams afterwards. In most cases it would be those of > the same day only, but might be those of the last X few days as well > in case of problems. In the long term, though, that device should be > able to store telegrams for years and might generate reports on it's > own as well. > > I've already found some interesting infos like the following, but > would be interested in other expereinces as well. > > > https://www.postgresql.eu/events/pgconfeu2019/sessions/session/2781/slides/251/PostgreSQL%20for%20IoT.pdf > > Mit freundlichen Grüßen, > > Thorsten Schöning > > -- > Thorsten Schöning E-Mail: thorsten.schoen...@am-soft.de > AM-SoFT IT-Systeme http://www.AM-SoFT.de/ > > Telefon...........05151- 9468- 55 > Fax...............05151- 9468- 88 > Mobil..............0178-8 9468- 04 > > AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln > AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow > > > >
