Databases in memory (-->flashdrive problem)

Поиск
Список
Период
Сортировка
Искать
От
Christian Gerdes
Тема
Databases in memory (-->flashdrive problem)
Дата
Msg-id
45CE8A6EF04DF14082405BEE982CE70E031859@2000-eka-exc-03.EKATEC.COM
Список
Дерево обсуждения
Databases in memory (-->flashdrive problem) "Christian Gerdes" <christian.gerdes@exai.de>
Re: Databases in memory (-->flashdrive problem) Tom Lane <tgl@sss.pgh.pa.us>
Re: Databases in memory (-->flashdrive problem) "Nigel J. Andrews" <nandrews@investsystems.co.uk>
Re: Databases in memory (-->flashdrive problem) Tom Lane <tgl@sss.pgh.pa.us>
Hi all together,

i hope i'm at right list...

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!?

Some thoughts? Please give me some hints...


tia
Christian

В списке pgsql-admin по дате отправления
От: Raphael Bauduin
Дата:
Сообщение: Re: performance "tests"
От: Ole
Дата:
FAQ