[PERFORMANCE] is it possible to force an index to be held in memory?

Поиск
Список
Период
Сортировка
От valgog
Тема [PERFORMANCE] is it possible to force an index to be held in memory?
Дата
Msg-id 1183370686.234761.76720@n60g2000hse.googlegroups.com
обсуждение исходный текст
Список pgsql-performance
Hi,

I have found some discussions about that issue, but did not find the
answer actually.

Is there a way to be sure, that some indexes are alway in memory? My
tests bringing them to the memory based file system (ramfs) tablespace
showed really a very significant performance gain. But a perspective
to have a corrupted database after each machine restart does not
really make me feel good.

With best regards,

-- Valentine Gogichashvili


В списке pgsql-performance по дате отправления:

Предыдущее
От: Ed Tyrrill
Дата:
Сообщение: Re:
Следующее
От: "Vidhya Bondre"
Дата:
Сообщение: slow query