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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

Sorting of integers and floats 23% faster in PostgreSQL 9.2 (long explanation)

69 点作者 selenamarie将近 13 年前

3 条评论

selenamarie将近 13 年前
Peter is awesome and is also primarily responsible for a bunch of power consumption improvements: <a href="http://pgeoghegan.blogspot.com/2012/01/power-consumption-in-postgres-92.html" rel="nofollow">http://pgeoghegan.blogspot.com/2012/01/power-consumption-in-...</a>
saurik将近 13 年前
PostgreSQL should really be using a radix sort for these data types, not a quick sort (however "optimized").
评论 #4331520 未加载
bigfoot将近 13 年前
C++'s template-based sorting mechanisms allow for the same optimization without manually special-casing anything. (The compiler "integrates everything", to quote the author, out of the box.) C++ port of Postgresql, anyone?
评论 #4327988 未加载