-----Mensaje original-----
De: Paolo Rizzi

Hi all,
recently I came across a question from a customer of mine, asking me if it would feasible to run PostgreSQL along with PostGIS on embedded hardware. They didn't give me complete information, but it should be some kind of industrial PC with a 600MHz CPU. Memory should be not huge nor small, maybe a couple of GBytes, hard disk should be some type of industrial Compact Flash of maybe 16 GBytes.

They are thinking about using this setup on-board of public buses and trams, along with a GPS receiver, for self-localization. So that when the bus or tram enters defined zones or passes near defined points, events are triggered. The database could probably be used completely read-only or almost that.


Hi Paolo,

I'm not really responding to your question. It happens that I collaborated
on a postgres/postgis based solution for public transportation and the
motive why you are trying to put the database in the embedded hardware is
puzzling to me. In this solution we used a centralized PG database, the
devices in buses captured geographical position and other business related
data and fetched it by cellular network to the central server. Calculations on position where made on the server and related events where
fetched back accordingly.

If possible, I would like to know what drives you to put a database on each
device? You dont have a wireless link on each unit?
Indeed I was as puzzled as you when they described me their idea, but I think it makes sense. The buses and trams have to be independent of the radio link because there are certain operations that have to performed at the right moment in the right place (like oiling wheels or letting down sand or salt or some other action). However they _are_ going to use a centralized server, and putting the same technology (PostgreSQL/PostGIS) both on-board and on-center, would let them simplify development, configuration and maintenance. Now that hardware is continuously getting cheaper and more powerful, moving "intelligence" on-board may be a smart move...



What performances do you think would be possible for PostgreSQL+PostGIS on such hardware???

We never considered that solution so I couldnĀ“t say.
In fact I searched the Web and found nobody that did that before :-)


Bye
Paolo


Regards,
Fernando.

Bye
Paolo




--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to