PostgreSQL highly reliable and flexible for enterprise level applications
April 12, 2016

PostgreSQL highly reliable and flexible for enterprise level applications

Zach Warren | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

BMC Software's Control-M application utilizes PostgresSQL to provide an enterprise batch solution for our enterprise. The database is packaged and deployed as part of the Control-M suite of products. While only deployed to support this application, we have seen quite an improvement with scalability and reliability since migrating off of Sybase about 7 years ago.
  • I find that the PostgreSQL database has well documented and polished documentation compared to other database types I have looked at.
  • While I'm not a power user, queries are easy to construct and there are good open source tools to work with PG.
  • Our PG databases have been extremely reliable and fast which is really the greatest benefit. We have seen no downtime due to any database related issues.
  • While the documentation I feel is great, I do find at times that finding examples or answered questions online is not as easy as more widely used databases such as MySQL. Otherwise we have been completely satisfied with the PG database and have no complaints.
  • The PostgreSQL databases host one of our largest enterprise applications so it is extremely important to have a fast and reliable infrastructure underneath. The biggest impact since switching off Sybase has been speed and reliability. I won't say 100% but we've had 99.99% uptime in the last 7-8 years with PostgreSQL as our application database.
  • Sybase
PostgreSQL conforms to SQL-standard and handles high read/write much better in my opinion. While I haven't used Sybase in quite a while, a factor that was appealing for PostgreSQL was the fact that access control is more robust. When we ran short on space in Sybase, it had to be extended. After several extends it appears to have a negative effect on performance. We liked that the PG database naturally expands and contracts within the limits of the file system.
We have a very high count of reads/writes and the PG database has proven to accommodate this very well. PostgreSQL also seems to be user friendly to non-DBAs. I'm no database expert but I have no problem pulling data, constructing queries and accessing the data through scripts and other tools. We also like how the database expands into the filesystem with no need to extend it.