PostgreSQL performance essentials in 1 hour
-
Updated
Jul 10, 2022
PostgreSQL performance essentials in 1 hour
Volcano and Iterator model query execution engine with streaming open-next-close pipelining, HashJoin, Filter, and Group-By Aggregations.
Volcano and Iterator model query execution engine with streaming open-next-close pipelining, HashJoin, Filter, and Group-By Aggregations.
A custom RDBMS built from scratch in Python. Features O(N) Hash Joins, ACID-compliant Atomic Writes, B-Tree Indexing concepts, and a Flask-based Admin Dashboard. Built for the Pesapal Junior Dev Challenge '26.
Implementation of Join Algorithm for SPARQL Query Processing
C++ hash join pipeline for the SIGMOD 2025 Programming Contest. Robin Hood, Hopscotch, Cuckoo and Unchained hash tables over a column store with late materialization, plus parallel build and probing with work stealing. Around 16x faster than the std::unordered_map baseline.
LingoDB-CSE is a research prototype for multi-query optimization via common sub-join elimination and hash multi-map reuse across RelAlg/SubOp, with batch SQL compilation and thesis-backed speedups.
Codes for our VLDB'23 paper "A Design Space Exploration and Evaluation for Main-Memory Hash Joins in Storage Class Memory".
Implementation of database relation join operators - Hash Join and Sort Merge Join
Implementation of Sort merge join & Hash join from scratch.
Blazing-fast zero-allocation columnar DataFrame, relational hash joins, temporal resampling, and pure C# Apache Arrow IPC streaming for .NET with zero dependencies.
This project contains basic functions of a DBMS (External Merge sort, Merge Join, Hash Join, Duplicate Elimination) that are designed to work in real-life and extreme circumstances (Huge input data, extremely low available memory).
High-performance hash-join execution engine for the IMDb Join Order Benchmark — SIGMOD 2025 contest entry. Pluggable hash tables (Unchained, Cuckoo, Robin Hood, Hopscotch), columnar late materialization, OpenMP parallelism. 93.96% faster than baseline (7,916 ms vs 131,104 ms)
High-performance in-memory query engine for the SIGMOD 2025 contest
Implementation of database relation join operators - Hash Join and Sort Merge Join
Small SQL query engine written from scratch in Go, with a volcano execution model, hash joins, aggregation, three-valued NULL semantics, and SQLite differential testing.
A vectorized in-memory analytical query engine in C++20 - columnar storage, rule-based optimizer with predicate/projection pushdown, hash joins. Measured, not asserted.
To associate your repository with the hash-join topic, visit your repo's landing page and select "manage topics."