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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

Postgres Indexing: When Does BRIN Win?

27 点作者 krnaveen14将近 3 年前

2 条评论

aspyct将近 3 年前
Oh nice, I have just the tables for that! Billions of well-compacted rows with a big ol' timestamp on them. Btree indices are almost as big as the table itself...
评论 #32094081 未加载
geordee将近 3 年前
This is similar to Zone Maps in Netezza. <a href="https:&#x2F;&#x2F;www.ibm.com&#x2F;docs&#x2F;en&#x2F;psfa&#x2F;7.2.1?topic=statistics-zone-maps" rel="nofollow">https:&#x2F;&#x2F;www.ibm.com&#x2F;docs&#x2F;en&#x2F;psfa&#x2F;7.2.1?topic=statistics-zone...</a><p>Incidentally, Netezza was built on Postgres engine, years back.