What users are saying about

Amazon Aurora

42 Ratings

PostgreSQL

146 Ratings

Amazon Aurora

42 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101

PostgreSQL

146 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Add comparison

Likelihood to Recommend

Amazon Aurora

Amazon Aurora (as is MySQL) is better suited for light to medium applications considering it still has some performance limitations from MySQL. I would not recommend it for enterprise level use without a carefully constructed backend system (code and database). My company's current backend architecture was not mapped out very well and this leads to performance problems that even Amazon Aurora has not been able to completely sort (although it has been a huge help). Another area where I am finding it beginning to lack is for use in data warehousing. The more rows added, the less performant I'm finding the data warehouse. Although to be fair, Amazon has another product (Redshift) that we are looking to migrate data warehouses into.
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

Pros

  • The MySQL compatibility meant we didn't have to change anything in our system which used to run on a MySQL database. It was a very simple configuration change to point at the new instance once set up
  • Much better performance than our previous MySQL database (hosted on AWS RDS) for lower costs due to the way storage is managed
  • Storage management is much more simple as it grows and shrinks with you without having to allocate and deallocate storage to the database
Andrew Raines profile photo
  • Broad array of custom functionality/formulae built atop standard SQL statements
  • Transactional support for schema migrations
  • Great low-level performance tuning capabilities
  • Performant implementation of bulk merge (upsert)
David McCann profile photo

Cons

  • I'd like to see Amazon Aurora get ahead of the curve on MySQL and introduce their own improvements to MySQL to make it a superior database so that I don't need to use SQL Server or Oracle to get performance improvements. For example, improve performance of views.
  • Amazon Aurora needs to improve the ability to restore backups as needed. Currently, the user can only restore an entire instance to a new or existing RDBMS instance. If you need to retrieve data from a single table, this can be tedious after waiting hours for an entire restore to complete. Instead, allow the user to select a database to restore. Better yet, allow the user to restore a database backup to ANOTHER database - which would allow you to restore a database on the same instance.
  • Again beat MySQL to the punch and introduce REAL server to server communication since they have disabled the "Federated Engine" which was the only way previously to do this. I'd like to be able to setup MySQL instances to talk to other MySQL instances.
No photo available
  • Hard learning curve if you are unfamiliar with SQL databases
  • The graphical tooling isn't as good as some of the tools provided by Microsoft for the example.
  • Can be hard to figure out what went wrong unless you know how.
Richard Rout profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
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
PostgreSQL8.0
Based on 1 answer
There are a few areas of improvement
Ojoswi Basu 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

In the end, we went with Amazon Aurora due to the decent performance and cost. Cost was determined in two ways for us: 1) no additional license is required (such as using SQL Server or Oracle) and 2) the ability to cut down on needed resources to maintain the system from the maintenance perspective due to the built-in maintenance capabilities. Amazon Aurora is also based on MySQL (soon to include PostgreSQL ) which allowed my team to quickly and easily move our existing MySQL servers to a faster system.
No photo available
We evaluated MySQL, Postgres, MSSQL Server and a few other hosted options. We loved the fact that PG is both a GIS system and a traditional RDBMS. The mindshare around PG is high -- thousands of answers on StackOverflow, very active developer community and a punctual release schedule. PG is a standout open source product.
Anatoly Geyfman profile photo

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

  • Moderately reduced database running costs
  • Improved performance of database cluster which in turn has had a positive impact on the response times of our API services
Andrew Raines 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 Aurora

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