If I'm not mistaken, then Oracle's Exadata puts "intelligence" into the storage nodes, so they can evaluate WHERE conditions independently, so they seem to take the role of a compute node as well, not only storage. I don't know if they are capable of evaluating other operations there as well (e.g. aggregations or joins)
o11c•2h ago
For reference, the (very minimal!) official docs: https://www.postgresql.org/docs/current/tableam.html