I would imagine this was written by someone not from the US.
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…
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.…
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…
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…
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…
Was unable to edit my previous. It does use vectorization: https://www.cockroachlabs.com/docs/stable/vectorized-executi...
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)
No expert but I'd say you'd rather be looking at bigquery, Redshift, Clickhouse, Snowflake, etc.
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…
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.
...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 fan by peaking to 200+…
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…
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 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…
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…
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…
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…
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…
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…
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…
I would imagine this was written by someone not from the US.
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…
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.…
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…
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…
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…
Was unable to edit my previous. It does use vectorization: https://www.cockroachlabs.com/docs/stable/vectorized-executi...
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)
No expert but I'd say you'd rather be looking at bigquery, Redshift, Clickhouse, Snowflake, etc.
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…
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.
...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 fan by peaking to 200+…
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…
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 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…
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…
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…
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…
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…
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…
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…