Kingsrow - databases

[Rein Halbersma]

Rein, I assume that at least from a memory point of view the 9p would be doable-ish.
My guestimate is that 256 GByte would be sufficient, and at least the Threadripper could address this.
Also with Threadripper mother boards with 8 DIMM slots and 32 GByte Dimm seems not to be impossible.
Last but not least the costs for 256 GByte would be between 1000 - 1200 euro.

Certainly expensive, but not totally out of reach (as this is also my wish next PC system, 32 cores )

Bert

As Ed said, 9 pieces are entirely doable. It's ~13 core years. If you have 64 cores and 256Gb, it's 2-3 months. Although you would need pretty good slicing (not just leading rank) or else you need 384 Gb AFAICS.

[Rein Halbersma]

Ok, I did some more calculations. With a 64-core Threadripper (~$4K) and leading squares indexing, you can do 9 pieces in 90 days and 192 Gb of RAM. You can also do 10 pieces in 2 years and 640 Gb of RAM. All assuming that a threadripper core is pound for pound the equivalent of a Xeon core. If that is a factor 2-4 you're back to square one.

[Krzysztof Grzelak]

Rein I have a question. You know computers very well. Does it exist and have you encountered it to connect several computers together so that the computing power is greater.

[Rein Halbersma]

Rein, I assume that at least from a memory point of view the 9p would be doable-ish.
My guestimate is that 256 GByte would be sufficient, and at least the Threadripper could address this.
Also with Threadripper mother boards with 8 DIMM slots and 32 GByte Dimm seems not to be impossible.
Last but not least the costs for 256 GByte would be between 1000 - 1200 euro.

Certainly expensive, but not totally out of reach (as this is also my wish next PC system, 32 cores )

Bert

If you're going down the AMD path, the translation table is roughly this:
Threadripper -> i9 XE
Threadripper Pro -> Xeon W-series [this segment is where Ed's machine is now, and where my old Xeon E5 sat]
Epyc -> scalable Xeon (platinum) [two 8-socket 24 core machines solved 7 piece chess dbs, at $90K each]

The Zen 3 Epyc will become available in Q1 2021, and supports up to 2 sockets of 64 cores each. The older Zen 2 64 core version went at around $7K per processor, but AMD is lowering prices so you might get a 128 core machine for ~10K (no RAM though yet). With such a machine, you could build the 10 pc dbs in a year. If you wait one more generation of processors, it might be for half that amount of money.

[Krzysztof Grzelak]

Hi Ed.

Can you write exactly how much all items in the database are 4x4.