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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

Re-examining our approach to memory mapping

3 点作者 bluestreak超过 4 年前

2 条评论

hinkley超过 4 年前
Many of the problems with staging environments are preserved if you remove staging environments:<p>How do I test with realistic data but <i>never</i> risk my customer&#x27;s data in the process? Either way I&#x27;m going to make a copy of real user data. In one case it&#x27;s much harder to have shared references to live data than in the other.<p>There are lots of failure modes for rehearsals that can take out the cluster. If you&#x27;re doing it live, how do you know you don&#x27;t have a request loop or just introduced an n+1 fanout in a previously well-behaved service? One that can take out said service and parts of its dependency graph? What if I write a query that crashes processes?<p>On the other hand, it&#x27;s &#x27;common sense&#x27; for staging to use similar hardware to production so that discrepancies don&#x27;t catch you by surprise. But common sense isn&#x27;t common, and people can rationalize the hell out of not spending money on precautions, and so they never are equivalent if they are partitioned. Which also makes thing like perf analysis very low fidelity.<p>More likely that nobody is right, everything is a tradeoff (sucks), and which pain points can your organization collectively stomach?
bluestreak超过 4 年前
Hi HN,<p>Author here. QuestDB is a fast SQL open source database for time series. About a month ago we launched on HackerNews [1].<p>Today, I am excited to announce QuestDB 5.0.3 [2]. This new release includes our changes in memory mapping strategy, giving us better performance, as well as some major changes to the Postgres wire protocol support.<p>In this blog post, we explain our journey to improve QuestDB&#x27;s performance, especially regarding memory management. Relying as much as possible on the kernel and avoiding extra layers turned out to be very successful.<p>Thanks<p>Vlad<p>[1] <a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=23975807" rel="nofollow">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=23975807</a><p>[2] <a href="https:&#x2F;&#x2F;questdb.io&#x2F;getstarted&#x2F;" rel="nofollow">https:&#x2F;&#x2F;questdb.io&#x2F;getstarted&#x2F;</a>