wuputah

6 ms·

1.
by wuputah 2y ago
I think it will be straightforward to expose time_bucket in pg_duckdb. Feel free to open an issue for the feature.
2.
by wuputah 2y ago
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 the benchmark in Clickbench and the settings we use
3.
by wuputah 3y ago
> 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 packages, we recommend using PGDG but the default sys
4.
by wuputah 3y ago
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 typically work this way, so it's not the way tha
5.
by wuputah 3y ago
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 table type, this is only the case on Hydra Cloud and our Doc
6.
by wuputah 3y ago
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 remove/rewrite stripes that have >20% of deleted row
7.
by wuputah 3y ago
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/discord
8.
Hydra (YC W22) Is Hiring Database Engineers (Postgres)(jobs.ashbyhq.com)
1 points by wuputah 4y ago
9.
by wuputah 4y ago
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.
10.
by wuputah 4y ago
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 of our engineering work yet, but I made a little
11.
by wuputah 4y ago
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 well with identical settings as GP2 and the resul
12.
by wuputah 4y ago
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. It's used to eliminate stripes and blocks fr
13.
by wuputah 4y ago
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 on when Greenplum last merged updates from Postgres, bu
14.
by wuputah 5y ago
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-announcing-hydra-postgr
15.
by wuputah 5y ago
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 (that does that work) running in a Heroku Private Space. If
16.
by wuputah 5y ago
Hi! Definitely reach out to us to discuss further.
17.
by wuputah 5y ago
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 control, self-hosted would be the way to go. We are offering th
18.
by wuputah 5y ago
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 database does not. You can still connect that data to Postgres
19.
by wuputah 5y ago
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 make a great point here - thanks for sharing your pas
20.
by wuputah 5y ago
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 functions beyond Postgres can be routed with our manua
21.
by wuputah 5y ago
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 "workaround" a performance issue with an u
22.
by wuputah 5y ago
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 already familiar with Postgres to be able to use add databases
23.
by wuputah 5y ago
Absolutely! Hydra is 100% Postgres and supports any existing Postgres-compatible tools.
24.
by wuputah 5y ago
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 -- but it's a great idea to demonstrate
25.
by wuputah 5y ago
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 wrap your query in an SQL function. In the future, we c
26.
by wuputah 5y ago
Hi! JD here, Hydra's CTO. NoSQL is certainly a challenge but we have a few ideas/angles on how to solve it. Certainly we plan to start with simple queries and then iterate from there based on what our customers need. We are really
27.
by wuputah 5y ago
Hi, I wrote a response [ https://news.ycombinator.com/item?id=30443033 ] about FDWs, I hope it answers your questions. We will definitely think about S3 support! Would love to understand those use cases more and how Hydra cou
28.
by wuputah 5y ago
Hi! JD here, Hydra's CTO. Hydra does not use FDWs except for Postgres-to-Postgres communication (for now). What we found was that FDWs do not do pushdown very well, even when Postgres has full information. You can get FDWs to push down
29.
by wuputah 16y ago
I am--was--an EY customer as well for some time, about a year, and had been following it since its inception, particularly through a friend who was a customer while it was still in beta. 1. I haven't seen any significant changes to their pr
30.
by wuputah 16y ago
Yes, all platforms that are static and curated in this way are aging every day, and Heroku has some flaws in this area as well. But as I understand it, the base platform of AppCloud is predominately a Gentoo-based custom portage tree that E

More ›