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. Review collected by and hosted on G2.com.
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. Review collected by and hosted on G2.com.
PostgresSQL is one of the most stable and functionally rich open source RDBMS. It performs really well while implementing complex queries. It is also convenient to shift your database architecture into PostgresSQL. Because of its ubiquity, you can find solutions to any issue you might face on the online community. , PostgreSQL is offering an amazing amount of functionality for any database, let alone an open-source project. And in almost every case, the current functionality is just the first part of a long-term roadmap that the developers will continue to follow. Review collected by and hosted on G2.com.
PostgreSQL's functionality in areas like Partitioning or query parallelization has been fairly weak. Also it's syntax is a wee bit different than most of the other SQL vendor languages but it's not significantly different. Review collected by and hosted on G2.com.
It is an open source tool. The best thing about PostgreSQL is that it's a really good tool for complex data-models. It's a one stop solution for almost all sort of data problems. Review collected by and hosted on G2.com.
Installation and configuring it is a little challenging. It's Usability and learning curve is pretty high. psql command line will seem foreign compared to other sql queries and it needs a cheat sheet to learn and memorize the commands. Review collected by and hosted on G2.com.
I have used this database for a number of years now and have to say it gives one the most bang for one's buck. It is extremely powerful, and flexible with the addons provided, hstore, jsonb, ltree etc. its by default powerful, so if you're looking for a simple database this is not for you. This database is still fairly easy to use, but it leaves out a lot of things that are default to mysql (mariadb) Review collected by and hosted on G2.com.
I wish that the ltree implementation supported dashes so full uuids could be used. Otherwise there isn't really that much to complain about, better support for built in under the hood horizontal sharding would be nice but that would be hugely complicated and probably wouldn't work. Review collected by and hosted on G2.com.
Its an open source database, flexibility to tweak code to suit your needs, active developer community, stability and internal design. JSON support. Available modified versions like TimeScaleDB which scales really good. Review collected by and hosted on G2.com.
No native support of multi-master. Have to rely on commercial vendors. Bugs in logical decoding which restricts reliable integration with kafka. Review collected by and hosted on G2.com.
We use Postgresql for our data warehouse and we love the software because of its capability to handle complicated SQL queries for financial analysis and other workflows. Review collected by and hosted on G2.com.
I dislike that Postgresql has many types of databases and you have to choose the proper one to get the correct degree of efficiency. Review collected by and hosted on G2.com.
Open source ,highly secure, good concurrency control.
Designed with minimal configuration files as PostgreSQL.conf and pg_hba.conf yet powerful
Has very good inbuilt replication and minimum data loss
Can have contrib modules as extensions
PostGIS is an excellent one for GIS systems
Multiple high effective availability solutions for PostgreSQL(REPMGR,PATRONI etc) &Load balancers(pgpool,pgbouncer) are available
Very simple GUI tool for developers.pgAdmin
good bench marking tool pgbench Review collected by and hosted on G2.com.
Lack of support on the new versions
Could have given better performance in windows environment Review collected by and hosted on G2.com.
Free database manager, with only download and install you can have the world of databases in full, with the best options of any proprietary driver, it is easy to install especially in free operating systems, it is ideal for database relational data, in terms of support, the best ally is the community of people who help others through forums, it is compatible with several graphic tools if they do not like to use the console, configuring a cluster is super simple and on the Internet the information works wonderfully with large databases. Review collected by and hosted on G2.com.
If you use postgres by console and not with any graphical tool such as pgadmin or dbeaver you must have intermediate knowledge, you may notice some slowness in massive insertions but this is related to the good design of the database Review collected by and hosted on G2.com.
The built in full text search functionality. Review collected by and hosted on G2.com.
The Admin UI, it is difficult to learn, and hard to do simple things like look at a table in the DB Review collected by and hosted on G2.com.