Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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. Landemaine" <landemaine(at)gmail(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Loading the entire DB into RAM
- Date: Fri, 07 Apr 2006 19:12:12 +0200
- Message-id: <op(dot)s7nd2mwncigqcu(at)apollo13>
** This has not been tested. Create a ramdisk of required sizeCreate 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.
- References:
- Loading the entire DB into RAM
- From: Charles A. Landemaine
- Re: Loading the entire DB into RAM
- From: Matt Davies | Postgresql List
- Loading the entire DB into RAM
- Prev by Date: Re: Loading the entire DB into RAM
- Next by Date: Re: Same SQL, 104296ms of difference between 7.4.12 and 8.0.7
- Previous by thread: Re: Loading the entire DB into RAM
- Next by thread: Re: Loading the entire DB into RAM
- Indexes: