Viewing profile — wuputah

I think it will be straightforward to expose time_bucket in pg_duckdb. Feel free to open an issue for the feature.

That is an incorrect and baseless accusation, we had nothing to do with "Postgres (tuned)". My commits are only in the `hydra` folder. There are no restrictions on how you set up t…

> does it work with the existing postgres apt/yum repos? We only support apt for now but plan to support other package managers in the future. It works with existing Postgres apt p…

In my opinion, we plan on accomplishing this by using a container; it's not quite something we have today, but this is good feedback. :) On Ubuntu/Debian, Postgres doesn't typicall…

Thanks for calling these out, as these are just misunderstandings. We will certainly tweak the language around these. - Installing the extension itself does not change the default …

First we added a bitmask to mark rows as deleted - these rows are filtered out on read. Then updates are implemented as deletions + inserts. We have also added vacuum functions to …

of course :) drop by our Discord if there's something you'd like to contribute and want to chat about it beforehand, need help/have questions getting started, etc. https://hydra.so…

Yes, Hydra Columnar and PostGIS get along just fine. We've not looked into any PostGIS-specific optimizations yet, but if users run into issues, we'll be happy to investigate.

Of course, that's the power of Postgres. You can join between columnar tables or between columnar and heap (row-based) tables. The performance of joins hasn't been a specific focus…

Yeah, I agree! However, ClickBench has used 500GB GP2 as the "standard" for some time, so I stuck to it for consistency. We use GP3 for our hosted service, and I did test on GP3 as…

The metadata can act as a basic form of indexing (or sometimes caching, though Hydra doesn't use metadata to calculate results yet), but it's not an index in the traditional sense.…

A narrow distinction, but Hydra is Postgres - we only install an extension - while Greenplum and Redshift are forks but remain Postgres-compatible (to varying degrees). I'm not up …

We hope you find our new product useful and engaging! You can get started with a free 10 GB Hydra at https://hydras.io/ or read our blog post at https://hydras.io/blog/2022-03-21-a…

I agree with your lead statement and argued as such, but was overruled. Last I knew and understood, Heroku Status is static pages pushed out to Fastly, with the internal admin site…

Hi! Definitely reach out to us to discuss further.

Certainly, I see us expanding to other cloud providers as we follow customer demand, but it will take some time. I think if you wanted to move faster and have a higher level of con…

Hi, JD here, CTO at Hydra. In an HTAP scenario, local transactional data would be replicated, but your data warehouse will likely have a great amount of data that your Postgres dat…

Hi, JD here, Hydra's CTO. It's still early days and we are considering open source; for now, we wanted to leave our options open, and OSS feels like a one-way door. I think you mak…

Hi, JD here, Hydra's CTO. Thanks for the interest and questions! Today, queries need to be Postgres-compatible to be intelligently routed, but queries with specific query syntax or…

Hydra doesn't ship data to the client in order to then do further work like aggregations -- that's the whole point of Hydra -- but that also means that you won't be able to "workar…

Calcite is definitely some cool tech. I can see why it would be attractive for bigger teams, but it seems like a big lift for smaller teams. Our goal is to make it easy for devs al…

Absolutely! Hydra is 100% Postgres and supports any existing Postgres-compatible tools.

Hi, I'm JD, Hydra's CTO. There's no perceivable overhead to using Hydra on queries being routed to Postgres. I think you would not be able to see Hydra in the noise in a benchmark …

Hi, JD here, Hydra's CTO. Thanks for the great question! You can use our manual router[1] to route queries that use a specific syntax or functions. The way this works today is you …