1. Home
  2. Open-Source Database Software
  3. PostgreSQL Reviews
  4. User Review of PostgreSQL
PostgreSQL is great for storing large amounts of data
March 15, 2017

PostgreSQL is great for storing large amounts of data

Josh Stapp | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

It is being used to store 5TB of advertising data for our web app. It has a very fast response time and the JSON support is a nice feature. Since we already know SQL learning it has been easy and the index/pg tables contain a lot of helpful information for us to use.
  • Speed
  • JSON support
  • Widely used
  • Autovacuum problems
  • JSON speed
  • Doesn't clean up indexes well
  • Speed up data retrieval from MySQL
  • Crashed several times from Autovacuum hitting it's limit
  • Allows us to use JSON
Postgres had faster data retrieval for larger amounts than MySQL. The child tables have been a blessing and a curse at times but postgres seems to have a lot more detail about what is going on than MySQL with all of its user/pg/index tables and query planning. There is obviously an enormous amount of information around any SQL based DB.
It works better if you need JSON support. It's very fast and a little more complicated than MySQL especially with query planning. It's bad on keeping space usage small [for] dump/restore. The whole db shrank out 6TB DB to 2TB. Any large project I would definitely pick postgres just in case more advanced stuff is wanted later.