PostgreSQL:强制数据进入内存

前端之家收集整理的这篇文章主要介绍了PostgreSQL:强制数据进入内存前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
有没有一种系统的方法来强制Postgresql将特定的表加载到内存中,或者至少从磁盘中读取它以便它将被系统缓存?
您可能会在 mailing lists topics中的一个中受到关注,它由Tom Lane(核心开发人员)回答:

[..] 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

猜你在找的Postgre SQL相关文章