upvote

points

by drchaim9 hours ago |
comments
upvoteby oooyay3 hours ago|
next
[-]
I had the same experience recently. Turns out ClickHouse would reduce our DB operations by 60%, remove the need for a TSDB, and reduce query times from ~300-500ms (and sometimes ~3s) to roughly ~75ms. Lastly, and most impressively we were already seeing a ridiculous level of compression and our storage cost benchmarks were reduced to the cost of S3. This took a $2-3M storage layer down to one measured in the single thousands per month.

ClickHouse is no panacea but if you understand how your data is accessed and thus how to arrange it you will get so many miles out of it.

reply
upvoteby ashu14618 hours ago|
prev|
next
[-]
Same we are also stuck with ES wish could migrate to clickhouse but not able to do so because of the legacy load.
reply
upvoteby cloudie785 hours ago|
parent|
[-]
What do you not like about ES?
reply
upvoteby arunmu5 hours ago|
prev|
next
[-]
Were you using it for simple grep search or actually required advanced searching for eg: BM25. Clickhouse will only help you with grep like search from what I understand.
reply
upvoteby drchaim3 hours ago|
parent|
[-]
Actually, there was no search, only on-the-fly aggregations/filtering over "big data". ES was kind of famous at the time, although not the best tool for that job.

afaik CH introduced FTS rececently.

reply
upvoteby KebabCase6 hours ago|
prev|
next
[-]
Off topic: IMHO, everything that's been happening over the past few years is a self-fulfilling prophecy in no small part due to attitudes like this. Der Fuhrer did not have to put in much effort to convince the population when even those exposed to the outside world have met with enough suspicion and contempt to "know" (whether it's true or not) that most westerners have never seen us as equals, or even any sort of positive force.

Most probably don't even realize it. I see it as something similar to what racial minorities in the US go through: ask a random stranger on the street if he's racist, and he will honestly say no, even if he actually simply does not realize it, while it deeply affects how he sees the world.

I've also been seeing similar attitudes in relation to the Chinese. People avoiding excellent projects because they were written by some Chinese guy, including things where supply chain security is of no concern. Again apparently not realizing that these days a large part of the work on the Linux kernel is committed by paid employees of several large Chinese companies, all of them tightly intertwined with the government. Forget talking about who is building the hardware we all use.

Whatever, the internet is fracturing and balkanizing at full speed anyway, and the borders are slowly closing. Won't be long before we won't be able exchange anything non-destructive anymore. It was good while it lasted.

reply
upvoteby budsniffer9526 hours ago|
parent|
next
[-]
>ask a random stranger on the street if he's racist, and he will honestly say no, even if he actually simply does not realize it

My lord you people are beyond patronizing.

When people refer to "the Chinese" or "the Russians", we are taking about the nation state, not the people. And there are legitimate security concerns. Whether we should be adversial is another question. But we are.

reply
upvoteby leoqa5 hours ago|
parent|
next
[-]
I am wary of any supply chain attack and more so if the project is maintained by people with relationships in adversarial countries. The risk of exploitation outweighs the convenience.
reply
upvoteby throw-the-towel5 hours ago|
parent|
prev|
[-]
I agree about the legitimate security concerns, but not with "we're talking about the nation state, not the people". If life has taught me anything in the last few years, it's that normies are incapable of making this distinction, at least in the Old World.
reply
upvoteby throw9393kddif4 hours ago|
parent|
prev|
next
[-]
Google was created by some Russian guys. Current american president was Russian agent (that is why he won 2016 elections).

I think US is very tolerant when it comes to people from Russia.

reply
upvoteby dionian2 hours ago|
parent|
[-]
yes and the proof was the spam email phoning home to russia. or, whatever other hoaxes they cooked up along the way. strangely most of them didnt make it into the trial where he was acquitted.
reply
upvoteby goodmythical5 hours ago|
parent|
prev|
[-]
Given that american ignorance is a cultural thing (with many people deliberately electing the way grandpa did it) is it not kind of racist to generalize americans as unknowingly racist?

You said, "ask a random stranger...and he will honestly say no" not "ask a random stanger...and he will probably honestly say no".

Most of most people are racist, it's just different groups. Americans obviously have less distrust of americans, but then I am just as certain that there are many many humans who would proudly share their "dumb american" stories as if that is not every bit as prejudicial to those of us who do not fit the description as any other "weak french" or "commie russian" or "sister fucking indian" or whatever else.

reply
upvoteby aleph_minus_one5 hours ago|
parent|
[-]
> but then I am just as certain that there are many many humans who would proudly share their "dumb american" stories as if that is not every bit as prejudicial to those of us who do not fit the description as any other "weak french" or "commie russian" or "sister fucking indian" or whatever else.

Racism is about race (i.e. phenotypical or genotypical properties), while being US-American/French/Russian/Indian/... is about nationality. So, these stories are not about racism (since they are not about race), but about prejudices against other nations/nationalities.

reply
upvoteby fsuts6 hours ago|
prev|
[-]
Can clickhouse to search? If not why did you seek to replace elastic with it
reply