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 62

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.
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?

It is a super powerful tool with the ability to get the job done with work with your database. I am newer to SQL and have found this tool to be great with my skill level. I love the ability to export the files I need and the speed in query execution. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Sometimes it can run a little slow and that can be unpredictable without reason. Most times it's very fast, but when it bugs out, you have to restart and it just can be a pain. Review collected by and hosted on G2.com.

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

Working through different databases building out reports for customers based on the different tables. Review collected by and hosted on G2.com.

Vitor H.
VH
Software Developer
Computer Software
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is free and open source and fits great in any project size.

It's easy to connect to PostgreSQL with any technology.

It has a strong and active community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Lacks popularity.

Performance in read-heavy operations. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It's free and open source and contains most of the resources of other large and popular databases such as Oracle and MS SQL Server. Review collected by and hosted on G2.com.

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

Needed a scalable database for a large project. 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?

- the price

- the availability of great support, for example at the mailing list and at Stackoverflow

- the features to keep the data valid (checks, triggers) Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I somewhat dislike the necessity to setup and use pgbouncer or similar, I would have better preferred everything to be available in a single package.

Also, optimizing performance for my needs has been a tedious process. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is great.

There are lot of docs and friendly users out there. Review collected by and hosted on G2.com.

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

Good support by other users, many nice features provided by the database.

The PostgreSQL software is very mature:

Whenever there were any problems, I knew that root cause has been me and not this great software. Review collected by and hosted on G2.com.

Timothy S.
TS
Principal Developer Advocate
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

Everything. It supports all the SQL-92 standards, plus some of their own editions. It has a very mature GIS querying and every type of index. It supports in memory and a ton of different trigger languages. There's no feature or item missing from postgresql.

Use it and you will be happy.

It's an exact replacement for oracle without the cost. Supports triggers, procs, functions and everything you can think of including a datascience machine learning package MADLIB.

There's no reasons not to use Postgresql. The drivers for Java and Scala and NodeJS are excellent. Postgresql also powers a lot of servers like Cloudfoundry. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The problem with Postgresql is that there's a lot of version and no single owner of the enterprise verison. No really a concern. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

There is no reason to not use PostgreSQL, it is amazingly mature coming from Ingres and Dr Stonebreaker. It's been around forever and is really solid. A dozen or so commercial vendors have MPP and datawarehouse forks of it that they use.

Postgresql JSON features are very helpful for front-end usage and the indexes make most queries blazing fast.

We have no dba and really don't need one. The DB runs itself.

You do need to run a few dba tasks weekly like vacuum, analyze and backup.

Check your explain plans and make sure you have adequate queries. Review collected by and hosted on G2.com.

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

We are using it for data warehousing, basic data for web sites, blog storage, backup data and research data. It is also our main analytic database and transactional store.

It has saved us a lot of development time and money. Spring Data JPA and hibernate work perfect with PGSQL. pgADMIN and all JDBC SQL tools work perfect with it. Review collected by and hosted on G2.com.

Alex M.
AM
Software Engineer (Technology R&D)
Research
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

Geospatial data is very handled by the PostGIS extensions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The command line interface is quite foreign from the conventions of other systems, and lacks many useful features like tab completion for identifiers. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

There is no better free database available currently, and it gives many commercial products a run for their money. Review collected by and hosted on G2.com.

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

Open source, web based mapping products Review collected by and hosted on G2.com.

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

This is RDBMS that i use the most. I like the performance and and also hstore. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its relational database, its not specific to postgres. But when im working in research project i will not use RDBMS because in research schema change often. Review collected by and hosted on G2.com.

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

Mainly transactional data and when i need to use RDBMS postgres always be my first choice 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?

PostgreSQL was my first database that I used when initially developing rails apps and I prefer to use it if I have the option. It's open source, and it's well maintained. There is also a huge community of people who use it so there are plenty of answers for questions on stackoverflow etc. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Off the top of my head there isn't anything I dislike about it. Once you learn to use it it is pretty straightforward and there is a lot of documentation for learning to use it. I would certainly recommend it over other options like mysql in terms of ease of use, although it depends on what you want to use it for. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I wish my company would switch. Not enjoying using our current other than PostgreSQL sql database. Review collected by and hosted on G2.com.

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

It's used for databases for applications. Relational database storage. Review collected by and hosted on G2.com.

Bryan F.
BF
VMware Engineering Consultant
Information Technology and Services
Small-Business(50 or fewer 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?

PostgreSQL is stable and performs well, even at large connection loads. They have the best documentation of any piece of software I've dealt with. On top of that, it's completely free! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The default GUI for interacting with the database isn't very intuitive. Scaling can be a problem due to the rudimentary clustering tools and lack of third party support. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

This is a great product for small to mid scale implementations. If you're looking for a scale out system or high availability cluster, it may be prudent to look at other options that are easier to work with. Review collected by and hosted on G2.com.

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

We use the PostgreSQL database as a back end for our monitoring system. It's easy to install, integrate, and use and at the free price tag it has saved us a lot of money. 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
What do you like best about PostgreSQL?

This database can do just about anything. For a modern web application the support for JSON, and JSONB columns is incredible. The addition of native upsert in 9.5 is huge, too. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Managing PostgreSQL is generally not quite as much "fun," or as simple as SQL Server, or MariaDB. Review collected by and hosted on G2.com.

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

With JSON and JSONB columns we have been able to use PostgreSQL as a document store, in addition to leveraging its conventional relational qualities. Review collected by and hosted on G2.com.

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

PostgreSQL is an open source relational object-orieneted data management system. It has been improved, and provide a variety of features that I need at my work. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The system scalability, and capability for big data Review collected by and hosted on G2.com.

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

I use it to create a data management system. Review collected by and hosted on G2.com.