Hi!
Is is possible to force PostgreSQL to keep an index in memory? The data in db table columns is not needed to be kept in memory, only the index. (hash index.)
It would sound optimal in our scenario.
I think Oracle has capability to keep index in memory (in-memory db functionality). But does PostgreSQL have such a functionality? (I keep searching.)
I have read:
(effective_cache_size, shared_buffers)
I have seen responses to:
Should I actually set shared_buffers to tens of gigabytes also, if I want to keep one very big index in memory?
I ma also reading a PG book.
Best Regards, Sam
On Wednesday, September 19, 2018 11:40 AM, Sam R. <samruohola@yahoo.com> wrote:
Hi!
Related to my other email (size of index in memory),
Other questions,
Q: To keep _index(es)_ in memory, is large enough effective_cache_size enough?
Q: Size of shared_buffers does not matter regarding keeping index in memory?
Or have I missed something, does it matter (to keep indexes in memory)?
Background info: I have plans to use hash indexes: very large amount of data in db tables, but (e.g. hash) indexes could be kept in memory.
I am using PostgreSQL 10. I could start to use PostgreSQL 11, after it has been released.
Best Regards, Sam