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 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
- Leave a Comment |
- Mark review as helpful
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.
Postgresql - the default database for new RoR projects
What do you like best about the product?
Solid SQL database, all standard SQL syntax supported with many nice extensions.
Stable
Excellent documentation and good develop support community
Full internationalization support
Good performance
Support for advanced SQL features, like "WITH" clauses and POSIX regular expressions
Built-in full text search (tsearch)
Support for distributed databases - master/slave replication
Lots of native "C" extensions
Right price - open source
Runs on Windows, OSX, and Unix
Installs on OSX using HomeBrew.
Stable
Excellent documentation and good develop support community
Full internationalization support
Good performance
Support for advanced SQL features, like "WITH" clauses and POSIX regular expressions
Built-in full text search (tsearch)
Support for distributed databases - master/slave replication
Lots of native "C" extensions
Right price - open source
Runs on Windows, OSX, and Unix
Installs on OSX using HomeBrew.
What do you dislike about the product?
PgAdmin tends to crash, losing your query, when you resize the query window. That's been true for over 5 years now. I wish they'd fix that. It might have flaws as larger scales that I use it at, but I haven't seen any yet.
What problems is the product solving and how is that benefiting you?
It's a database ;)
Recommendations to others considering the product:
Best open source database out there, definitely better than paid databases like Oracle, and probably better than SQL Server.
Best SQL Database integrates well with just about any server language
What do you like best about the product?
PostgreSQL is very robust, easy to use and has a nice documentation. It comes with a lot of built-in tools such as generating unique identifiers (UUID/GUID) and has many ready to use plugins such as PostGIS for geospatial querying. If your organization uses a relational database, then PostgreSQL is as good as it gets.
What do you dislike about the product?
As with any SQL database, PostgreSQL has a lot of limitations. The biggest limitation that in my application is full-text search. To be fair, PostgreSQL does come with some nice tools for full-text search, but relational databases are not designed for this stuff and you're better off using a specialized tool like ElasticSearch, which happens to work pretty well with PostgreSQL.
What problems is the product solving and how is that benefiting you?
We use PostgreSQL to keep track of our customer and business records.
Recommendations to others considering the product:
Make sure that you're comfortable with SQL before using PostgreSQL. Also read the documentaion
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
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)
showing 571 - 580