That's something I did for small medium size data analysis (300Gb of csv). The reported size was around 800gb with indexes iirc and it fitted on a 512gb SSD.
It compresses the indexes pretty well but don't forget to turn off postgres' own copy on write mechanism
You probably are compared to your baseline self (another comment goes more extensively on this subject) but maybe you have enough driving skills and common sense to minimize the risks somewhat.
I'm looking at the newest versal chips from Xilinx/AMD for a new design and buying a SoM & designing our carrier board could fit the bill nicely. We're still very early in the design process, we need to get prices for the chips too to see if it's an idea worth pursuing.
I don't often post here (I forgot to check the guidelines), should I have left the original title "(bcachefs) Trouble in the kernel" ?
While the article that follows is well written, the original title feels very vague and clickbaity for me. Like "you won't guess what's wrong with this !!!".
I felt this give a much better idea of the content (technical problems that exposed people problems) and give chance to people that don't want to read about kernel politics / drama a chance to skip the article.
Maybe because people seem to be very emotional about this right know? I'm myself not sure if this is related to the woke mind virus or Kent being a dick
We only have the point of view of becachefs main developer here of course, but some things regarding some kernel developer and the CoC committee seem to be really concerning.
I had the chance to visit the new datacenter of my college and on the server exhaust side there is a radiator as tall as the rack with cold water in it. All the pipes are under the floor.
IIRC they mainly put power hungry compute nodes for the clusters in this new datacenter and I remember that servers full of GPUs had crazy power draw. The water then goes through an heat exchanger to help generate hot water to heat the campus and for the taps.
The elections can be skewed with different kind of manipulation (social media, troll farms, electronic ballot hacks) and the popular candidate can still win.
It's fair to assume Putin would try to influence the elections in trump's favor as he would have been beneficial for him.
The Ukraine invasion would have been much easier if trump had been relelected, finished pulling out of nato and kept the more isolationist policy that was in effect during trump.
IMO trump was also doing a lot of damage to the US and it's position on the world stage which is also beneficial for Putin.
> The Ukraine invasion would have been much easier if trump had been relelected, finished pulling out of nato and kept the more isolationist policy that was in effect during trump.
It wouldn't have occured because NATO and the US wouldn't have been escalating it the way they did post and pre Trump.
I know this is not the right narrative (TM) but for anyone who remembers wars are not about good Vs evil but geopolitics, they'll realize the interests at play.
But hey, Iraq has WMDs and Vietnam... Er... Something.
There is also a third approach that is the best if you have a predictible base load with surges sometimes imo: hybrid cloud
You basically run the base load in your own data center and the surges go to the cloud. My university is evaluating this because sometimes you have multiple labs that need a lot of compute resources at the same time and local compute cluster has finite capacity.
It compresses the indexes pretty well but don't forget to turn off postgres' own copy on write mechanism
reply