TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Prewarming PostgreSQL I/O caches

60 点作者 suresh70超过 5 年前

2 条评论

legulere超过 5 年前
If you think about it, it’s a bit tragic that the APIs operating systems offer for memory mapped files are not enough for databases. The operating system already has all the caching logic in place and can do so more efficiently with hardware support.<p>If you have data that rarely changes you can actually create an ad-hoc database system based on that and have performance like an in memory database without having to worry much about the memory of the system.
评论 #21297492 未加载
mobilemidget超过 5 年前
Sounds interesting, I miss a benchmark to go with the article in my opinion.<p>&quot;pg_prewarm makes most sense if your database and your RAM are really really large (XXX GB or more)&quot;<p>A benchmark preferably with databases of sizes that make sense.
评论 #21298623 未加载