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
CompactFlash.
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