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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

Show HN: Another Query Optimization Algorithm for PostgreSQL

2 点作者 matroid大约 4 年前

1 comment

matroid大约 4 年前
Hello Everyone!<p>I have implemented a query optimization algorithm for PostgreSQL. The novelty here was supposed to be that the query optimization phase could be split up into sub-optimization steps which could be executed on multiple workers parallely. I think there are not many real world use cases for this. I could only think of a contrived setting where one has to do some data-analysis on many (100s) of data sources, where searching for a join plan might be a bottleneck.<p>Anyway, as you will find, if you visit the repository, that I found it difficult to use threads&#x2F;fork processes in Postgres in a way that was reliable and safe. I would like people&#x27;s opinion on whether the use case I described earlier is a real one and if so, can we parallelize join optimization in Postgres?