Databases in memory (-->flashdrive problem)

From: "Christian Gerdes" <christian(dot)gerdes(at)exai(dot)de>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Databases in memory (-->flashdrive problem)
Date: 2002-04-11 15:07:11
Message-ID: 45CE8A6EF04DF14082405BEE982CE70E031859@2000-eka-exc-03.EKATEC.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raphael Bauduin 2002-04-11 15:30:21 Re: performance "tests"
Previous Message Tom Lane 2002-04-11 14:34:40 Re: performance "tests"