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 64

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.
RO
Chief Database Architect
Mechanical or Industrial Engineering
Small-Business(50 or fewer 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?

Lots of ANSI SQL features, array support, extended type support, great query planner works well with custom types. Free without strings. Runs on windows, mac, and Linux. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Needs parallelization for queries like SQL Server and Oracle have. Need ability to replicate single databases easily. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is a great database. It has both fantastic relational support and other type extensions for NoSQL like workflows so you get the best of both worlds. It supports many stored procedure languages in db JavaScript, SQL, Perl, Python, and R. Review collected by and hosted on G2.com.

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

We use it as a back end for most of our applications. We've been able to use advanced SQL constructs that we didn't have available in SQL Server, allowing us to be able to move most logic into the database where it can be used across many applications. Review collected by and hosted on G2.com.

Verified User in Consumer Services
UC
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?

There are window functions. It makes a lot of things to be solved much easier than without them. Hive databases also have similar functions so it's relatively easy to move to Hive from PostgreSQL. Also has a function already available to create a custom functions. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not the best performance on reading operations compared to MySQL database. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Want your data to be safely stored? - Use PostgreSQL.

Also if you use pretty complex database designs, PostgreSQL is nice solution for that. Review collected by and hosted on G2.com.

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

We used id while creating an online web store. It wasn't the best solution to choose but it covered our needs. Review collected by and hosted on G2.com.

Rohit V.
RV
Senior Software Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

It is very fast for large amount of data. The front end client (pgAdmin III) is bundles with the database and is very responsive for a large number of concurrent connections. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

A steep learning curve for proprietary configuration. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Good for new users. Review collected by and hosted on G2.com.

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

Developing a distributed application with multiple servers connecting to the PostgreSQL. Review collected by and hosted on G2.com.

Daniel B.
DB
President
Computer Software
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?

One of PostgreSQL's best features is strong adherence to the ANSI-SQL:2008 standard, which makes it a very comfortable choice when switching from other database systems. It's open source, well maintained, industry proven and battle-hardened, with a rich set of features that I could not begin to list here. I've consistently been impressed by its extensibility, stability, and robust set of built-in functions, including handy cryptographic functions. I make regular use of nested transactions, wide language support for stored procedures, and complex subquery expressions. This is a powerful tool suitable for a wide variety of application domains, and it is well supported in every major programming language with drivers and connectors. A plethora of tools exist to interact with your PostgreSQL databases, from command line to powerful GUI tools suitable for both experienced and novice users. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Configuring PostgreSQL instances can be challenging, and is not to be entertained by the layman. If you can, find an experienced DBA to handle configuration of your instances or cluster, unless you have a very competent system/database administrator in-house. It will work just fine out-of-the-box, but more demanding integrations require configuration tweaking. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Consider PostgreSQL early in your RDBMS search. Every major and minor release adds significant functionality -- this is a living, breathing, growing product that will almost certainly address your needs. Review collected by and hosted on G2.com.

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

We migrated from Oracle to PostgreSQL, saving significantly on licensing costs with no loss in performance or features. Since that switch, we have used PostgreSQL as our data backplane for every new product initiative with great success and no insurmountable difficulties. Review collected by and hosted on G2.com.

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

Extremely easy to setup. Good security features. Can easily deploy in the cloud or use pre built Amazon services. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The GUI. pgAdmin has not been a very stable product. But once you work through the issues it does the job. Review collected by and hosted on G2.com.

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

Storing large amounts of normalized. PostgreSQL contains many analytics functions that other tools do not. This extremely satisfied business users. Review collected by and hosted on G2.com.

Neil B.
NB
Database Manager
Research
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
What do you like best about PostgreSQL?

The documentation is very well written and logically laid out. I can't find anything in the MySQL docs but familiarity is certainly a factor.

Rock-solid stability and point-in-time recovery. Go ahead -- pull the plug!

When working with spatial data the PostGIS extension is very powerful. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing! Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

When looking for support be sure to search the StackExchange sites first. Review collected by and hosted on G2.com.

Jared T.
JT
Solutions Architect
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

Either free or way more affordable than other Database software, i.e Oracle. And they are not owned by Oracle, as opposed to MySQL which is not Larry Ellison's property. More robust and secure compared to MySQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not as fast as MySQL, although not signifigantly slower Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

You should consider as an alternative to MySQL. Review collected by and hosted on G2.com.