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 28

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

AK
Akshaya K.Small-Business (50 or fewer emp.)
5.0 out of 5
"i am using this as my database since 2024 i love this product"
we can automatically create a ER diagram of a databse with 2-3 clicks . its very easy install in my system the storage was very low and easy to in...
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...

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

638 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.
638 PostgreSQL Reviews
4.4 out of 5
638 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 Information Technology and Services
CI
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Its opensource, lightweight DB. It provide good features to play with JSON structured data. More intuitive features available like filter , sorting , structuring data using Json syntax.

Most preferable db on cloud. very easy to optimize and analyze query performance . Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

crash when play with millions of data. quiet slow processing with millions data. Need to setup always custom configuration for best performance. some Query syntax is different from other PL/SQL Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

best for opensource DB and light weight and easy installation Review collected by and hosted on G2.com.

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

Produce data in Json structure which help api to return response as it is. it save time to reprocess data in json structure. compatible with cloud so we used. Review collected by and hosted on G2.com.

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

Easy error recovery options like deleting and altering tables etc. in a given database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is no clear documentation available on the official website , the search is is not good related to finding docs,especially once related to configuring the database itself on the machines and different OS. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I would definitely recommend as it is a very good option and its definitely provides many good features in the free version as well. Review collected by and hosted on G2.com.

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

Issues with upgrading to new version 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: Organic
What do you like best about PostgreSQL?

I like the easyness and the reliability of this. I 7sed various features of posgresql and found it very easy and useful. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I used it from command line 0f linux server. I don't if there is any tool for graphical use. I missed that part. Review collected by and hosted on G2.com.

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

I used for a.project for home security system. Also I used it for a course requirements. 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 Gives Campaign
Incentivized Review
What do you like best about PostgreSQL?

We are using postgresql since 1 year, Eady and readymade query operations such as upadte delete,insert is very helpful and as compare to other database vendors postgresql is very scalable as well as powerful and simple to learn. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Need more stabilisation some functionality like when we are inserting data into row without query we are unable to insert but 'edit' option is available and connection issue need to fix. Review collected by and hosted on G2.com.

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

Previously our organisation using one of paid database vendors,After using postgresql we are able to save cost and easy to learn who have basic database knowledge.We able to train earliy new people. Review collected by and hosted on G2.com.

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

PostgreSQL is a standardized way to store and query data as necessary. It's intuitive and easy to use as a language and database so to speak. The methods are relatively standardized and haven't changed in years. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The databases are varied and sometimes are not consistent. Many providers have their own flavor of PostgreSQL Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL is a great database engine to try out for any organization large or small. Review collected by and hosted on G2.com.

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

PostgreSQL allows us to run analytic SQL and discover insights and problems that we otherwise wouldn't be able to. Review collected by and hosted on G2.com.

KG
kritika
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

my compony is using this database from last 10-12 years. very easy to use, provides security by default. Provides easy setup.

Good integration with big data frameworks and vms. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

its gui tool i.e, PgAdmin is very very slow. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

if you have to query lot of data, and your main concern is security. Review collected by and hosted on G2.com.

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

using postgress in my company to query million of records. Review collected by and hosted on G2.com.

Pedro P.
PP
Web Developer
Computer Software
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

Postgres is a great DB, allow you to do everything that others DB, but additional I found I can use pg_notify to send some kind of broadcast notification, this is great and an option to communicate to others software Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

sometime the backup/restore process is not 100% good, some issues restoring DB Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

before to use postgres, download and test the DB check if the all the datatypes are correct for your project, and please check the backup/restore process Review collected by and hosted on G2.com.

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

we use postgres as our main DB for our software 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: Organic
Rating Updated ()
What do you like best about PostgreSQL?

Simplified queries and the performance in result fetching Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much we can say I dislike , completely suitable for data store and fetch. Review collected by and hosted on G2.com.

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

Keeping data gathered Review collected by and hosted on G2.com.

Rob D.
RD
Senior Systems Administrator
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?

simple low cost setup works with many applications and web hosts. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

i have no cons with this product pg admin is great also! Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

please give it a try fro stability and loweer cost database technology for small or large installations/applications. Review collected by and hosted on G2.com.

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

Business applications can be easily developed with tight integration (example Jira by Atlassian works very well with PostGreSQL.). Review collected by and hosted on G2.com.

Jenaro T.
JT
Jenaro
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL can be used to create databases in both windows and linux operating systems Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It takes a lot of time to install and also needs additional features to install Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

To try it Review collected by and hosted on G2.com.

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

Creation of better databases compared to normal SQL servers Review collected by and hosted on G2.com.