PostgreSQL/Oracle to Cassandra is really an apples to oranges comparison. Both offer very different ways to solve some similar problems (get your data out of storage) and some very different ones (easily adding/removing servers from a cluster, distributing a cluster across data-centers). Some things are easy to do with PostgreSQL or Oracle, some are not, and some are very expensive and still some are next to impossible.