PostgreSQL with PostGIS on embedded hardware

From: Paolo Rizzi <gis(at)oicom(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: PostgreSQL with PostGIS on embedded hardware
Date: 2009-05-08 16:06:40
Message-ID: 4A045890.5090106@oicom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

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

Bye
Paolo

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2009-05-08 16:11:50 Re: Statistics use with functions
Previous Message Tom Lane 2009-05-08 15:48:05 Re: Statistics use with functions