Re: Loading the entire DB into RAM - Mailing list pgsql-performance

From PFC
Subject Re: Loading the entire DB into RAM
Date
Msg-id op.s7nd2mwncigqcu@apollo13
Whole thread Raw
In response to Re: Loading the entire DB into RAM  (Matt Davies | Postgresql List <matt-postgresql@mattdavies.net>)
List 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.



pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Loading the entire DB into RAM
Next
From: Tom Lane
Date:
Subject: Re: Same SQL, 104296ms of difference between 7.4.12 and 8.0.7