PostgreSQL and embedded PC with Compact Flash?

From: k(dot)novo <k(dot)novo(at)seznam(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL and embedded PC with Compact Flash?
Date: 2007-01-17 14:52:49
Message-ID: 180.254-9491-1757867879-1169045569@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have strange question and idea.
Use PostgreSQL in embedded PC (with Linux) as data storage for collection measure data.
Problem is in limited Write cycle in Compact Flash HDD (about 100.000)
My idea is collect data to temporary table in RAM (RAM Disk) and once day rewrite all collect data to main table to Compact Flash.
Question is. How set PostgreSQL and according as it is possible with PostgreSQL?
Is possible minimize soever Write entry to PostgreSQL files on CF?
Possibly, recommended another SQL server.

Thanks to help

Karel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-17 15:06:00 Re: Controlling memory of session
Previous Message Tom Lane 2007-01-17 14:38:51 Re: The jdbc and current_timestamp