Re: PostgreSQL with PostGIS on embedded hardware

From: Fernando Hevia
Subject: Re: PostgreSQL with PostGIS on embedded hardware
Date: ,
Msg-id: 89234A9C89C444CF9C16315DF7AF8D82@iptel.com.ar
(view: Whole thread, Raw)
In response to: PostgreSQL with PostGIS on embedded hardware  (Paolo Rizzi)
Responses: Re: PostgreSQL with PostGIS on embedded hardware  (Paolo Rizzi)
List: pgsql-performance

Tree view

PostgreSQL with PostGIS on embedded hardware  (Paolo Rizzi, )
 Re: PostgreSQL with PostGIS on embedded hardware  ("Joshua D. Drake", )
  Re: PostgreSQL with PostGIS on embedded hardware  (Paolo Rizzi, )
 Re: PostgreSQL with PostGIS on embedded hardware  ("Fernando Hevia", )
  Re: PostgreSQL with PostGIS on embedded hardware  (Paolo Rizzi, )
 Re: PostgreSQL with PostGIS on embedded hardware  (PFC, )
  Re: PostgreSQL with PostGIS on embedded hardware  (Paolo Rizzi, )
   Re: PostgreSQL with PostGIS on embedded hardware  (Tom Lane, )
    Re: PostgreSQL with PostGIS on embedded hardware  (Paolo Rizzi, )
     Re: PostgreSQL with PostGIS on embedded hardware  (Stefan Kaltenbrunner, )
      Re: PostgreSQL with PostGIS on embedded hardware  (Greg Stark, )
   Re: PostgreSQL with PostGIS on embedded hardware  (PFC, )
 Re: PostgreSQL with PostGIS on embedded hardware  (Stefan Kaltenbrunner, )


> -----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?


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

We never considered that solution so I couldn´t say.

>
> Bye
> Paolo
>

Regards,
Fernando.



pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: PostgreSQL with PostGIS on embedded hardware
From: Craig Ringer
Date:
Subject: Re: Transparent table partitioning in future version of PG?