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 16

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

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...
saif eddine m.
SM
saif eddine m.Enterprise (> 1000 emp.)
5.0 out of 5
"My Experience With PostgreSQL"
What i like most about PostgreSQL is the ergonomic interface , easy to understand .

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

637 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.
637 PostgreSQL Reviews
4.4 out of 5
637 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.
RN
Data Research Analyst
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

It works robustly, Well supported by backend frameworks. Stability and ability to handle structured data are pretty good. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Configuration can be a little overwhelming for those who are new, but users can refer - https://www.postgresql.org/docs/ for better understanding. Review collected by and hosted on G2.com.

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

I use it for database management; it is reliable and safe to use. New users can learn from - https://www.youtube.com/watch?v=eMIxuk0nOkU Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care
UH
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Opensource DB, Highly Secure, Stability, Scalability, Highly performance-oriented. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Data compression, Columns reordering, its default availability on all hosts. Review collected by and hosted on G2.com.

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

We use this as a relational database management system for enterprise applications. Review collected by and hosted on G2.com.

Kishan K.
KK
Data Analyst
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?

1) It is a free and open-source database system.

2) It is secure and robust compared to other relational database systems.

3) Easy to store large amount of structured data in the database system.

4) Querying time is super fast and quick.

5) Frequent updates from time to time. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

1) It is a bit confusing compared to other database systems.

2) Sometimes slow with big queries.

3) Apart from these cons, it's a great relational database system. Review collected by and hosted on G2.com.

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

1) Free SQL Database system

2) History of queries

3) Data analysis

4) Temporary tables querying Review collected by and hosted on G2.com.

Verified User in Computer Software
UC
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

The best thing is its is open source, it supports the B+ tree, GIN (Generalized Inverted Index) and GiST (Generalized Search Tree).The project is supported by a number of corporations and people. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Changes for performance enhancement need more work than in MySQL since PostgreSQL primarily has software compatibility goals. Many open source applications support MySQL, but not PostgreSQL. Review collected by and hosted on G2.com.

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

I'm using PostgresSQL for a heavy read/write application and a big data analytics project. In addition, I am working on projects for small-size projects and general management initiatives for which I use PostgreSQL too Review collected by and hosted on G2.com.

Animesh K.
AK
Technical Test Lead (ABC Financials)
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Easy Installation and Configuration, supports multi-platforms like Windows, macOS, Linux, use existing applications.

Highly reliable open source RDBMS.

Lots of features compared to its competitors. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lacks schema versioning, Parallel data query, Feels lacking in performance compared to competitors especially in writing to the database. Postgre upgrade from 9 to 10 was not that great, there was a lot of downtime. Lacks in-memory modes.

Less documentation which may be impediment to new users. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is best suited for small and medium development projects. While there is a bit of a learning curve compared to MySQL and SQL server, which may be an issue for the beginner but if you are an experienced software developer or database admin, it is almost perfect for you.

It provides broad feature sets, which are handy for incremental development.

The best part is it's free, so it is a cheap and almost equal alternative to SQL Server since you need to pay a lot for licensing costs of SQL Server for businesses and enterprises. Review collected by and hosted on G2.com.

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

I work as a consultant and we work on providing technical solution to our clients. We suggested PostgreSQL to one small company we were working with.

I believe PostgreSQL is best suited for smaller and medium sized development project. Since this is open source, it has all the features which are needed for smaller and medium development project. This is also easy to administrate. Postgres has an incredibly flexible and simple-to-use user/role management system.

Postgres usage is increasing in the industry and I believe its market share has increaed to 6% lately. It is really easy to integrate PostgreSQL into our stack. Because of high adoption rate, hiring a developer to implement or service Postgres is easy. Most of the major database libraries of common web frameworks are out there like Rails - ActiveRecord, Spring-Hibernate, Play Scala-Slick. These libraries have out of the box Postgres support, thus no extra configuration is needed for our web applications to read or write to PostgresSQL. Review collected by and hosted on G2.com.

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

- Querying time is considerably faster

- Free and open-source database

- Easy to install and configure Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- Consumes somewhat higher CPU usage so that efficiency is a bit low Review collected by and hosted on G2.com.

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

- Using the database with a Go API

- Database used for Enterprise application Review collected by and hosted on G2.com.

Dinesh P.
DP
SDE
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

only postgresql provides enterprise-class performance and functions among current open source dbms with no end of development possibilities. also, postgresql users can directly participate in the community and post and share inconveniences and bugs. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The UI is not that user friendly. I could improve much better way. Review collected by and hosted on G2.com.

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

only postgresql provides enterprise-class performance and functions among current open source dbms with no end of development possibilities Review collected by and hosted on G2.com.

Verified User in Computer & Network Security
AC
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?

Highly compliant with SQL standards, able to handle large complex queries. Supported by the majority of platforms such as Amazon Redshift and DynamoDB. Great for application data processing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Slow process speed, not a good fit for real-time data processing Review collected by and hosted on G2.com.

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

Largely complex data queries, ROR used PostgreSQL as a backend database. Review collected by and hosted on G2.com.

Verified User in Insurance
AI
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Is a good database for non-critical applications that required less level of effort for administration and support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

At the moment i do not find any dislike whatsoever Review collected by and hosted on G2.com.

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

Some applications were using SQL Express and with his limitation, on some occasions the application start crashing because the database was full, performance issues, etc. Review collected by and hosted on G2.com.

Elizabeth J.
EJ
Software Developer
Information Technology and Services
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: Organic