您可能会在
mailing lists topics中的一个中受到关注,它由Tom Lane(核心开发人员)回答:
原文链接:https://www.f2er.com/postgresql/192301.html[..] But my opinion is that people who
think they are smarter than an LRU
caching algorithm are typically
mistaken. If the table is all that
heavily used,it will stay in memory
just fine. If it’s not sufficiently
heavily used to stay in memory
according to an LRU algorithm,maybe
the memory space really should be
spent on something else. [..]
你可能也会在一个SO问题中被强调:https://stackoverflow.com/questions/486154/postgresql-temporary-tables,也许更适合https://stackoverflow.com/questions/407006/need-to-load-the-whole-postgresql-database-into-the-ram