What users are saying about

Amazon DynamoDB vs PostgreSQL

Amazon DynamoDB

Top Rated
54 Ratings

PostgreSQL

155 Ratings

Amazon DynamoDB

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

Based on 54 reviews and ratings

PostgreSQL

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

Based on 155 reviews and ratings

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.

Read full review

No photo available
Verified User
View all 13 answers on this topic

PostgreSQL

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

Read full review

Venkateswar Reddy Thatikonda profile photo
Venkateswar Reddy Thatikonda
View all 24 answers on this topic

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

Read full review

No photo available
Verified User
View all 13 answers on this topic
  • Flexible data types
  • Very efficient and performant I/O
  • Robust table relationship mapping (ie. primary keys, sequences, etc.)

Read full review

No photo available
Verified User
View all 24 answers on this topic

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.

Read full review

No photo available
Verified User
View all 13 answers on this topic
  • PostgreSQL can provide richer auditing options as the current options are enough for few large enterprises
  • Replication can be improved

Read full review

Bhargav Nanekalva profile photo
Bhargav Nanekalva
View all 24 answers on this topic

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.

Read full review

No photo available
Verified User
View all 13 answers on this topic
PostgreSQL9.0
Based on 1 answer
As a needed software for day to day development activities

Read full review

Ojoswi Basu profile photo
Ojoswi Basu
View all 1 answers on this topic

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.

Read full review

Aaron Smith profile photo
Aaron Smith
View all 2 answers on this topic

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.

Read full review

Ojoswi Basu profile photo
Ojoswi Basu
View all 1 answers on this topic

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.

Read full review

Ojoswi Basu profile photo
Ojoswi Basu
View all 1 answers on this topic

Support

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

Read full review

Ojoswi Basu profile photo
Ojoswi Basu
View all 1 answers on this topic

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.

Read full review

Ojoswi Basu profile photo
Ojoswi Basu
View all 24 answers on this topic

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.

Read full review

Ojoswi Basu profile photo
Ojoswi Basu
View all 1 answers on this topic

Alternatives Considered

Richard Rout profile photo
Richard Rout
View all 13 answers on this topic
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

Read full review

No photo available
Verified User
View all 24 answers on this topic

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

Read full review

Ojoswi Basu profile photo
Ojoswi Basu
View all 1 answers on this topic

Return on Investment

  • Scalability out of the box
  • No server maintenance
  • Infrastructure comes for "free"

Read full review

Richard Rout profile photo
Richard Rout
View all 13 answers on this topic
  • 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.

Read full review

No photo available
Verified User
View all 24 answers on this topic

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
—