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 17

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.
Devansh A.
DA
Associate - Projects
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

- Can use alongside timescale as a Timescale DB

- Easy to understand and work on

- With PGAdmin you can easily and smoothly manage your database Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

- Complexity of terms quite different from the other databases Review collected by and hosted on G2.com.

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

- Managing Database

- High Availability with Patroni ETCD Review collected by and hosted on G2.com.

Himanshu A.
HA
Software Development Engineer in Test
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Postgre SQL is easy to use.

If you know the SQL it's super easy to learn the Postgre SQL.

It's also a fast way to store the data and fetching from the database.

we can use the Postgre SQL in any project./

It's very popular so if you learn it, it's will definitely benefit your professional life. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is nothing to dislike for postpre Sql just if required some time to learn it. Review collected by and hosted on G2.com.

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

you can use it in any of your projects for storing, fetching data from the database.

It gives you easy access to data.

I myself use this in many of the projects. Review collected by and hosted on G2.com.

Aniruddha B.
AB
Module Lead
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

* Easy to read the documentation

* Major support for all languages

* Partitioning functionality Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

* Configuration is a bit overwhelming and needs reading of documentation to get things right. Review collected by and hosted on G2.com.

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

* Using it with REST API and microservice architecture solutions which are not too read heavy Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
AI
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?

As PostgreSQL is an object-relational database, it provides features like overloading and inheritance, which can be very useful for developing some applications. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The downside of PostgreSQL is that not every open source app support postgresql. Review collected by and hosted on G2.com.

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

I am developing an application using RESTful APIs and that requires Firebase Authentication and the database PostgreSQL. Its highly concurrent and ACID properties are the benefits. Review collected by and hosted on G2.com.

Jorge M.
JM
Co-Founder and Software Architect
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It is a World Class database management system that you can get for free. Besides, it is possible to get paid versions that include support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Until now, I have not found anything that I dislike from this DBMS. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Anyone interested in a DBMS should consider trying PostgreSQL. It is world-class and free. I ask for support using email list subscription and the community response is great and timely. You can optionally find paid options that include special support and configurations with partners like enterprisedb.com. Until now, the free choice has been more than enough for me. Review collected by and hosted on G2.com.

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

I build information systems for the WWW and I use a relational DB concept to store data. Among the types of systems I have developed are: News, Inventory, Documents Digitalization (like invoices and other). 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?

Postgres has excellent set a features that are unique to it. It is fast and functional and makes writing queries easy. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some of the Postgres specific syntax can be hard to grasp at first. It is very different from MySQL. Review collected by and hosted on G2.com.

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

We use it in many different areas of our organization and personally on freelance projects. It is just fast and helps me get work done. Review collected by and hosted on G2.com.

Swagato M.
SM
SDE III
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

The best feature I see is storing (also searching, etc.) data as advanced DS(s) such as JSON, Lists, etc. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I didn't have any such challenge exclusively for PostgreSQL. Hence the challenges (if any) would be similar to the regular SQL DB(s). Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

In case you're searching for a DB with advanced use-cases, PostgreSQL has it covered mostly. Review collected by and hosted on G2.com.

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

We use PostgreSQL to store the user data in multiple forms (JSON, Lists, etc.).

Benefits: The ability to store the information received from request directly in the same form instead of extra processing like other DB(s) is the best advantage. Review collected by and hosted on G2.com.

Vishal A.
VA
Head of Operations
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

easy and smooth workflow, handy and amateur level tool Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

certain restrictions towards handling of data Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Instead of other complex query language platforms like Microsoft SQL Server or BigQuery, I would recommend PostgreSQL more. Review collected by and hosted on G2.com.

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

I usually use it for data analytics projects which is why valuable to retrieve, update and analyze data, and problems may vary according to the client requirement. However, the best benefit to use PostgreSQL is that you could use easy layman words as crucial commands which are easy to remember. Review collected by and hosted on G2.com.

Archit P.
AP
Senior Product Analyst
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It allows me to store large data in a sophisticated manner. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The installation can be homogenous across the operating system Review collected by and hosted on G2.com.

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

I has helped me maintain data extraction scripts which has reduced manual data extraction time by 30% Review collected by and hosted on G2.com.

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

Felt organized, easy to understand and to use. Could keep several databases within eyes reach Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Occasional technical glitches, brief learning curve before becoming fluent with their system Review collected by and hosted on G2.com.

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

Being able to use SQL to find business solutions and automatically store useful data in a database Review collected by and hosted on G2.com.