Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Save to My Lists
Claimed
Claimed

PostgreSQL Pros and Cons: Top 5 Advantages and Disadvantages

Quick AI Summary Based on G2 Reviews

Generated from real user reviews

Users find PostgreSQL's ease of use exceptional, praising its user-friendly interface and straightforward setup. (14 mentions)
Users appreciate the robustness and feature-rich capabilities of PostgreSQL, highlighting its extensibility and community support. (8 mentions)
Users appreciate the open source nature of PostgreSQL, enhancing accessibility and flexibility for various applications. (7 mentions)
Users value the exceptional customer support of PostgreSQL, benefiting from its robust community and extensive features. (4 mentions)
Users value the easy integrations of PostgreSQL, simplifying their development process with seamless cloud connectivity and user-friendly tools. (4 mentions)
Users find PostgreSQL beginner-unfriendly, as its complex documentation makes initial usage challenging for newcomers. (7 mentions)
Users find the difficult learning curve of PostgreSQL challenging, especially during initial setup and feature understanding. (5 mentions)
Users experience slow performance with PostgreSQL, particularly during large data queries and when importing CSV files. (5 mentions)
Users find feature limitations in PostgreSQL, noting fewer configuration options and GUI tools compared to competitors. (3 mentions)
Users find the initial setup complexity of PostgreSQL challenging, especially for newcomers, despite its powerful features. (2 mentions)

Top Rated PostgreSQL Alternatives

MySQL
(1,636)
4.4 out of 5

638 PostgreSQL Reviews

The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
638 PostgreSQL Reviews
4.4 out of 5
638 PostgreSQL Reviews
4.4 out of 5

PostgreSQL Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
Verified User in Electrical/Electronic Manufacturing
UE
Mid-Market (51-1000 emp.)
"Good for the price, if you know what I mean"
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.

Verified User in Higher Education
CH
Enterprise (> 1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Rock Solid stability"
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.

Verified User in Computer Software
UC
Enterprise (> 1000 emp.)
"No SQL DB "
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.

Carson W.
CW
CTO
Small-Business (50 or fewer emp.)
"Powerful, Flexible, Database"
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.

Verified User in Computer Software
AC
Enterprise (> 1000 emp.)
"Fast growing RDBMS"
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.

Verified User in Internet
UI
Mid-Market (51-1000 emp.)
"Massively parallel processing data warehouse"
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.

SUBHA P.
SP
Technical Lead
Enterprise (> 1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"MULTI SPECIALITY DATABASE WITH ZERO COST "
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.

VB
Business Analyst
Enterprise (> 1000 emp.)
"3 years of PostgreSQL"
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.

Nairoby D.
ND
Administrador de Bases de Datos (DBA). Consultor TI
Enterprise (> 1000 emp.)
"Free code database manager"
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.

DL
Python Dev
Small-Business (50 or fewer emp.)
"Postgres is fine"
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.

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
PostgreSQL