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.
Postgres
What do you like best about the product?
open source, large community, some nice functions that get updated.
What do you dislike about the product?
parallel queries not available yet.
not as frequent w/ patches or new function releases
not as frequent w/ patches or new function releases
What problems is the product solving and how is that benefiting you?
RDMBS for reporting and meta info storage
- Leave a Comment |
- Mark review as helpful
Awesome open source database
What do you like best about the product?
I love the large feature set built into Postgres. In particular, range queries are a godsend for time-based applications. Full-text search functionality means I don't have to bother with an elastic search installation. There is also much additional functionality that can be gained via extensions such as postgis.
What do you dislike about the product?
Replication can be a pain to configure compared to other DBs. Hosted solutions like RDS takes care of this though.
What problems is the product solving and how is that benefiting you?
I used Postgres for a scheduling web app. Because range queries are built in, it's a lot less effort to query compared to MySQL. It's also more efficient. I also use the full-text search functionality for our built-in knowledge base, as well as the trgm extension to order search results.
Recommendations to others considering the product:
If regulations require you to encrypt data at rest, Postgres might be problematic. Postgres does not support database level encryption out of the box. Encryption at rest could possibly be achieved via full disk encryption. You can get this on medium sized RDS instances on Amazon. Otherwise, there is an extension for row level encryption.
powerful open-source database option
What do you like best about the product?
PostgreSQL is well-documented, powerful, mature, and has a huge user base. Easy to find examples and forum postings when troubleshooting just about any scenario: the odd error message, problems using pgAdmin, figuring out how to integrate PostgreSQL into your node.js application.
What do you dislike about the product?
For some use-cases, PostgreSQL isn't the best option. It's worth considering your needs and looking at SQLite, MongoDB, and others.
What problems is the product solving and how is that benefiting you?
We needed an open source database for a variety of one-off web apps and dashboards. Postgres does a great job of it.
Simply the best
What do you like best about the product?
I am a huge fan of the robust data types and procedural capabilities in PostgreSQL. I used MySQL for many years simply because the setup process seemed easier than what PostgreSQL required. When PostgreSQL announced support for the JSON data type, I decided to bite the bullet and give PostgreSQL a more serious look. I've not touched MySQL since then.
In the years since JSON support landed in PostgreSQL, I've learned to appreciate the various options for implementing your own functionality using plpgsql and python. I've also experimented with various Foreign Data Wrappers (FDW) to expose data from other sources (filesystem, mysql, redis, other PostgreSQL instances, etc) as tables in PostgreSQL. I'm constantly impressed.
In the years since JSON support landed in PostgreSQL, I've learned to appreciate the various options for implementing your own functionality using plpgsql and python. I've also experimented with various Foreign Data Wrappers (FDW) to expose data from other sources (filesystem, mysql, redis, other PostgreSQL instances, etc) as tables in PostgreSQL. I'm constantly impressed.
What do you dislike about the product?
In today's day and age, redundancy and clustering are very important. Plenty of other databases out there offer relatively simple options for setting up replication, sharding, and automated failover. PostgreSQL doesn't have much built in to address these concerns. There are myriad projects that facilitate these important features, but none of them feel great to me. Perhaps I just need more time to invest in them.
What problems is the product solving and how is that benefiting you?
I've used PostgreSQL for a wide variety of tasks from simple structured data storage to data warehousing to powerful analytics. In every case, I've found PostgreSQL more than capable and quite pleasurable to use for the task at hand.
Recommendations to others considering the product:
Compared to MySQL, PostgreSQL is hands down the better option. More correct behavior when inserting and updating rows. Robust data type options. Long history of being fully open source. Vibrant community.
A solid database with a long track record
What do you like best about the product?
PostgreSQL has a long history as a go-to open source database with a full set of features, an active development and user community, and an accessible and robust toolset. Users of PostgreSQL and its derivatives (Vertica, RedShift) will feel equally at home. The toolset has remained largely compatible since I started using it around 1999.
What do you dislike about the product?
PostgreSQL isn't always the first to adopt new features, or to adapt to new changes in the computing world. This is two-way street: one way it means the platform is stable and its constraints are reasonably well-known, in the other direction it means that PostgreSQL misses out on performance opportunities around multi-core query execution, optimization for the shift of the CPU/RAM/SSD/disk balance, and clustering/failover.
What problems is the product solving and how is that benefiting you?
I have used PostgreSQL in a number of scenarios, including as a backend for MediaWiki, a hand-coded website, a SQL application ported from MySQL, a SQL app ported to Oracle, a Reporting database ported from Oracle, and some data warehouse/analytic tasks.
PostgreSQL performed admirably in each, with the caveat that the more one deviated from the traditional RDBMS with many small transactions, the more work was placed on the developer to optimize their data structures or query strategy to wring the most from the database.
PostgreSQL performed admirably in each, with the caveat that the more one deviated from the traditional RDBMS with many small transactions, the more work was placed on the developer to optimize their data structures or query strategy to wring the most from the database.
Recommendations to others considering the product:
Compare PostgreSQL to other platforms like MySQL, RedShift, Vertica. Decide on whether you want your database to do much of the optimization work for you (Vertica) or need to scale elastically (RedShift). Either way, PostgreSQL is a solid and free starting point that remains largely compatible with its cousins.
Great experience with PostGres
What do you like best about the product?
love the aggregate functions, also JSONB support, as well as views and materizlized views maintenance. very stable and secure. It is easy for me to maintain as an analyst
What do you dislike about the product?
certain data types are not good. i find the admin tools to not be amazing either
What problems is the product solving and how is that benefiting you?
I use postgres as a analytics data warehouse only. I allow acces for all other analysts, and sit analysis tools on top. this works quite well. I am often looking for ways to optimize queries tho
Recommendations to others considering the product:
i would recommend as a data analytics database. It can be difficult to scale and if you have a lot of data that doesnt easily translate into columns (json) unless you are using a vendor to complete ETL process. I love postgres tho :) Very stable and secure and documentation is great
My favorite database ever!
What do you like best about the product?
That's hard - I love how quickly it installs, I love that we get every feature we could hope for and more, it's fast, it's smart, the documentation is easily accessible and understandable without a "certification", when you get stuck on a problem, people that work on the product answer your questions on the forum!!
What do you dislike about the product?
Never sure how to pronounce the name!!!!
What problems is the product solving and how is that benefiting you?
We moved off of Oracle and life has been grand:
1. saving $$$$, for our company and our customers
2. our installs now take minutes instead of hours
3. we can use all of the features and not worry about an audit discovering we're using something we haven't paid for
4. the database is fast
1. saving $$$$, for our company and our customers
2. our installs now take minutes instead of hours
3. we can use all of the features and not worry about an audit discovering we're using something we haven't paid for
4. the database is fast
Recommendations to others considering the product:
Postrgresql is really everything you want from Oracle, but it's free AND easier to use.
New features come out regularly and if there are issues, they are fixed quickly instead of sometime years from now.
The documentation is really thorough and easy to use - for all of the features. There are add-ons that are well supported and that add even more amazing functionality.
I don't really know why you would choose any other database.
New features come out regularly and if there are issues, they are fixed quickly instead of sometime years from now.
The documentation is really thorough and easy to use - for all of the features. There are add-ons that are well supported and that add even more amazing functionality.
I don't really know why you would choose any other database.
PostgreSQL is the best database system I've used
What do you like best about the product?
Coming from a MySQL background, I love the variety of data types in Postgres: JSON, arrays, etc, all fill a need that MySQL didn't. I especially like how easy it is to manipulate dates, something that has sped up development a ton in terms of automated testing. The ability to enforce checks on insertion is very helpful, too. I've used NoSQL before, and I much prefer the rigidity of an RDBMS. All too often I've had to deal with corrupt data because of the temptation to fool around directly in the database rather than using the application layer.
What do you dislike about the product?
Probably the most difficult thing about Postgres is its permissions model. It's not very intuitive, in my opinion, and I think those issues need to be resolved before it can gain the sort of traction MySQL has. Right now it's just not easy for a beginner to get set up and secure.
What problems is the product solving and how is that benefiting you?
We've mainly used Postgres as an inventory system; nothing too fancy, but Postgres has made it much more enjoyable.
A good relational database for small and medium businesses
What do you like best about the product?
It's a good and not too heavy solution in terms of relational databases.
It's relatively smooth to install, has several good features and performs well.
It doesn't have too much of a steep learning curve.
There is good online support.
It's relatively smooth to install, has several good features and performs well.
It doesn't have too much of a steep learning curve.
There is good online support.
What do you dislike about the product?
There can be some issues installing it in a Windows environment.
Nothing impossible, but it can take time to solve them.
A total newby to relational databases could find it difficult to use it, especially as there is no GUI.
Nothing impossible, but it can take time to solve them.
A total newby to relational databases could find it difficult to use it, especially as there is no GUI.
What problems is the product solving and how is that benefiting you?
I'm using it with Ruby programming, and I think there is a good compatibily between the two.
I've got a powerful solution that is at the same time relatively light.
I've got a powerful solution that is at the same time relatively light.
PostgreSQL is user friendly software for database management
What do you like best about the product?
I use postgres as database in many different projects. Very easy to use. You can quickly learn to use this and create simple to complex queries.
What do you dislike about the product?
Nothing really to dislike. If required it can be enriched in user experience.
What problems is the product solving and how is that benefiting you?
I use this for a various projectdevelopment . It is very simple to use and can be effectively embedded.
Recommendations to others considering the product:
I used its as database in various project developments. Very easy to use. You can quickly learn to use this and create simple to complex queries.
showing 561 - 570