What users are saying about
75 Ratings
Top Rated
218 Ratings
75 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 out of 100
Top Rated
218 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.9 out of 100

Likelihood to Recommend

Cassandra

Apache Cassandra is a NoSQL database and well suited where you need highly available, linearly scalable, tunable consistency and high performance across varying workloads. It has worked well for our use cases, and I shared my experiences to use it effectively at the last Cassandra summit! http://bit.ly/1Ok56TKIt is a NoSQL database, finally you can tune it to be strongly consistent and successfully use it as such. However those are not usual patterns, as you negotiate on latency. It works well if you require that. If your use case needs strongly consistent environments with semantics of a relational database or if the use case needs a data warehouse, or if you need NoSQL with ACID transactions, Apache Cassandra may not be the optimum choice.
Rekha Joshi | TrustRadius Reviewer

PostgreSQL

PostgreSQL is open source, and then, there are several companies that could give you technical support, like EnterpriseDB or Percona.
PostgreSQL is easy to install and configure and is multi-platform, you could use Windows, Mac, Linux, FreeBSD, and you could use ALL the hardware you have purchased for your project, without sinking hundreds of thousand of dollars in proprietary software, to use only a small part of your server for the database.
Let's see a concrete case: You have a project to make an information system which uses an underlying database. Then you purchase 3 servers, which cost USD 50K for the Production server, USD 25K for the Contingency Server and USD 10K for the Development Server.
If you use a proprietary database, we know what companies, they price their software licenses per every 2 cores if we use the servers physically or every 2 vcpus (threads) if we use virtual machines, and the cost range is between USD 15K and 50K for each 2 cores license. If my production server has a configuration of 24 SSDs of 3,84 TB, 2 TB of ECC RAM, and 2 CPUs AMD EPYC 7702, with 64 cores each (128 cores and 256 vcpus or threads per server), the cost of the proprietary database could be more than USD one million, and if we use a subscription mechanism to get the updates, we could be talking of another million each 3 to 5 years. That is ten times the cost of the hardware. And you can TOUCH the hardware.
Is PostgreSQL slower than the proprietary databases that we talk about? Yes; but for what margin? In in-house tests, the performance of PostgreSQL was from 50% to 75% typically, with several scenarios where PostgreSQL where speedier. But we could use ALL the cores for the DBMS, not just a few.
For us PostgreSQL is the best database in existence. Period. If we use proprietary databases yet it's only for legacy information systems, for contractual restrictions or because our providers haven't seen the light (yet).
Javier Blanque | TrustRadius Reviewer

Feature Rating Comparison

NoSQL Databases

Cassandra
8.0
PostgreSQL
Performance
Cassandra
8.4
PostgreSQL
Availability
Cassandra
8.7
PostgreSQL
Concurrency
Cassandra
7.7
PostgreSQL
Security
Cassandra
8.0
PostgreSQL
Scalability
Cassandra
9.4
PostgreSQL
Data model flexibility
Cassandra
6.7
PostgreSQL
Deployment model flexibility
Cassandra
7.0
PostgreSQL

Pros

Cassandra

  • Continuous availability: as a fully distributed database (no master nodes), we can update nodes with rolling restarts and accommodate minor outages without impacting our customer services.
  • Linear scalability: for every unit of compute that you add, you get an equivalent unit of capacity. The same application can scale from a single developer's laptop to a web-scale service with billions of rows in a table.
  • Amazing performance: if you design your data model correctly, bearing in mind the queries you need to answer, you can get answers in milliseconds.
  • Time-series data: Cassandra excels at recording, processing, and retrieving time-series data. It's a simple matter to version everything and simply record what happens, rather than going back and editing things. Then, you can compute things from the recorded history.
David Prinzing | TrustRadius Reviewer

PostgreSQL

  • As I mentioned before, Postgres has an incredibly flexible and simple-to-use user/role management system. First, there are users--login information so that you can hand out to individual users. Then, there are roles, which specify read and/or write access to all the tables that you can assign to users. Through this system, you can easily control who can read and update which tables, and the system is very well-tested, so there's no concern with users accessing or writing to data that they shouldn't be unless your Postgres admin really messes up!
  • I could write pages on this and would need to reference the Postgres manual itself to do this justice, but Postgres is dang scalable! There are so many ways to scale it. Postgres has undergone active development by some of the brightest engineers for over 30 years now, and the result is that Postgres has so many ways you can scale it besides just upping the SSD and CPU and memory speed. You can scale reads horizontally through multiple slaves that handle all the reads. You can add highly optimized indices to your tables. You can change columns to JSONB types for super fast JSON queries. You can turn on special caches to bulk writes so they don't overwhelm the disk. Between those three options and other tips and tricks experienced Postgres admins have, you can get a lot out of them. There's a reason Yahoo stuck with Postgres for decades up until their main database even past the point of 4 Petabytes and 10k writes/second!
  • Postgres, simply put, has achieved super-wide industry adoption (6% market share), which means it's really easy to integrate it into your stack and hire knowledgeable developers to service Postgres. All the major database libraries of the common web frameworks that I know are out there (e.g. Rails-ActiveRecord, Spring-Hibernate, Play Scala-Slick) have out-of-the-box deep Postgres support, with no extra configuration needed to get your web app to start reading and writing to Postgres. I also know many universities in the US include Postgres in their curriculum too (e.g. UC Berkeley). It's really easy to hire either new grads or experienced software engineers for positions that require Postgres knowledge.
  • If you are comparing Postgres to MySQL and you want to use JSON, know that Postgres has better performance and features on indexing JSON blobs simply because Postgres beat MySQL to the JSON game by several years. I haven't used MySQL's JSON support before, but that's what my co-workers say (and it's true that Postgres definitely started support mySQL years earlier).
Anonymous | TrustRadius Reviewer

Cons

Cassandra

  • Cassandra runs on the JVM and therefor may require a lot of GC tuning for read/write intensive applications.
  • Requires manual periodic maintenance - for example it is recommended to run a cleanup on a regular basis.
  • There are a lot of knobs and buttons to configure the system. For many cases the default configuration will be sufficient, but if its not - you will need significant ramp up on the inner workings of Cassandra in order to effectively tune it.
Anonymous | TrustRadius Reviewer

PostgreSQL

  • Deployment gets difficult for folks who are habituated with commercial databases.
  • We cannot write our own database engine unlike MySQL.
  • PostgreSQL do not allow us to execute batch of statement. we have to embed it in a function to achieve this.
Venkateswar Reddy Thatikonda | TrustRadius Reviewer

Likelihood to Renew

Cassandra

Cassandra 8.5
Based on 16 answers
I would recommend Cassandra DB to those who know their use case very well, as well as know how they are going to store and retrieve data. If you need a guarantee in data storage and retrieval, and a DB that can be linearly grown by adding nodes across availability zones and regions, then this is the database you should choose.
Anonymous | TrustRadius Reviewer

PostgreSQL

PostgreSQL 9.0
Based on 1 answer
As a needed software for day to day development activities
Ojoswi Basu | TrustRadius Reviewer

Usability

Cassandra

Cassandra 7.0
Based on 1 answer
It’s great tool but it can be complicated when it comes administration and maintenance.
Glen Kim | TrustRadius Reviewer

PostgreSQL

PostgreSQL 9.0
Based on 6 answers
Postgresql is the best tool out there for relational data so I have to give it a high rating when it comes to analytics, data availability and consistency, so on and so forth. SQL is also a relatively consistent language so when it comes to building new tables and loading data in from the OLTP database, there are enough tools where we can perform ETL on a scalable basis.
Anonymous | TrustRadius Reviewer

Reliability and Availability

Cassandra

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 9.0
Based on 1 answer
PostgreSQL's availability is top notch. Apart from connection time-out for an idle user, the database is super reliable.
Ojoswi Basu | TrustRadius Reviewer

Performance

Cassandra

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 7.0
Based on 1 answer
The data queries are relatively quick for a small to medium sized table. With complex joins, and a wide and deep table however, the performance of the query has room for improvement.
Ojoswi Basu | TrustRadius Reviewer

Support Rating

Cassandra

Cassandra 7.0
Based on 2 answers
Sometimes instead giving straight answer, we ‘re getting transfered to talk professional service.
Glen Kim | TrustRadius Reviewer

PostgreSQL

PostgreSQL 9.2
Based on 13 answers
Its a really great product that has rich features which are well suited for our needs. It also has a NoSQL option which could be useful in some cases. And most importantly it's free to use which is always great.There's still room for improvement though, for example, the installation and upgrade process could be made easier, online resources could be improved as well.
Anonymous | TrustRadius Reviewer

Online Training

Cassandra

No answers on this topic

PostgreSQL

The online training is request based. Had there been recorded videos available online for potential users to benefit from, I could have rated it higher. The online documentation however is very helpful. The online documentation PDF is downloadable and allows users to pace their own learning. With examples and code snippets, the documentation is great starting point.
Ojoswi Basu | TrustRadius Reviewer

Implementation Rating

Cassandra

Cassandra 7.0
Based on 2 answers
No answer on this topic is available.

PostgreSQL

PostgreSQL 9.0
Based on 2 answers
The online documentation of the PostgreSQL product is elaborate and takes users step by step.
Ojoswi Basu | TrustRadius Reviewer

Alternatives Considered

Cassandra

We evaluated MongoDB also, but don't like the single point failure possibility. The HBase coupled us too tightly to the Hadoop world while we prefer more technical flexibility. Also HBase is designed for "cold"/old historical data lake use cases and is not typically used for web and mobile applications due to its performance concern. Cassandra, by contrast, offers the availability and performance necessary for developing highly available applications. Furthermore, the Hadoop technology stack is typically deployed in a single location, while in the big international enterprise context, we demand the feasibility for deployment across countries and continents, hence finally we are favor of Cassandra
yixiang Shan | TrustRadius Reviewer

PostgreSQL

Compared to MySQL, it works well if you need to extend to your use caseCompared to Spark, it works better w.r.t development time in a central database settingLike Redis, it cannot be used for caching and quick access of non-structured data
Nitin Pasumarthy | TrustRadius Reviewer

Scalability

Cassandra

No score
No answers yet
No answers on this topic

PostgreSQL

PostgreSQL 8.0
Based on 1 answer
The DB is reliable, scalable, easy to use and resolves most DB needs
Ojoswi Basu | TrustRadius Reviewer

Return on Investment

Cassandra

  • I have no experience with this but from the blogs and news what I believe is that in businesses where there is high demand for scalability, Cassandra is a good choice to go for.
  • Since it works on CQL, it is quite familiar with SQL in understanding therefore it does not prevent a new employee to start in learning and having the Cassandra experience at an industrial level.
Anonymous | TrustRadius Reviewer

PostgreSQL

  • By pushing a lot of logic into database views and triggers, PostgreSQL provides the ability to write much slimmer and more maintainable controller code, reducing development costs.
  • PostgreSQL's upsert capabilities enabled us to go to scale much more easily and quickly, allowing us to increase our number of customers.
David McCann | TrustRadius Reviewer

Pricing Details

Cassandra

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

PostgreSQL

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Cassandra
8.2
PostgreSQL
9.3

Likelihood to Renew

Cassandra
8.5
PostgreSQL
9.0

Usability

Cassandra
7.0
PostgreSQL
9.0

Reliability and Availability

Cassandra
PostgreSQL
9.0

Performance

Cassandra
PostgreSQL
7.0

Support Rating

Cassandra
7.0
PostgreSQL
9.2

Implementation Rating

Cassandra
7.0
PostgreSQL
9.0

Scalability

Cassandra
PostgreSQL
8.0

Add comparison