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 24

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 Computer Software
AC
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

I like the ease of use, scalibility and usability. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I dislike like of overview of data. You need to install additional tools for it. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Great for scalable startups. Review collected by and hosted on G2.com.

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

We resolve problem of scalling database from startup to enterprise. Review collected by and hosted on G2.com.

Ranjan A.
RA
Backend Developer
Public Safety
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

geo query, the way we can query on geo coordinates Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

query json, Since it is a rdbms, the concept of JSON query is bad Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

easy to use Review collected by and hosted on G2.com.

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

geo coordinates Review collected by and hosted on G2.com.

minh p.
MP
Graduate Assistant
Research
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL has been developed for a long time, so it probably has the most functionality in the database market.

It is open-source, so its development will keep growing rapidly.

It is free.

It solves all of the problems that a relational database would solve, just like MySQL or Microsoft SQL Server, but is cost-effective and has similar performance. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The graphical tooling isn't as good as some of the tools provided by Microsoft or Oracle.

Can be hard to figure out problems unless you know SQL very well.

PostgreSQL does not allow to execute batch of statements. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are looking for a free relational database, PostgreSQL is the way to go. Review collected by and hosted on G2.com.

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

I use it for transportation data collection. It performance is very impressive, but it was a bit difficult to get used to at first. 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?

The features which i like the most are :

User-defined types , table inheritance ,sophisticated locking mechanism and many more.

Fetching data and modifying it is very easy with postgres.

Best part is the high speed. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Does not support the entire ANSI SQL 92' standard, much less the ANSI SQL 99' standard. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Postgres is really fast , secure and supports many procedural languages. It is very reliable . Try to use it. Review collected by and hosted on G2.com.

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

We are using postgres as the data base for our accounting software- Giddh.

Storing data , quering and modifying is very easy.It has legendary stability and reliability. Review collected by and hosted on G2.com.

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

Free database manager, with only download and install you can have the world of databases in full, with the best options of any proprietary driver, it is easy to install especially in free operating systems, it is ideal for database relational data, in terms of support, the best ally is the community of people who help others through forums, it is compatible with several graphic tools if they do not like to use the console, configuring a cluster is super simple and on the Internet the information works wonderfully with large databases. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If you use postgres by console and not with any graphical tool such as pgadmin or dbeaver you must have intermediate knowledge, you may notice some slowness in massive insertions but this is related to the good design of the database Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

The administration of a postgres cluster is great, we can synchronize a slave and a master and it works perfectly the synchronization and replication Review collected by and hosted on G2.com.

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

I work daily in the management of postgres databases, used the console for backup and restore issues since they are much faster Review collected by and hosted on G2.com.

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

Database with brilliant highlights to store information, incorporation with numerous applications created in various dialects ​​of application advancement, similarity with Windows working frameworks, Linux, and so on. Simplicity of reconciliation with ETL arrangements, to store information stockrooms to communicate with business insight programming, permits replication of information with streamig replication, the accessibility of operational progression through the usage of pgpool, doubles to perform reinforcement and recuperation forms , execution of WAL, plausibility of executing auto vacuum to keep the objects of the database clean, variant updates of the postgresql SMBD, are simple and applications are not influenced. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL question sentence structure for some mind boggling inquiries like array,string capacities and case administrator are isn't anything but difficult to compose . Establishment and setup of PostgreSQL isn't as simple as MySQL. Documentation isn't in the same class as MySQL and it is bit more diligently to google query items. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

PostgreSQL offers a strong database stage on which to fabricate applications for associations not willing to pay huge yearly upkeep charges. It scales well from little single use applications to vast bunched undertaking wide frameworks. The open source permit gives you a chance to introduce the same number of examples as you requirement for nothing. The open source, norms consistent database permits you complete adaptability in structuring the database and any applications it supports. PostGIS and pgRouting are database augmentations that add enormously to the abilities of the item and are center to our GIS foundation. Documentation for the item is best in class and the client network is amazing. In the event that you so wish, bolster contracts are accessible from various providers in the UK and universally. PostgreSQL is additionally accessible from many cloud administration providers and keeps running on all major working frameworks Review collected by and hosted on G2.com.

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

The business issue that I am explaining with PostgreSQL was to inquiry information for further handling. I was dealing with producing keen reports with information from an Alfresco Architecture whose information dwelled in a PostgreSQL database. The advantages I watched were, it was allowed to utilize and the questions worked splendidly. The database is turning into the single wellspring of truth for every spatial datum in the association. The adaptability offered by the database has improved the proficiency of various distinctive information creation and upkeep work processes and thus we have developed the quantity of clients from 10 to 75. Review collected by and hosted on G2.com.

Aby J.
AJ
Technical Lead
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?

1. Free code database manager, which is not used for licensing.

2. Easy to install and configure in any operating system.

3. Ideal for relational databases.

4. It has a large community in which you can share doubts.

5. It is stable and reliable, scalable and secure with the correct user management.

6. Can work with small and large databases.

7. Handles the SQL language. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For some, not having support online or with an official help center can be a big disadvantage Review collected by and hosted on G2.com.

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

We have a DMS product where we are using PostgreSQL as DB Review collected by and hosted on G2.com.

GB
Head of Engineering
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 Gives Campaign
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL offering is way above the one of competitors like Oracle, MySQL or Microsoft's SQL Server Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Major version upgrade process requires downtime. Most other databases avoid this painful process. Review collected by and hosted on G2.com.

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

Being able to generate fast and powerful reporting aggregating gigabytes of data. Review collected by and hosted on G2.com.

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

Open source, lots of data types (like arrays and queryable JSON), lots of support in the community like Docker Hub, lots of examples online to reference, many managed services available form various cloud providers. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Bad free tooling - pgAdmin4 is very awkward and slow to use. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Great choice as long as you don't rely too much on GUI tools to work with the database for creating tables, etc. Most administrative tasks are best performed via queries. Review collected by and hosted on G2.com.

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

Using it to store relational data for various microservices. It is our goto SQL database technology because it is open source and has the features we need. Bonus is that because we use Google Cloud, we can take advantage of their Cloud SQL managed service which has a PostgreSQL version. This reduces our operations costs. Review collected by and hosted on G2.com.

MB
Data Engineer
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?

Open-source relational database management system and easier to handle and simple database architecture compare to other database base engine. It also supports NoSQL features. It's also easier to implement clustering and replication of the database, and migration to the cloud. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Table Indexing, A found it bit complicated compared to Oracle and MS SQL Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Yes, Mostly when people ask me the cheapest database system for small enterprises Review collected by and hosted on G2.com.

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

Database management system for Online Analytical Processing. Variety of features for storing data such as JSON, NOSQL, ARRAY etc, and easy to integrate with other systems using JDBC, connection, a faster-database engine for querying bigger tables Review collected by and hosted on G2.com.