I'm trying to understand the Greenplum Database for R&D purposes and was hoping to get some clarification on a few points.
As I understand it, a segment host seems to be a physical server and then you get a segment instance per cpu core. Is that correct?
Assuming I've got the above correct, what's the typical configuration? Is it lots of physical servers for the segments, or is it just a few servers with a lot of cores, therefore giving you lots of segment instances?
Finally does anyone know any good resources for learning these sort of basics? I've been reading the admin guide/install guide and looking on greenplum.com, but it all seems to gloss over this sort of architecture detail.