1. Home
  2. Open-Source Database Software
  3. PostgreSQL Reviews
  4. User Review of PostgreSQL
PostgreSQL on Amazon RDS
April 28, 2017

PostgreSQL on Amazon RDS

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

PostgreSQL is used organization wide. We are a very federated organization and each team maintains its own instances of PostgreSQL. We use it through Amazon RDS. PostgreSQL is used to maintain transactional data about our acquisition customers and for AML.
  • PostgreSQL is good for transactional forms of data. Better support than the proprietary vendors RDBMS and is very reliable. You can query data like in any other RDBMS. It also provides Java and JS drives for connecting to your application and querying.
  • If you are using Amazon RDS then Postgres is available as an option with Amazon for managing your instances. So that is very convenient.
  • It is the most advanced, SQL-compliant and open-source objective-RDBMS. It is very reliable for relational data as well as storing blobs of JSON in its tables.
  • One drawback that I have personally experienced is that it is a bit harder to get community support or to Google for results. However, with more use of PostgresSQL the community support is getting better.
  • My organization was already using Amazon AWS for most of our cloud applications. This way we could use open-source PostgreSQL that is provided on Amazon RDS and ultimately it is maintenance free.
  • With Amazon RDS, you can deploy scalable PostgreSQL deployments in minutes with cost-efficient and resizable hardware capacity. Amazon RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades; storage management; replication for high availability and read throughput; and backups for disaster recovery.
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
  • Postgres is starting to support parallel (multi-core) queries in 9.6
  • Postgres supports materialized views
  • PostgreSQL has better/consistent interface when working with date/times
  • Has very good tooling - PostgreSQL pgAdmin IV
  • It supports all sorts of performance optimisation that you're used to from Oracle, SQL Server.