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 19

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.
Noah S.
NS
Technical Consultant
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
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?

It's the easiest RDBMS for beginners with relatively simple syntax & very little administration required for basic apps. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is slower than MySQL and other non-RDBMS databases. Review collected by and hosted on G2.com.

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

We use PostgreSQL as our database of choice for prototyping new applications. We also have customers using it on massive scale. We benefit from it's open source code & flexibility to work in almost any situation, large or small. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Ease of use and functionality: being able to schedule tasks, create window functions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Finding small syntax differences between mysql and postgresql Review collected by and hosted on G2.com.

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

Being able to create tasks overnight that will send out the required reporting to each appropriate department. Review collected by and hosted on G2.com.

Hendy W.
HW
Senior Associate Consultant
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

Simple interface, and easy for beginner (either for student or associate consultant) Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

pip install are a lot, and it required one to do more research. Review collected by and hosted on G2.com.

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

Data assessment by using pandas and numpy Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

High SQL standard coverage, feature rich and easy to use and deploy. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If you need a database server, there are no real downsides. Point in time recovery is some work to set up. Review collected by and hosted on G2.com.

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

Saving large amounts of structured data can make a huge licensing impact on commercial database licenses, which do not accur when using PostgreSQL. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
II
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Postgres provide very amazing fields which other SQL database doesn't have like array field and json field to store data, postgres is very easy to integrate and very much easy to use too. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres installation with linux mint is bit difficult the documentation provided to install doesn't work properly with linux mint. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Highly recommended for every developer to use postgres as their default database not only in production but kn testing and stage also. Review collected by and hosted on G2.com.

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

We are using postgres in our production it helps to make our database more clean and faster than any other SQL database. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 Gives Campaign
Incentivized Review
What do you like best about PostgreSQL?

easy to excecute the scripts,easy to find the database and tables, proper arrangement of views & tables. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

connecting to server , requires additional host names and details Review collected by and hosted on G2.com.

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

easy to handle , easy to connect in various application using simple dll's , easy to fetch data and also share the data and store in data tables. Review collected by and hosted on G2.com.

zahit B.
ZB
BI & DWH Consultant
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I think PostgreSQL is a good Enterprise Class data management. It has good amount of features like integration, migration, flexible deployment options, has good tool kits for management. We've almost about 10+ databases including master and managing them via PostgreSQL is very easy. One good thing with PostgreSQL is that we can have multiple databases in single server and having different configurations for them. Overall we are most satisfied with PostgreSQL and their services. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Ability to have multiple databases on single server. Having database users which are permission based Integration between multiple databases. Review collected by and hosted on G2.com.

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

Max connection timeouts are too frequent. Much frequently we do see problems like queries are in waiting status and goes idle after some time. We had to manually kill those transactions.I can't say the technical support team is very good Review collected by and hosted on G2.com.

zahit b.
ZB
Freelance BI&DWH Consultant
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

PostgreSQL is an open-source database. It is an RDBMS. In our Organization, we are using PostgreSQL-9.4 and planning to upgrade it to 9.5 in future. PostgreSQL Database can be used for highly complex applications. It will reject the unauthorized connections to the database. In addition, The management panel for storage management is very useful. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Configuring the Database in the local machine was a bit difficult. I don't find any good IDE's to work on it. PgAdmin's also there, I couldn't achieve the maximum speed. Because it's a web-based application Review collected by and hosted on G2.com.

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

I have mostly used postgres for database management tool, In addition, database migration from sybase to postgres and to test it. I think, It's benefits are very obvious and is once of the best DBMS out there. Review collected by and hosted on G2.com.

Andy Larry R.
AR
Informaticien études et développement
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

- A very scalable data management system with powerful tools to exploit data

- A strong stability when execute complex request (trigger, ) and long term data archive

- A great stability for data storage, no data corrupted, no crash, it can store big data

- Open source and free, you can deploy PostgreSQL anywhere and anytime with sevral users as you want

- Very best support team with community Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- You must regularly execute autovacuum to insure performance

- It 'is a little complicated to implement logshipping master/slave clusterization

- Not as speed as Mysql for data selection (SELECT)

- Detailed documentation only available in English version Review collected by and hosted on G2.com.

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

- I use PostgreSQL for projects which need a strong stability in data storage like banking transaction management, employee salary management and others, with PostgreSQL, you insure data availability.

- I also use PostgreSQL for business intelligence projects because it support complex SQL request mix with triggers and stored procedure which are powerful tools for making strong data analysis. Review collected by and hosted on G2.com.

Verified User in Accounting
UA
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

I've used Postgres for a number of projects and would highly recommend. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

At this time, nothing comes to mind so far Review collected by and hosted on G2.com.

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

Using it as a database solution to store user data Review collected by and hosted on G2.com.