Re: Loading the entire DB into RAM

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Loading the entire DB into RAM
Дата
Msg-id op.s7nd2mwncigqcu@apollo13
обсуждение исходный текст
Ответ на Re: Loading the entire DB into RAM  (Matt Davies | Postgresql List <matt-postgresql@mattdavies.net>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Loading the entire DB into RAM
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Same SQL, 104296ms of difference between 7.4.12 and 8.0.7