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 13

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.
Anish Mahesh S.
AS
Gasoline Blend Optimization Engineer
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?

Intuitive front end and GUI. Quickly becoming an industry favourite Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The interface could be an acquired taste to some but it does take some while to get used to Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Don't think this as any other generic SQL it has a league of its own. Review collected by and hosted on G2.com.

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

Being using it to back all of our databases. It is secure and trustworthy. 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?

PostgreSQL provides us much more Datatypes that are not present in Oracle or Mysql Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is slow as compared to Oracle Database Review collected by and hosted on G2.com.

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

I manage data of the systems that I develop Review collected by and hosted on G2.com.

Savan S.
SS
Senior Software Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

In terms of security, it has one of the most advanced locking mechanisms available. It has a large amount of storage space and is well-known for the integrity of its data. Server-Side Programming features that are mature. Due to robustness, many dynamic websites and online apps rely on PostgreSQL as their back-end database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Column re-ordering is not available,

slower than MySQL Review collected by and hosted on G2.com.

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

PostgreSQL provides the ability to manage metadata. As a result of PostgreSQL's catalogue-driven design, it can be expanded. PostgreSQL's catalogues hold information of tables, columns, data types, functions, and access methods. Review collected by and hosted on G2.com.

Gajendra K.
GK
Technical Team Lead
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It is very complete for any type of project or application. It is stable, easy to use and can handle a lot of structured data. It is free software and is very well documented It is very popular and has a very varied community around the project Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Installment and handelling of initial infrastructure is big complex. Review collected by and hosted on G2.com.

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

I am using this for handling structured data for an airline. It have various advanced features and stability. Review collected by and hosted on G2.com.

Verified User in Computer Software
CC
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

PostgreSQL was a cost effective option to choose from RDBMS. It was easy to configure and get setup. As it is similar to other RDBMS in market so learning this by other team members was not complicated. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

We want to move some of our workloads from other RDBMS to Postgres, but couldn't find any suitable tool. Also, some dashboard to see the health and statistics of Server, DB and table would be helpful. Review collected by and hosted on G2.com.

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

We wanted some way of storing our large logs that are generated frequently and also wanted to query them when needed. So we choose Postgres and it has met our needs and we are also using it to generate dashboards of those logs. Review collected by and hosted on G2.com.

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

I like that its free, open source, and very fast. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Connecting requires a local daemon running and using the web browser (they have a windows app, but it is just the browser wrapped in the app using Electron). Deployment is a bit trickier than MySQL but easier than MSSQL Server, considering the price being free, its not much of a concern) Review collected by and hosted on G2.com.

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

I am personally resolving the licensing budget problems that I have with MSSQL. Review collected by and hosted on G2.com.

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

I have used this as this was free and so to save product cost client wanted to migrate from SQL to PostgreSQL. There are some offcourse syntax changes but overall logic remains same. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing to dislike as such but ya but 1 thing i would like to point out, it doesn't contain every method which is used is sql. So there are some changes which you need to do if you are looking for a migration. Not all collation such as sql latin1_general_ci_as for eg are nt available. Review collected by and hosted on G2.com.

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

Cost - the main factor, we used it in gcp - google cloud platform and it was free, if u compare it with sql that is very costly.

Efficiency - it is as effective as other databases. Review collected by and hosted on G2.com.

SD
Software Architect and developer
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?

I like how this database could handle extensive data and small data. I have been using it for lots of small projects as well as for large project that handles data processing and event-driven projects. It's good to see such flexibility in heavily read-write processes. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

What I dislike about it is the GUI to handle all the operations are not that user-friendly compared to what mongo DB or MySQL has. I wonder if the Postgres team gets to have some good UI UX for postgres as well. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

GUI for managing Postgres is a bit complicated, and you should continue considering that you might have some bad experience with Postgres. Other than that, Postgres is excellent if you have huge read and write operations. Review collected by and hosted on G2.com.

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

I am using PostgresSQL on heavy read write application, and analytics project for huge data. Along with that working on projects for small scale project general management project.

The main benefit that I saw with using PostgreSQL is that its good for small and large project. I could use the same db server for large project while development and also small projects as well without having to thinking much on performance changes for small and large project. Review collected by and hosted on G2.com.

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

PostgreSQL is one of the best available open-source relational database management systems. Available on all the platforms. GUI is also available which is again the best thing. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL CLI commands are not very commonly used. It is hard to remember on initial stage. Review collected by and hosted on G2.com.

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

We are using PostgreSQL for our large production database where millions of transactions happen on regular basis. We are using data analytics also. Review collected by and hosted on G2.com.

Verified User in Education Management
UE
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?

It's very easy to set up, especially when using a managed service from a cloud provider. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Migrating when there are version upgrades can be a bit of a pain. Review collected by and hosted on G2.com.

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

It's the primary datastore used for the project. Review collected by and hosted on G2.com.