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

From Nigel J. Andrews
Subject Re: Databases in memory (-->flashdrive problem)
Date
Msg-id Pine.LNX.4.21.0204152018180.20382-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Re: Databases in memory (-->flashdrive problem)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Databases in memory (-->flashdrive problem)
List pgsql-admin
On Mon, 15 Apr 2002, Tom Lane wrote:

> "Christian Gerdes" <christian.gerdes@exai.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.

Wouldn't it be possible/better to just do recursive filesystem copy between RAM
drive and the flash drive?

Obviously that would be before starting postmaster and after stopping it using
cpio or whatever tool is prefered.


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants


pgsql-admin by date:

Previous
From: "Gianmarco Piola"
Date:
Subject: new problems
Next
From: "Wang, Mary Y"
Date:
Subject: Lost Data. Need to get back with pg_control - pg_xlog