Re: Loading the entire DB into RAM

From: PFC <lists(at)peufeu(dot)com>
To: "Matt Davies | Postgresql List" <matt-postgresql(at)mattdavies(dot)net>, "Charles A(dot) Landemaine" <landemaine(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Loading the entire DB into RAM
Date: 2006-04-07 17:12:12
Message-ID: op.s7nd2mwncigqcu@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

** This has not been tested.

Create a ramdisk of required size
Create a Linux software RAID mirror between the ramdisk, and a partition
of the same size.
Mark the physical-disk as write-mostly (reads will go to the ramdisk)
Format it and load data...

On reboot you'll get a RAID1 mirror with 1 failed drive (because the
ramdisk is dead of course). Just recreate the ramdisk and resync.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-04-07 17:36:58 Re: Same SQL, 104296ms of difference between 7.4.12 and 8.0.7
Previous Message Scott Marlowe 2006-04-07 15:49:14 Re: Loading the entire DB into RAM