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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

Citus 6.2: Concurrent index creation and complex queries for multi-tenant dbs

87 点作者 sgrove将近 8 年前

7 条评论

brandur将近 8 年前
This is a pretty impressive set of new features and fixes (i.e. things that worked in Postgres, but not with CitusDB).<p>In particular, the added ability to run `CREATE INDEX CONCURRENTLY` [1] for distributed tables is an important addition. I&#x27;ve run a pretty big Postgres database before, and this feature is absolutely _critical_ for bringing new indexes online for large tables without affecting users or other operations (without it, `CREATE INDEX` needs a lock that blocks other modifications in the table).<p>Its reverse, `DROP INDEX CONCURRENTLY` is a relatively newer addition to Postgres and also pretty key. While running on pre-9.2 (when it was added), we had to stop dropping indexes from large tables because the operation would block long enough that we&#x27;d start timing out user requests while it was running.<p>[1] <a href="https:&#x2F;&#x2F;www.postgresql.org&#x2F;docs&#x2F;current&#x2F;static&#x2F;sql-createindex.html" rel="nofollow">https:&#x2F;&#x2F;www.postgresql.org&#x2F;docs&#x2F;current&#x2F;static&#x2F;sql-createind...</a>
capkutay将近 8 年前
I wonder how they&#x27;ll compete with Cockroach down the road. Looks like both projects are doing great work around ACID in multi-tenant environments.
评论 #14510419 未加载
jeffnappi将近 8 年前
This is <i>key</i>: SERIAL on distribution column: we now use serial types exactly as in Postgres<p>Bravo!
erikpukinskis将近 8 年前
Just a quick comment on this:<p>&gt; Good software never stops evolving<p>I think I would translate this as: &quot;our software is so large in scope, it must never stop evolving if it is to remain good enough.&quot;<p>Small software, with a single, focused goal, can evolve to a steady state which is still good.<p>Often we need to build things whose scope is too large for that, and must constantly churn. That&#x27;s ok. But ideally you are finding parts of your work which can be sent in the opposite direction: towards God; or the oneness of all things.<p>If none of your work ever seems to find a path towards simplicity and oneness, it&#x27;s possible you are pathologically mixing concerns, which, if true, is probably slowing you down.
评论 #14510437 未加载
old-gregg将近 8 年前
Citus people are putting SQL back into NoSQL! :) Awesome.
评论 #14510438 未加载
qaq将近 8 年前
Do you guys have pricing anywhere on the site?
评论 #14510299 未加载
TeMPOraL将近 8 年前
Offtopic, but the mention of elegant lightsabers reminds me of a scene from one of my favourite TV series, StarGate SG-1:<p><a href="https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=NjlCVW_ouL8" rel="nofollow">https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=NjlCVW_ouL8</a><p>Money quote at 02:25:<p><pre><code> [O&#x27;Neill demonstrating a staff weapon] This is a weapon of terror. It&#x27;s made to... intimidate the enemy. THIS... [O&#x27;Neill shows a P-90] ... is a weapon of _war_. It&#x27;s made to _kill_ your enemy. </code></pre> I.e. effective beats elegant :).