PostgreSQL is great for storing large amounts of data
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.
Pros
- Speed
- JSON support
- Widely used
Cons
- 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.
Comments
Please log in to join the conversation