hazaskull

7 ms·

1.
by hazaskull 3mo ago
I would imagine this was written by someone not from the US.
2.
by hazaskull 2y ago
Thanks. I think that only covers the commercial bits they run themselves though: "The entire database with all its features (including the enterprise ones) is licensed under the Apache License 2.0 The binaries that contain -man
3.
by hazaskull 2y ago
I was under the impression that Yugabyte requires signing a CLA to contribute which leads me to avoid it for fear of them relicensing the thing when the VC's start squeezing. Also: very unique and single vendor driven. Seems like too m
4.
by hazaskull 2y ago
Hi there! Thank you for the post and your work on pgzx! Though it depends on the system (cockroachdb can place leaders on specific nodes to speed up local queries, it has global tables and otherwise there's always follower-reads) those
5.
by hazaskull 2y ago
While it is fun to see how to creatively solve such issues, it does raise the question of managability. When sharding data into loosely (fdw) coupled silo's it would become tricky to make consistent backups, ensure locking mechanisms w
6.
by hazaskull 3y ago
Thank you for the correction. Indeed it is not entirely the same thing. Though I'd expect that at least the benefit of not having to read columns that aren't in the family would still help (haven't tried in earnest). I suppo
7.
by hazaskull 3y ago
Was unable to edit my previous. It does use vectorization: https://www.cockroachlabs.com/docs/stable/vectorized-executi...
8.
by hazaskull 3y ago
Indeed. As I commented alsewhere this is just about the general design. It is not targeting OLAP in this case (even though I do believe cockroach employs vectorization for reads)
9.
by hazaskull 3y ago
No expert but I'd say you'd rather be looking at bigquery, Redshift, Clickhouse, Snowflake, etc.
10.
by hazaskull 3y ago
They don't optimize for it and I suppose the data distribution is primarily aimed at parallel OLTP rather than OLAP. Just wanted to mention that design-wise it is similar but that's indeed not all there is to it. I'd be hesit
11.
by hazaskull 3y ago
Not Postgres-based (but wire- and mostly syntax-compatible): cockroachDB using column families is much like a columnar MPP. Yugabyte is PG-based and MPP but not columnar.
12.
by hazaskull 4y ago
...and then there is me using echo "75000000" | sudo tee /sys/class/powercap/intel-rapl/intel-rapl\:0/constraint_1_power_limit_uw to cap my i7-10700 to prevent it from overpowering the system
13.
by hazaskull 4y ago
Not to say that I disagree with you in principle but I'd think there is a large difference between disagreeing with someone's opinions and disagreeing with someones values. You generally can't have a meaningful conversation i
14.
by hazaskull 4y ago
Personally I find the idea of a very small cartel of companies holding all the cards quite dystopian. There are certain people that I very much would not like to be in control of all that. Guess I'm not ready to accept the supposed ine
15.
by hazaskull 4y ago
The way I read it is simply a broadly applicable notion that a certain type of people will demonstrate their power and (perceived) higher status over others by openly breaking the others' rules without consequence. EDIT for better word
16.
by hazaskull 4y ago
Ah well, we're all humans with our own blind focus on specific wants and needs. Most managers are not maniacs. Our capitalistic society just has a lot of bad incentives that are hard to change without damaging its good parts. Spreading
17.
by hazaskull 4y ago
Honestly I think your comment shows part of the problem here, though I do understand your point. But if "mere" employees feel that they are personally in competition with basically the rest of the world it easily becomes a war of
18.
by hazaskull 4y ago
52. Not been pulling all-nighters (okay maybe once or twice in exceptional circumstances that were also appreciated as such by the management after) as I've always believed your point to be right. If you're not (in part) owning th
19.
by hazaskull 5y ago
Counter example. I switched from Linux to Windows because I find its desktop-experience to be superior. In my mind software and hardware is evolving at a rate that makes it impractical to support the notion that I could usefully modify it m
20.
by hazaskull 6y ago
Needed to create one for a long time ;) General cpu-bound tasks seem fine in a vm; i/o is definitely slower but much to my surprise linux’s ext4 filesystem is so much more efficient (?) than ntfs for small files that even inside a vm (
21.
by hazaskull 6y ago
YMMV but for me personally with Dell Sonicwall it basically does not work (even workarounds that mess with MTU sizes are unstable). In my case the behavior is that general networking speed drops massively as soon as both VPN and WSL2 are ac