[PERFORMANCE] is it possible to force an index to be held in memory? - Mailing list pgsql-performance

From valgog
Subject [PERFORMANCE] is it possible to force an index to be held in memory?
Date
Msg-id 1183370686.234761.76720@n60g2000hse.googlegroups.com
Whole thread Raw
List 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 by date:

Previous
From: Ed Tyrrill
Date:
Subject: Re:
Next
From: "Vidhya Bondre"
Date:
Subject: slow query