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

Top Rated PostgreSQL Alternatives

MySQL
(1,636)
4.4 out of 5

PostgreSQL Reviews & Product Details - Page 25

PostgreSQL Overview

What is PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQL Details
Show LessShow More
Product Description

PostgreSQL is a powerful, open source object-relational database system.


Seller

PostgreSQL

Description

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:
008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

Overview Provided by:
CTO at Coronys LTD.

PostgreSQL Integrations

(3)
Integration information sourced from real user reviews.

Recent PostgreSQL Reviews

AK
Akshaya K.Small-Business (50 or fewer emp.)
5.0 out of 5
"i am using this as my database since 2024 i love this product"
we can automatically create a ER diagram of a databse with 2-3 clicks . its very easy install in my system the storage was very low and easy to in...
Biruk T.
BT
Biruk T.Mid-Market (51-1000 emp.)
5.0 out of 5
"Robust PostgreSQL support with enterprise grade features"
EDB provides a reliable PostgreSQL experience with extended enterprise tools like EDB Postgres Advanced Server. I specially appreciated the integra...
Verified User
U
Verified UserSmall-Business (50 or fewer emp.)
5.0 out of 5
"PostgreSQL:"
Strong support for advanced indexing techniques like BRIN, GIN, and GiST, which optimize query performance for large datasets. Plus, its built-in J...

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
View More Pricing Information

PostgreSQL Media

PostgreSQL Demo - PostgreSQL
PostgreSQL
Answer a few questions to help the PostgreSQL community
Have you used PostgreSQL before?
Yes

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.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
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.

Recommendations to others considering PostgreSQL:

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. Review collected by and hosted on G2.com.

What problems is PostgreSQL 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. Review collected by and hosted on G2.com.

Verified User in Higher Education
CH
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Business partner of the seller or seller's competitor, not included in G2 scores.
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 problems is PostgreSQL solving and how is that benefiting you?

The business problem that I am solving with PostgreSQL was to query data for further processing. I was working on generating intelligent reports with data from an Alfresco Architecture whose data resided in a PostgreSQL database. The benefits I observed were, it was free to use and the queries functioned perfectly. Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

Recommendations to others considering PostgreSQL:

It has a high learning curve but, since it's open source, therefore, it has a huge online community to support. Once you acclimatize with the command line for Postgres, you can solve any large data problems easily. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

It solves all sort of data problems, data storage, data extraction, manipulation, etc. It has really good functions for data storage and manipulation. It is best when used against complex data models. Review collected by and hosted on G2.com.

Carson W.
CW
CTO
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

Recommendations to others considering PostgreSQL:

Give it a chance, the cost of learning is worth the power it affords. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Our data storage for our whole app is in postgres. Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

Recommendations to others considering PostgreSQL:

Growing RDBMS with enthusiastic community of developers behind Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Data storage for web applications. Review collected by and hosted on G2.com.

Verified User in Internet
UI
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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 problems is PostgreSQL solving and how is that benefiting you?

The problems I'm solving with Postgres Is the need to run analytic SQL queries in a scalable and efficient manner for our analytic capabilities. Review collected by and hosted on G2.com.

SUBHA P.
SP
Technical Lead
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
Business partner of the seller or seller's competitor, not included in G2 scores.
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 problems is PostgreSQL solving and how is that benefiting you?

OLTP applications have been smooth and quick response of queries

PostGIS is so amazing along with pointcloud and other good features making it no 1 for GIS systems

Greenplum built on Postgres 8 serves wonderfully OLAP and large datasets Review collected by and hosted on G2.com.

VB
Business Analyst
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Rating Updated ()
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.

Recommendations to others considering PostgreSQL:

Start using it Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

It allows you to add custom functions developed using different programming languageslike C/C++, Java, and etc Review collected by and hosted on G2.com.

Nairoby D.
ND
Administrador de Bases de Datos (DBA). Consultor TI
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
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.

Recommendations to others considering PostgreSQL:

The administration of a postgres cluster is great, we can synchronize a slave and a master and it works perfectly the synchronization and replication Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

I work daily in the management of postgres databases, used the console for backup and restore issues since they are much faster Review collected by and hosted on G2.com.

DL
Python Dev
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
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.

What problems is PostgreSQL solving and how is that benefiting you?

Using it as a database to store information for the company web app Review collected by and hosted on G2.com.