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.
Open Source, Well Documented RDBMS
What do you like best about the product?
As a brand new user coming in with no SQL/database experience at all, I greatly appreciated the beautiful documentation of every single version of PostgreSQL at good ol' www.postgresql.org, especially the SQL commands reference.
What do you dislike about the product?
Slightly smaller community online, so for very specific issues, it may be more difficult to find help.
What problems is the product solving and how is that benefiting you?
Used it to efficiently manage large database of medical informatics data.
Recommendations to others considering the product:
Definitely read the beautifully written online manual and use Stack Overflow to look up any questions. Some of the learning is just knowing SQL commands. Also, be careful of exiting and leaving processes hanging (I would have to contact the database administrator to get these hung-up processes removed because of permissions issues).
- Leave a Comment |
- Mark review as helpful
Postgresql for the enterprise and to learn with
What do you like best about the product?
Elegance, intuitive feel. Great manual. Endless improvements.
What do you dislike about the product?
hard to keep up with all the enhancements!
What problems is the product solving and how is that benefiting you?
Recently used PG to clean and merge data from two Washington State sources on business owners.
Has every feature needed, including using it's unique DISTINCT ON() function.
Has every feature needed, including using it's unique DISTINCT ON() function.
The best open source RDBMS you will ever find
What do you like best about the product?
It is performant, reliable, free, with a totally unencumbering license.
What do you dislike about the product?
No built in REST API or easy web hooks out of the box.
What problems is the product solving and how is that benefiting you?
Transactional data.
Recommendations to others considering the product:
If you have to have an RDBMS and transactional data interactions, look no further. Built in C, runs on any platform. Has language bindings galore. Sets new standards in SQL options. Super stable and reliable. The pgadmin3 and the other frequently bundled tools are still awesome. You can also use Postgres as a nosql document db that works with SQL! (JSONB) Seriously, the best database you will find. Don't pay for oracle. Don't engender yourself to the toxic licensing of MySQL and other databases. Use this and don't hate life.
Works just fine
What do you like best about the product?
For the basic level of DB functionality that I need, I honestly see no difference between this or other similar software.
What do you dislike about the product?
Nothing, it works just fine for my needs.
What problems is the product solving and how is that benefiting you?
storing and access various large set of configuration settings, and snapshotting states of a system
Cost Effective alternative Databse
What do you like best about the product?
It's open source software and a large community that supports the incredible features that the database offers
What do you dislike about the product?
Nothing yet! Replication could be improved
What problems is the product solving and how is that benefiting you?
Most solutions do not need a heavy-weight database like Oracle or MS SQL; PostgreSQL offers a very convenient and powerful database that pack a lot of features.
Recommendations to others considering the product:
Do a cost / benefit analysis - this is fundamental for any new customer engagement solution that uses your product. A database is the core of any software application and you must understand and search out the issues and requirements that face the customer. Every implementation is unique and needs to be looked at holistically - architecture, security, performance, disaster recovery, reliability etc
Postgres review
What do you like best about the product?
PostgreSQL interfaces nicely with Django.
What do you dislike about the product?
I have no specific complaints for PostgreSQL.
What problems is the product solving and how is that benefiting you?
It was the data store for a Django based web UI.
A very convenient DBMS!
What do you like best about the product?
I like the ease of use, that it supports almost all sql contructs, free, and suitable to most projects, small or large
What do you dislike about the product?
The UI could be updated, but for a database server the current does the job and more
What problems is the product solving and how is that benefiting you?
It helps me a lot with data queries and exporting data from analytics solutions to the database and then to other solutions, or just me querying the data creatively!
Recommendations to others considering the product:
Try it, you won't regret it and it's for free!
Works well for my needs
What do you like best about the product?
Its simplicity and its ability to work with large datasets
What do you dislike about the product?
The default configuration is not optimal for the kind of work we do (large datasets and intensive queries). It requires significant tweaking.
What problems is the product solving and how is that benefiting you?
Access to large datasets and intensive queries.
A mature database management system
What do you like best about the product?
- very stable
- featurerich configuration, supports reconfiguring on fly
- lots of plugins (extensions)
- improving with each release
- ACID
- self-heal on start
- popular
- allows continuous backup and replication
- fast queries
- extended SQL (PG/SQL)
- fast restart
- has alot of GUI tools, has tuner program
- featurerich configuration, supports reconfiguring on fly
- lots of plugins (extensions)
- improving with each release
- ACID
- self-heal on start
- popular
- allows continuous backup and replication
- fast queries
- extended SQL (PG/SQL)
- fast restart
- has alot of GUI tools, has tuner program
What do you dislike about the product?
- had problems with WALs filling up disk space. After disk space is full, it is hard to start service - simply removing extra WAL files can make DB corrupt. So there should always be a method to quickly create free space on disk partition
- some configuration options can't be reconfigured on a fly (max_connections, listen_addresses)
- may be problematic to install on Windows (it involves creating dedicated user `postgres`, automatic, but our colleagues had problems with reinstalling)
- had problems with removing tablespaces
- had problems with table and index bloat (autovacuum not helping), requires periodic maintenance
-
- some configuration options can't be reconfigured on a fly (max_connections, listen_addresses)
- may be problematic to install on Windows (it involves creating dedicated user `postgres`, automatic, but our colleagues had problems with reinstalling)
- had problems with removing tablespaces
- had problems with table and index bloat (autovacuum not helping), requires periodic maintenance
-
What problems is the product solving and how is that benefiting you?
- managing large database for game data (using Hibernate ORM).
- data reliability
- data reliability
Recommendations to others considering the product:
- monitoring and alerting for disk size
- acompany with Barman backup manager
- use plugins/extensions (I recommend pg_repack plugin for database bloat redux)
- friend of mine recommends Amazon Data storage servers
- don't place indices on faulty disks - though they don't hold actual data, Postgres won't recreate them on device failure (I've placed indicies on a separate tablespace in instance store of EC2 server. After server reboot it was hard to start postgres)
- acompany with Barman backup manager
- use plugins/extensions (I recommend pg_repack plugin for database bloat redux)
- friend of mine recommends Amazon Data storage servers
- don't place indices on faulty disks - though they don't hold actual data, Postgres won't recreate them on device failure (I've placed indicies on a separate tablespace in instance store of EC2 server. After server reboot it was hard to start postgres)
A review of PostgreSQL
What do you like best about the product?
PostgreSQL seems to scale well compared to MySQL, which means that it's more capable than the latter to withstand a larger database and an increasing number of transactions and connections.
What do you dislike about the product?
The learning curve seems a bit steep compared to MySQL. And therefore, a beginner might struggle to get started with it. Pgadmin is also not as intuitive as PhpMyAdmin for example and takes a bit of time to get used to.
What problems is the product solving and how is that benefiting you?
A website side-project to gather quotes.
showing 551 - 560