Title: hi hn, hydra ceo here<p>hydra is an open-source extension that adds columnar tables to Postgres for efficient analytical reporting. With Hydra, you can analyze billions of rows instantly without changing code.<p>demo video (5 min): <a href="https:&#x2F;&#x2F;youtu.be&#x2F;1yzxgb0Oyrw" rel="nofollow noreferrer">https:&#x2F;&#x2F;youtu.be&#x2F;1yzxgb0Oyrw</a>
github repo: <a href="https:&#x2F;&#x2F;github.com&#x2F;hydradatabase&#x2F;hydra">https:&#x2F;&#x2F;github.com&#x2F;hydradatabase&#x2F;hydra</a><p>For 1.0 GA release, aggregate queries are over *60% faster* than Hydra beta due to aggregate vectorization. Spatial indexes (gin, gist, spgist, and rum indexes) and pg_hint_plan are now enabled for performance optimization.<p>postgres is great, but aggregates can take minutes to hours to return results on large data sets. long-running analytical queries hog database resources and degrade performance. use hydra to run much faster analytics on postgres without changing code.<p>for testing, try the hydra free tier to create a column postgres instance on the cloud. <a href="https:&#x2F;&#x2F;dashboard.hydra.so&#x2F;signup">https:&#x2F;&#x2F;dashboard.hydra.so&#x2F;signup</a>
Upvote: