gem-hunter
Language: C
Postgres-native columnar storage extension
Hydra Colummnar is open source, column-oriented Postgres.
The Docker image is a drop-in replacement for postgres Docker image.
You can try out Hydra locally using docker-compose.
git clone https://github.com/hydradatabase/columnar && cd columnar cp .env.example .env docker compose up psql postgres://postgres:hydra@127.0.0.1:5432
Benchmarks were run on a c6a.4xlarge (16 vCPU, 32 GB RAM) with 500 GB of GP2 storage. Results in seconds, smaller is better.
Review Clickbench for comprehensive results and the list of 42 queries tested.
This benchmark represents typical workload in the following areas: clickstream and traffic analysis, web analytics, machine-generated data, structured logs, and events data.
For our continuous benchmark results, see BENCHMARKS.
View complete answers in our documentation.
A: Columnar storage, query parallelization, vectorized execution, column-level caching, and tuning Postgres.
A: Data is loaded into columnar format by default. Use Postgres normally.
A: Aggregates (COUNT, SUM, AVG), WHERE clauses, bulk INSERTS, UPDATE, DELETE…
A: Frequent large updates, small transactions…
A: Hydra is a Postgres extension, not a fork. Hydra makes use of tableam (table access method API), which was added in Postgres 12 released in 2019.
Hydra is only possible by building on the shoulders of giants.
The code in this repo is licensed under:
The docker image is built on the Postgres docker image, which contains a large number of open source projects, including:
As for any pre-built image usage, it is the image user's responsibility to ensure that any use of this image complies with any relevant licenses for all software contained within.