Hydra 1.0
Data
columnar database
SHOW HN2023
269points
77comments
#179of 3,109 in 2023
Top 6%of 2023 by points
How HN took it
CuriousMostly questions and neutral comments
17 positive, 24 neutral or asking, 0 mixed, 6 critical, out of 47 comments about the project. Thread score +0.28.
Idea: 3 for, 3 againstPerformance: 4 for, 1 againstDocs: 2 for, 2 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Fast performance versus Citus and plain Postgres
From 2 comments
generally faster across the board, a lot of work was done to expand and speed it up, plus updates, deletes, and vacuuming.…
jerrysievert on HNsuper impressive performance improvements! do most of your customers replicate their postgres database to Hydra for analytics jobs, or what's the typical set up?
mitchpatin on HN
Useful for analytics on Postgres without learning a new database
From 2 comments
Congrats on the launch! For those who have not experimented with columnar based databases, I would highly recommend toying around with them. The performance improvements can be…
mlenhard on HNThis looks wild! Been looking for a good event based logs DB and didn’t want to go full clickhouse. This will do!
s-mon on HN
Open source Apache license
From 1 comment
I wanted to say thank you for using actual Open Source licenses. It's gotten to where I treat any recent "Launch HN" or "Show HN" containing "open source" in the title as "well,…
mdaniel on HN
Objections
Benchmark favors Hydra; plain tuned Postgres wins some queries
From 2 comments
Since benchmarks can be misleading I want to point out that the differences between Hydra and the "tuned"[0] PostgreSQL (which are some very basic settings) are a lot less…
rubiquity on HN> plain old PG coming ahead on quite a few I found that is common among these types of databases (e.g. Citus, Timescale, etc.) which perform well under very specific conditions,…
arp242 on HN
Documentation lacks migration and extension setup for existing databases
From 3 comments
For a Postgres extension, there's a strangely lack of documentation on how to add Hydra to an existing PG installation.
dikei on HNThat's also my question. Couldn't find anything for it in the docs provided. Also, how to migrate data from an existing database? (Is it the usual pg_dump/psql combo?)
ahmedfromtunis on HNCan you add the extension to an existing database?
florianherrengt on HN
Licensing confusing since it is a Citus fork under AGPL
From 2 comments
Thanks for explaining. This is confusing to me as a github user, i.e. if I saw a license in the project’s description, I wouldn’t expect another license in a subdirectory. Github…
thih9 on HNCitus: https://github.com/citusdata/citus BTW, Citus license is GNU Affero General Public License (github lists “conditions: same license”) and hydra is Apache. How is that…
thih9 on HN
Requests
Support gist, gin, spgist and brin indexes
From 1 comment
Congratulations! Can we expect support for gist, gin, spgist, and brin indexes sometime in the near future? Based on the source code, it appears that they are not supported:…
pella on HN
Document differences from Citus
From 1 comment
Ok so this is a Citus fork. Where can I read about what the differences / trade offs are? I don’t see anything in the docs.
qeternity on HN
Spatial index support and PostGIS compatibility
From 2 comments
We need a spatial index for spatial (columnar) data! - https://www.crunchydata.com/blog/the-many-spatial-indexes-of-postgis -…
pella on HNIs hydra compatible with the PostGIS extension?
mch82 on HN
Questions
How does it compare to Citus and TimescaleDB
From 2 comments
how does Hydra compare to Citus? https://www.citusdata.com
therealwardo on HNHow does it compare to Timescaledb? Performance? Features? (TSDB is my current Postgres data lake setup)
KingOfCoders on HN
How are updates and deletes handled
From 1 comment
How are updates handled, is it doing a merge on read ?
quadrature on HN
Can the extension be added to an existing database
From 1 comment
Can you add the extension to an existing database?
florianherrengt on HN
Alternatives named
Citus
From 2 comments
how does Hydra compare to Citus? https://www.citusdata.com
therealwardo on HNOk so this is a Citus fork. Where can I read about what the differences / trade offs are? I don’t see anything in the docs.
qeternity on HN
TimescaleDB
From 1 comment
How does it compare to Timescaledb? Performance? Features? (TSDB is my current Postgres data lake setup)
KingOfCoders on HN
ClickHouse
From 2 comments
Difference principles of indexing, as least based on my experience with ClickHouse. * Column-based stores have really fast scans due to compression and vectorization, so you'll…
hodgesrm on HNit depends on your query obviously. In general, I did very deep benchmarking of pg, clickhouse and duckdb, and I sure didn't make stupid mistakes like this:…
riku_iki on HN
DuckDB
From 1 comment
it depends on your query obviously. In general, I did very deep benchmarking of pg, clickhouse and duckdb, and I sure didn't make stupid mistakes like this:…
riku_iki on HN