"Christian Gerdes" <christian(dot)gerdes(at)exai(dot)de> writes:
> 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!?
Sure: keep the database on a RAM-drive (this will mean an initdb and
data load on each bootup, hope you can stand that) and use pg_dump to
a text file on flashdrive as your backup mechanism. Use a cron task
to run pg_dump at whatever frequency suits you.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Charlie Toohey||Date: 2002-04-15 17:53:23|
|Subject: psql command line history not working|
|Previous:||From: Tom Lane||Date: 2002-04-15 17:32:10|
|Subject: Re: Extending table name max length |