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

From: valgog <valgog(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: [PERFORMANCE] is it possible to force an index to be held in memory?
Date: 2007-07-02 10:04:46
Message-ID: 1183370686.234761.76720@n60g2000hse.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-performance by date

  From Date Subject
Next Message Vidhya Bondre 2007-07-02 10:07:04 slow query
Previous Message Ed Tyrrill 2007-06-29 21:01:03 Re: