Skip site navigation (1) Skip section navigation (2)

Re: Databases in memory (-->flashdrive problem)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christian Gerdes" <christian(dot)gerdes(at)exai(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Databases in memory (-->flashdrive problem)
Date: 2002-04-15 17:40:22
Message-ID: 24596.1018892422@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"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

Responses

pgsql-admin by date

Next:From: Charlie TooheyDate: 2002-04-15 17:53:23
Subject: psql command line history not working
Previous:From: Tom LaneDate: 2002-04-15 17:32:10
Subject: Re: Extending table name max length

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group