What users are saying about
Top Rated
54 Ratings
155 Ratings
Top Rated
54 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101
155 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.8 out of 101

Add comparison

Likelihood to Recommend

Amazon DynamoDB

Storage of data such as logs, where the data does not needed to be manipulated much or at all. The tables would need to be very simplistic. It would be less appropriate for complex systems since the ability to modify data is limited.
No photo available

PostgreSQL

1. Open source and object relational2. Great community3. New versions for every six months and very stable4. Support for JSON, XML and Geospatial
Venkateswar Reddy Thatikonda profile photo

Feature Rating Comparison

NoSQL Databases

Amazon DynamoDB
7.9
PostgreSQL
Performance
Amazon DynamoDB
8.0
PostgreSQL
Availability
Amazon DynamoDB
8.4
PostgreSQL
Concurrency
Amazon DynamoDB
9.0
PostgreSQL
Security
Amazon DynamoDB
8.7
PostgreSQL
Scalability
Amazon DynamoDB
9.7
PostgreSQL
Data model flexibility
Amazon DynamoDB
4.0
PostgreSQL
Deployment model flexibility
Amazon DynamoDB
7.3
PostgreSQL

Pros

  • Quick CRUD operations
  • Easy to maintain and manage
  • Cost Effective
No photo available
  • Flexible data types
  • Very efficient and performant I/O
  • Robust table relationship mapping (ie. primary keys, sequences, etc.)
No photo available

Cons

  • Nothing much in particular, however I feel it would be nice if it provides additional features like pre-defined templates, quick user guides in the console itself directly.
No photo available
  • PostgreSQL can provide richer auditing options as the current options are enough for few large enterprises
  • Replication can be improved
Bhargav Nanekalva profile photo

Likelihood to Renew

Amazon DynamoDB7.1
Based on 13 answers
As I said earlier, DynamoDB works well for our application. There's a few shortcoming but there's workarounds for almost everything.
No photo available
PostgreSQL9.0
Based on 1 answer
As a needed software for day to day development activities
Ojoswi Basu profile photo

Usability

No score
No answers yet
No answers on this topic
PostgreSQL9.0
Based on 2 answers
If you are used to using Microsoft SQL Server, the tooling around PostgreSQL is not as good. Some new solutions by Devart and open source projects like DBeaver help, but it's just not as good. However, that really won't matter if you are just writing scripts and queries anyway.
Aaron Smith profile photo

Reliability and Availability

No score
No answers yet
No answers on this topic
PostgreSQL9.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 profile photo

Performance

No score
No answers yet
No answers on this topic
PostgreSQL7.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 profile photo

Support

No score
No answers yet
No answers on this topic
PostgreSQL9.0
Based on 1 answer
Easy, quick, to the point support
Ojoswi Basu profile photo

Online Training

No answers on this topic
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 profile photo

Implementation

No score
No answers yet
No answers on this topic
PostgreSQL9.0
Based on 1 answer
The online documentation of the PostgreSQL product is elaborate and takes users step by step.
Ojoswi Basu profile photo

Alternatives Considered

Richard Rout profile photo
I found PostgreSQL to be better compared to MySQL. The community support is very good. Some features that I feel are not present in MySQL are:
  • No referential integrity.
  • No constraints (CHECK).
  • No sort merge join, let alone hash-join.
  • Generally poor at analytical workloads, since it's designed for transactional workloads.
  • No group commit
No photo available

Scalability

No score
No answers yet
No answers on this topic
PostgreSQL8.0
Based on 1 answer
The DB is reliable, scalable, easy to use and resolves most DB needs
Ojoswi Basu profile photo

Return on Investment

  • Scalability out of the box
  • No server maintenance
  • Infrastructure comes for "free"
Richard Rout profile photo
  • Reliable data storage, with easy backup and restore capabilities.
  • Low overhead. PostgreSQL can easily run on very large instances, but its actual resource overhead is such that it runs well on very small instances too.
  • Open source and free. Only investment required is the time required to install and learn how to configure it. Almost everything else is common knowledge for any SQL-based RDBMS.
No photo available

Pricing Details

Amazon DynamoDB

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

PostgreSQL

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