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.
Good for the price, if you know what I mean
What do you like best about the product?
It's easy to use, it solves the issue and lets you do most of your work.
My favorite is definitely the foreign data wrapers, which provides a standardized way to access and manipulate data stored externally to the Postgres server you’re connecting to.
My favorite is definitely the foreign data wrapers, which provides a standardized way to access and manipulate data stored externally to the Postgres server you’re connecting to.
What do you dislike about the product?
A few of my complains:
I dont like that it doesn't let you edit queries when you try to edit a quick select that the tool auto generated.
The MONEY type is horrible. Run away. Use NUMERIC.
To write procedural code you need a DO LANGUAGE plpgsql $$ BEGIN ...code here ... END; $$; block. You can't write it inline like you can PL/SQL or T-SQL. (On the other hand, it helps reduce the amount of DBMS-specific SQL extensions and procedural code sneaking into the application's queries).
Don't use more than 1000-ish columns. There's a hard limit somewhere around 1400, depending on data type, but usually lower.You cannot remove typenames from an enum data type. Though you can add new ones.
I dont like that it doesn't let you edit queries when you try to edit a quick select that the tool auto generated.
The MONEY type is horrible. Run away. Use NUMERIC.
To write procedural code you need a DO LANGUAGE plpgsql $$ BEGIN ...code here ... END; $$; block. You can't write it inline like you can PL/SQL or T-SQL. (On the other hand, it helps reduce the amount of DBMS-specific SQL extensions and procedural code sneaking into the application's queries).
Don't use more than 1000-ish columns. There's a hard limit somewhere around 1400, depending on data type, but usually lower.You cannot remove typenames from an enum data type. Though you can add new ones.
What problems is the product solving and how is that benefiting you?
Management of big sql databases, with lots of data stored, partitioned tables, triggers and Hash, GIN and BRIN Indexes.
In particular this last indexes with allow us to boost our performance for several important queries.
In particular this last indexes with allow us to boost our performance for several important queries.
Recommendations to others considering the product:
It's a good starter to advanced tool to use. I highly recommend it if you are a little lost of dont know where to start. You can basically do everything you aim for without getting into very specific types and functions.
Give it a try, you can run it locally for free and decide for yourself.
Give it a try, you can run it locally for free and decide for yourself.
- Leave a Comment |
- Mark review as helpful
Great Database
What do you like best about the product?
Ease to implement and rock solid performance
What do you dislike about the product?
New features are not released immediately to the open community
What problems is the product solving and how is that benefiting you?
Used to host an external website using all freeware software.
Recommendations to others considering the product:
Great database the has most of the same SQL as Oracle.
Backbone of our stack
What do you like best about the product?
Postgres is an incredibly stable database workhorse. It handles production traffic with ease, and its default settings are generally very stable and scalable. It links easily to all sorts of ETL tools and supports all major ORM libraries.
What do you dislike about the product?
Well, just like any SQL database, by default it's not vertically scalable. So once you can't upgrade your database server hardware further, you sort of hit a cap, until you put in sharding logic.
What problems is the product solving and how is that benefiting you?
Running our business and powering our website
Recommendations to others considering the product:
Realize that, if you're going to use this for production, you need DB experts on your team, even if you're getting postgres from AWS or from Heroku
Postgre SQL review from Sipeyiye Intelligence Pty
What do you like best about the product?
it has the easiest database interface which is very user-friendly with proper query return space
What do you dislike about the product?
it does not have the feature of table or schema prediction, makes it laborious and time-consuming typing a search
What problems is the product solving and how is that benefiting you?
I created a database and tables for a client . also created logins for other end users from the client side and allowed them to have host capabilities as well
light weight opensource DB
What do you like best about the product?
Its opensource, lightweight DB. It provide good features to play with JSON structured data. More intuitive features available like filter , sorting , structuring data using Json syntax.
Most preferable db on cloud. very easy to optimize and analyze query performance .
Most preferable db on cloud. very easy to optimize and analyze query performance .
What do you dislike about the product?
crash when play with millions of data. quiet slow processing with millions data. Need to setup always custom configuration for best performance. some Query syntax is different from other PL/SQL
What problems is the product solving and how is that benefiting you?
Produce data in Json structure which help api to return response as it is. it save time to reprocess data in json structure. compatible with cloud so we used.
Recommendations to others considering the product:
best for opensource DB and light weight and easy installation
Postgres Review
What do you like best about the product?
It's an incredible comprehensive software that doesn't have the same ACID problems as mysql
What do you dislike about the product?
Well sometimes its hard to find a stable UI for the platform
What problems is the product solving and how is that benefiting you?
Analytics for clients
PostgreSQL is great for database management!
What do you like best about the product?
PostgreSQL allows us to easily run queries and cross-reference information from various tables of data we have stored. As a subscription-based service with millions of user emails and information, this is extremely important.
What do you dislike about the product?
While simple for someone who knows SQL there is a learning curve. It would be amazing if PostgreSQL allowed for easy implementation of a UI that was friendly to those who are not familiar with the coding behind queries to run searches in order to pull information from various sources.
What problems is the product solving and how is that benefiting you?
We are able to search our information for potential abuse by users, as well as find accounts that may have been impacted by a bug in our system and mass resolve issues. More recently as we migrated billing systems some accounts had fallen through the cracks and were not billed in a few months. We were able to use PostgreSQL to write a query in order to find those accounts and bill them going forward.
PostGreSQL awesome tool
What do you like best about the product?
Opening the database is very easy and simple, also the filter options are very simple for anyone with minimal explanation
What do you dislike about the product?
i dont see anything that can be said as dislike, it does what is needed
What problems is the product solving and how is that benefiting you?
We have RPA tool and all the source code are maintained in this database only which helps us easily to monitor the entire framework and maintain it in a efficient way
Good database
What do you like best about the product?
I have been using postgresql for 8 years as a lead developer. We prefer it over MySQL
What do you dislike about the product?
What I dislike is that it can be difficult to set up as a local environment.
What problems is the product solving and how is that benefiting you?
We use it to store customer data.as it’s acid compliant.
Recommendations to others considering the product:
X
Good opensource tool
What do you like best about the product?
Postgre SQL is a good open source tool to handle large amounts of data. It is cheaper compared to other tools available in the market. The installation process is very fast and smooth. Easier to integrate with a variety of ETL tools such as Informatica.
What do you dislike about the product?
The free version has a lot of restrictions with security control and speed. We wanted to test this tool before we get a paid service but could not explore more in the free version.
What problems is the product solving and how is that benefiting you?
Data reliability with this tool is second to no one.
showing 251 - 260