PostgreSQL 9.5
Jetware | 170503-postgresql_9_5_6Linux/Unix, Amazon Linux 2017.03.0 - 64-bit Amazon Machine Image (AMI)
Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
Great, but size problems
What do you like best about the product?
Fast fetching large data. Able to store and somewhat able to search json blobs. Able to use inheritance in tables. Based on well known sql language. Lots of info in admin tables
What do you dislike about the product?
The size grows like crazy. After a db export/import it can shrink to 30% the size with the exact same DB which means lots of space was wasted. Tons of tables can be slow to vacuum and that can cause a DB crash.
What problems is the product solving and how is that benefiting you?
Storing masses of ads on search engine result pages.
It pulls back masses of data faster than we got with mysql
It pulls back masses of data faster than we got with mysql
Recommendations to others considering the product:
Preferred over my experience with sql and nosql DB
- Leave a Comment |
- Mark review as helpful
PostgreSQL for storing Advertising Analytic Data
What do you like best about the product?
The speed in conjunction with the native JSON support. With the on the horizon 9.5 the added features will only deepen my appreciation for Pg. Being able to have all the functionality of a NoSQL type DB on top of a a traditional RDMS makes using something like Couch/Mongo obsolete.
What do you dislike about the product?
I am not the biggest fan of the vacuuming that is required for larger datasets. Eventually most people hit the dreaded "transaction wraparound" error if they are not careful and it is a nightmare to recover from sometimes.
What problems is the product solving and how is that benefiting you?
We were solving the problem of having non-relational data taht was always changing (think ad copy and sections) but tying it to relational data. PostgreSQL allows us to have the best of both worlds.
Recommendations to others considering the product:
At least give it a shot. Aside from time you have little to lose if it does not work out. The community behind it is huge and growing by the day.
Main OLTP engine for a multi-tenant application
What do you like best about the product?
Flexibility, fullness of features and easy extensibility.
for almost anything you might want there's usually an extension that provides this - if not, it's very easy to write your own.
other than that you have the basics fully covered, Loads of SQL features, fast performance, HA,...
Also, the lack of centralized data dictionary is greatly simplifying design for multi-tenancy applications as it allows for a straightforward approach.
Last but not least, postgresql as a product advances in an impressive rate, catering for more and more use cases and deployment options, with great emphasis on performance and data consistency.
It's exciting to see the product and community evolve - make a quick comparison between 9.2 & 9.5 and you'd be amazed what a couple of years can do.
for almost anything you might want there's usually an extension that provides this - if not, it's very easy to write your own.
other than that you have the basics fully covered, Loads of SQL features, fast performance, HA,...
Also, the lack of centralized data dictionary is greatly simplifying design for multi-tenancy applications as it allows for a straightforward approach.
Last but not least, postgresql as a product advances in an impressive rate, catering for more and more use cases and deployment options, with great emphasis on performance and data consistency.
It's exciting to see the product and community evolve - make a quick comparison between 9.2 & 9.5 and you'd be amazed what a couple of years can do.
What do you dislike about the product?
It's still behind some of the big players in terms of the optimizer - it lacks many smart optimizations which means that for really complex stuff, you are still better off with Oracle or SQL Server.
(then again remind yourself of the bill :) )
(then again remind yourself of the bill :) )
What problems is the product solving and how is that benefiting you?
We use PostgreSQL as our main OLTP server - almost all of our on-line flows go through PG.
It's great for multi-tenancy, it allowed us to scale well while using a rather simple data structure.
(this in terms translates to a high DEV rate)
It's great for multi-tenancy, it allowed us to scale well while using a rather simple data structure.
(this in terms translates to a high DEV rate)
Recommendations to others considering the product:
If you're looking for an OLTP engine for a medium sized DB (100s of GB) you're in PGs sweet spot.
It's free and you'd hardly get any benefits from using commercial products here.
The community support is awesome and very responsive. (and you have plenty of companies doing payed support if needed)
It's free and you'd hardly get any benefits from using commercial products here.
The community support is awesome and very responsive. (and you have plenty of companies doing payed support if needed)
the best open source database
What do you like best about the product?
it's open source, free, (relatively) easy to setup. It comes with a bunch of killer features (hstore, json, live queries) It's being updated frequently. There are lots of tools that are built around it.
What do you dislike about the product?
Scaling and performance tweaking is kind of tricky. No commercial support. Community support is OK (but not as good as MySQL imo)
What problems is the product solving and how is that benefiting you?
Affordable, high performing database, that can be deployed in the cloud.
NoSQL-like features (e.g. hstore/json) support.
NoSQL-like features (e.g. hstore/json) support.
A great Alternative to MS Sql
What do you like best about the product?
Postgresql is a very lightweight cross platform solution.
This makes it a perfect alternative to some of the larger commercial solutions out there right now.
The community behind it is also first class, loads of support is available via the forums when needed.
My favorite feature however is replication.
Although you will be editing text based config files to get set up, you can literally have one database replicating to another in half an hour(for basic configs).
I know this is possible with other commercial tools, but Postgres is free to use.
I use it for all of my personal projects when possible.
This makes it a perfect alternative to some of the larger commercial solutions out there right now.
The community behind it is also first class, loads of support is available via the forums when needed.
My favorite feature however is replication.
Although you will be editing text based config files to get set up, you can literally have one database replicating to another in half an hour(for basic configs).
I know this is possible with other commercial tools, but Postgres is free to use.
I use it for all of my personal projects when possible.
What do you dislike about the product?
Its a little tricky to configure for those who are used to graphical interfaces like in MS SQL server.
What problems is the product solving and how is that benefiting you?
Really again the replication has allowed us as an ISV to offer enterprise level service to clients whom may not otherwise have been able to afford to do it with commercial offerings.
Recommendations to others considering the product:
Join the communities and read as much as you can about the config.
Dip your toe in and you will be surprised what Postgresql can do and how fast it can be.
Dip your toe in and you will be surprised what Postgresql can do and how fast it can be.
postgresql review
What do you like best about the product?
I've worked with many relationnal databases over the years and mysql was my goto solution for web development for a while. Until I was forced to use postgis extension of postgresql for a geospatial data storage project. Since then, postgresql became my defacto databse.
Very reliable, great performance and advanced features make postgresql a solution for midium to large deployment. Advanced data types, especially spatial in my case, rich feature sets and the possibility to write stored procedures in python are a deal sealer.
It's also opensource, with a good support and a welcoming community.
Very reliable, great performance and advanced features make postgresql a solution for midium to large deployment. Advanced data types, especially spatial in my case, rich feature sets and the possibility to write stored procedures in python are a deal sealer.
It's also opensource, with a good support and a welcoming community.
What do you dislike about the product?
Nothing really, but there is some known gotcha and behaviors that can be confusing for new users. Reading the documentation is a must even if you have a background with other RDBMS.
Tunning the performance of the system is up to the database administrator and the number of options can be overwhelming sometime.
Tunning the performance of the system is up to the database administrator and the number of options can be overwhelming sometime.
What problems is the product solving and how is that benefiting you?
Postgresql is really the most advanced and reliable database that we have used yet. We are using it in conjunction with Django web framework and a geospatial systems using the postgis extension.
The cost/quality ration is just unparalleled with any other solution.
The cost/quality ration is just unparalleled with any other solution.
Recommendations to others considering the product:
Postgresql is a very advanced database system with an emphasis on extensibility and customization. The documentation is quiet large and the options multiple and you will likely take you a long time to figure it all out but it's all worth it in the end.
ACID transcations for the Win
What do you like best about the product?
ACID is one of the main features that you will need when programming mission critical applications and postgres has it inbuilt. We can also change the transaction isolation level which is very needed for performance. Consistency is also very good you will never have data corrupution or data lost. JSON support in the latest version has made it very easy for us now since we don't need to migrate the schema always like before.
What do you dislike about the product?
Scalability and High availability are major issues in sql databases and in postgres its even harder since there no proper tool to do it. It locks the row on serializale transactions which is really a problem in certain cases. Many databases have other means to solve this.
What problems is the product solving and how is that benefiting you?
We Are solving Customer Engagement and Employee Engament. We Have Created a Cloud based gamification system where users can build and wire up their business rules and logic and then integrate it into their systems. We don't have any random errors anymore and programming has become easier since we don't need to handle some edge cases anymore.
Recommendations to others considering the product:
Yes. If you really don't want uncertainities in your data and want ease of coding then postgres is one of the best. Its also open source and the development work on it is really good.
Powerful free open source Database
What do you like best about the product?
I like that is very powerful and also free. It has a lot of interfaces for almost every programming language and lets you storage big objects, like pictures, videos and sound files.
What do you dislike about the product?
I don't like the tool pgAdmin, that lets you manage your databases graphically. It doesn't work well, is really slow, doesn't have prediction when you are writing queries and also stops working without any reason.
Another thing that I don't like is that you have to use LIMIT x instead of TOP x to get some x quantity of rows
Another thing that I don't like is that you have to use LIMIT x instead of TOP x to get some x quantity of rows
What problems is the product solving and how is that benefiting you?
I had to manage the databases of my university, so we move from MySQL to PostgreSQL because it was free, allowing the university save some money, but also it is very useful and potent database manager.
Recommendations to others considering the product:
Really give it a try. It is very powerful and easy to install and setup. Also it has a graphic tool that let you see how the data is storage in rows and columns
Great Tool for using SQL at a novice level
What do you like best about the product?
It is a super powerful tool with the ability to get the job done with work with your database. I am newer to SQL and have found this tool to be great with my skill level. I love the ability to export the files I need and the speed in query execution.
What do you dislike about the product?
Sometimes it can run a little slow and that can be unpredictable without reason. Most times it's very fast, but when it bugs out, you have to restart and it just can be a pain.
What problems is the product solving and how is that benefiting you?
Working through different databases building out reports for customers based on the different tables.
PostgreSQL has been the perfect tool
What do you like best about the product?
Postgres has been an incredible open source tool for our company as we've grown. We switched from MySQL, which we quickly outgrew, and have been going strong on a Python+PostgreSQL build ever since. It's easy to get new DB users up and running on simple tasks, and has great flexibility with its user defined functions.
What do you dislike about the product?
All the graphical query tools that are also free are mediocre at best. There are some really good ones, but they require a subscription.
What problems is the product solving and how is that benefiting you?
Proprietary and client data storage in an easily accessible form as well as powering our software interface by building out data tables on the back end.
Recommendations to others considering the product:
Its open source, give it a shot, you won't regret it.
showing 571 - 580