Re: PostgreSQL with PostGIS on embedded hardware

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL with PostGIS on embedded hardware
Дата
Msg-id 19165.1241828254@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PostgreSQL with PostGIS on embedded hardware  (Paolo Rizzi <gis@oicom.com>)
Ответы Re: PostgreSQL with PostGIS on embedded hardware
Список pgsql-performance
Paolo Rizzi <gis@oicom.com> writes:
> Are you saying that PostgreSQL+PostGIS can actually run on a
> smartphone??? Intriguing...
> Did anyone ever actually tried that???

If it's a supported CPU type and you've got a suitable build toolchain,
sure.  Seven or eight years ago we were getting a good laugh out of the
fact that you could run PG on a PlayStation 2.

The real issue with the kind of hardware you're describing is going to
be the finite write lifetime of a flash device.  For a low-update
application it'll probably be okay, but PG could very easily destroy a
flash in no time if you aren't careful to minimize updates.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bad Plan for Questionnaire-Type Query
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Transparent table partitioning in future version of PG?