Databases in memory (-->flashdrive problem) - Mailing list pgsql-admin

From Christian Gerdes
Subject Databases in memory (-->flashdrive problem)
Date
Msg-id 45CE8A6EF04DF14082405BEE982CE70E031859@2000-eka-exc-03.EKATEC.COM
Whole thread Raw
Responses Re: Databases in memory (-->flashdrive problem)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi all together,

i hope i'm at right list...

Is there an opportunity to configure postgre to keep databases in Memory?
I need to store a lot of data (many little entries) on IDE- flashdrive.
But flashdrives have a little problem with write-cycles.
Each flash-cell can be rewritten approxiatly 300.000 times. This means for me:
there is no chance to store my db directly on flashdrive.

If i could let my databases stay in RAM (maybe RAM-Drive, if so) i may do a backup to flashdrive in a defined
frequency!?

Some thoughts? Please give me some hints...


tia
Christian


pgsql-admin by date:

Previous
From: Raphael Bauduin
Date:
Subject: Re: performance "tests"
Next
From: "Ole"
Date:
Subject: Please - postgresql cannot connect?