Marty Scholes <marty(at)outputservices(dot)com> writes:
> Has anyone seriously looked at how it would impact things to give the
> DBA the option of storing certain indices in RAM instead of on disk?
I'd classify it as an utter waste of time. If the index is being hit
heavily, it will stay cached in RAM anyway. If it isn't, locking it in
RAM would be a pessimization not an optimization, because the space
would be better used for something else.
regards, tom lane