PostgreSQL Pros and Cons

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

Lack of support on the new versions

Could have given better performance in windows environment Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

postgreSQl supports ACID nd transaction, it has divert indexing technique and flexible full text search. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

None as of now

Review collected by and hosted on G2.com.

What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What do you like best about PostgreSQL?

The built in full text search functionality. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

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.