App comparison

Add up to 4 apps below to see how they compare. You can also use the "Compare" buttons while browsing.

PostgreSQL Logo

PostgreSQL

4.6
(389)

Write a review

Open source relational database management system

learn more

(3)

PostgreSQL Pricing

Pricing overview

Value for money rating

4.6

/5

389

Price starts from

Free

Pricing options
Free plan
Subscription
Free trial

Pricing details

PostgreSQL is available for free.

What users say

It's a great tool and perfect value for money, since it's completely free. Perfect for small and medium sized applications.
PostgreSQL is one of the most feature-rich, powerful and advanced open-source database management systems. Though this power comes at a cost.

Popular contenders

Price starts from

99

/user

Per month

Pricing model

Free plan
Subscription
Free trial

Free trial

Available
Credit cardless trial

Price starts from

450

Per month

Pricing model

Free plan
Subscription
Free trial

Free trial

Available
Credit cardless trial

Price starts from

3

Per month

Pricing model

Free plan
Subscription
Free trial

Free trial

Available
Credit cardless trial

Price starts from

Free

Pricing model

Free plan
Subscription
Free trial

Free trial

Available
Credit cardless trial

Price starts from

20

/user

Per year

Pricing model

Free plan
Subscription
Free trial

Free trial

Available
Credit cardless trial

Reviewers who mentioned pricing said:

AR
AvatarImg

Verified reviewer

Computer Software, 501-1,000 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Java developer on PostgreSQL. A look back after several years.

Reviewed 8 months ago

I have been using PostgreSQL for 6 years in most of the applications I write. It is my default choice for a relational database.

Pros

PostgreSQL is a database that every programmer is familiar with. I value its versatility and universality. It's easy to implement it production-wise with not much scale.

Cons

Great for simple applications, when it comes to scaling/replication problems begin.

AR
AvatarImg

Verified reviewer

Computer Software, 201-500 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

The right database for 95% of use cases

Reviewed 3 years ago

Postgres is there for you whenever you need to store and retrieve simple tabular data. Whether that's your app user's name, email, and settings, or the projects and project content that they've created. As long as you're not dealing with over 10k transactions per second, it's cheap to use and extremely easy to set up. Oh, and it's also not great but just okay for advanced searching such as full-text search.

Pros

- Postgres is just soooo reliable, it's hard to corrupt or lose data unless you go in and manually edit or delete the data. - Battle-tested ACID transactions to make sure you only update the data when it makes sense to have saved me so much time. - The SQL interface is easy to use once you've mastered SQL (which it isn't; it's the simplest of all the languages I've learned). - Newer versions even has support for advanced use cases such as arrays and JSON objects. - The best thing is that 90% of the backend software developers know Postgres (or MySQL which is pretty dang similar) so help is never too far away!

Cons

The only real reason to not use Postgres is that it is pretty hard to scale. If your software requires over 10k transactions per second, you're gonna have to put in some serious work make Postgres scale. This is where Postgres becomes a pain to optimize. Postgres provides poor support for identifying the queries that are running really slowly. e.g. you have to install a buggy plugin and then query a funky poorly documented table. Trying to do master-slave replication is also quite difficult as you often run into consistency issues and will have to modify app logic. In these cases, it's better to go with NoSQL obviously.

AvatarImg
AvatarImg

Fernando R.

Computer Software, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Powerful database

Reviewed a year ago

We use PostgreSQL as database tool for all our healthcare software products

Pros

PostgreSQL is eaiser to maintenance and to install than other RDBMS like ORACLE. PostgreSQL is open source so is cheaper than other RDBMS. It takes less learrning time than other RDBMS

Cons

We do not have any cons about PostgreSQL

AvatarImg
AvatarImg

Mark M.

Market Research, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Solid database that won't break the bank and won't let you down

Reviewed 2 years ago

We have never lost data, never paid too much and never looked back. PostgreSQL is at the hear of our organization and our trust has paid off in the long run. Running it on top of a managed stack such as AWS RDS is they way to go as this is the hardest part of using PostgreSQL and you don't want to waste time re-learning what has already been learned. It's worth the cost to use these services in the long run. Rapid prototyping can be done locally and is free so your price to start is always zero!

Pros

PostgreSQL is and always has been one of the most feature rich and solid databases available. Its price / performance / feature set is simply unmatched in the industry today.

Cons

There is a lot of old information on the internet that is no longer relevant to current versions and you must sift through this in some cases to find the modern and elegant solutions. It was touted as "slow" compared to MySQL in the early 2000's and much of that information is wrong due to lack of user experience with the product or no longer the case today.

AvatarImg
AvatarImg

Muhammad Adil M.

Information Technology and Services, 1,001-5,000 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

PostgreSQL

Reviewed 2 years ago

One of the best open source relational database in the market. Large support of data types make it powerful and lots of storage of less schema data. ACID compliant and lock management support.

Pros

PostgreSQL has a wide support of server operating system e.g. windows, UNIX, Solaris, Linux, FreeBSD, Open BSD and OS X. Large support of APIs like ADO.NET, JDBC, ODBC and native C library which makes it easy to connect with any module. Good support of programming languages as well i.e. C, C++, JAVA, .NET, PHP and Python.

Cons

Wide support from community but some times its difficult to track any issue and get support. Reading speed is bit low as compared to other DBMS. Documentation is only available in English.

AA
AvatarImg

Ashish A.

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support

Share this review:

Open source object-relational database management system for Web Developers

Reviewed 5 years ago
Pros

PostgreSQL or simply Postgres implements the SQL and advanced SQL standard very well. It can handle workloads ranging from small web applications to large data warehousing with many parallel users. Postgres provides a easy to use tool called pgAdmin to interact with and manipulate database. It provides support for complex data types like (multi-dimensional) Array, Json, user-defined types. PostgreSQL provides higher number of connections at cheap price. It support all types of indexing for faster retrieval of data. In my company we replaced our database server from MySQL to PostgreSQL because of PostgreSQL higher db connections connections in cheaper price as compared to MYSQL. It is also available free of cost till 10,000 rows on Heroku.

Cons

PostgreSQL query syntax for some complex queries like array, json, string functions and case operator are bit complicated to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as compared to MySQL and it is bit harder to search for help regarding some complex queries and database functions on google. Replication is not yet as well implemented as in MySQL.

AvatarImg
AvatarImg

George S.

Computer Software, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

The most advanced open-source database management system

Reviewed 4 years ago

We use PostgreSQL in most of our projects as a primary backend and our experience has been positive.

Pros

PostgreSQL is one of the most feature-rich, powerful and advanced open-source database management systems. Though this power comes at a cost. Using PostgreSQL in the best possible way takes some time. PostgreSQL is a real beast and it takes time before one becomes fully familiar with it.

Cons

Even with all the power that PostgreSQL gives, there are certain things that are missing. For example, until the latest versions there was no support for partitioning. Lack of a great graphic admin tool is a con in my opinion. Yes, it's possible to use (and we do) third party tools like DBeaver but a great database system must simply have its own admin GUI.

AvatarImg
AvatarImg

Khelvyn C.

Telecommunications, 10,001+ employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

One of the best database managers for the world.

Reviewed 4 years ago

From my point of view postgreSQL I consider it one of the most powerful database managers, since I use it daily, from my role as a database administrator, as well as a web developer, since it allows to manage environments put into production easily, with an acceptable and intuitive configuration.

Pros

1164/5000 -Easy installation and configuration in other environments. - Pgadmin management interface of the databases, very intuitive and complete with the necessary to a few clicks, I recommend keeping the graphical tool for the stability it offers. -It has a connection balancer, known as pgpool that allows to manage the cluster structure well. -Principles of replication between active-active or active-passive...

Cons

- Poor documentation - Functional technicians commonly report a slowness at the BD level, but that depends on how the DB is structured and especially if good database practices are applied

AvatarImg
AvatarImg

Rafał M.

Management Consulting, self-employed

Used weekly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Postgresql (psql) is a great way to start with "serious" RDBMS

Reviewed 10 months ago

Postrgresql was a DB engine for our retail stores cashier system. TCO was 20% compared to Oracle (including hardware and support). Fast, flexible and with great support of programming languages, with API compatibility helped us to run a full scale retail chain (16 offline stores) with real time stock management in our online store.

Pros

+ scalability + SQL compilant + security + open source (free but not without costs) + offers more field types than mysql + API compatibility + low TCO - cheaper than Oracle (but with similar performance) + great programming language support (Python, PHP, C++ etc)

Cons

- free (open source) does not mean witout costs. Sometimes it is very hard to find a specialist that can properly handle PG issues - not present at most of hosting services (but you can always run a virtual machine on AWS EC2) - less tools for data manipulation/analysis compared to MySQL

AvatarImg
AvatarImg

Pinki K.

Computer Software, 51-200 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Best RDBMS for microservice structure

Reviewed a month ago

Its been very good experience to use postgres. Very easy and very effective to manage data. As we have microservice architecture so need lots of database of individual services and with postgres we reduces cost of licensing.

Pros

This is very easy to use and manages. Easy to handle JSON data type and having lots of data type available. Table partitions available for increasing performance.

Cons

Creating store procedure are still very complex and not good as compare to sql server.

VC
AvatarImg

Vin C.

Information Technology and Services, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Fully tried and tested.

Reviewed a year ago

Really well supported by the open source community.

Pros

Easy to setup development wise (Postgres.app), Very well supported by primsa DB. (orm client).

Cons

Cloud pricing tend to be more expensive vs mysql option.

AvatarImg
AvatarImg

Ana A.

Banking, 10,001+ employees

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Relational database with less capability

Reviewed 8 months ago

It is used when a commercial partner vendor introduces a commercial system and creates a small-scale system. If you connect multiple units, it is easy to use with a response that can support the operation without installing a dedicated server machine. When using packaged software in a large-scale system, there may be restrictions on the number of data elements and the number of servers connected, but we were able to reduce installation and operation costs. I was able to keep the cost of the database low and spend money on packaged software options.

Pros

Since it was developed to comply with SQL standards, there are no problems migrating from other RDBMS. I think the popularity of MySQL as an RDBMS is split in two, but PostgreSQL does not have the following MySQL keylogging problem, so it can be said that it is an RDBMS with little custom. We recommend PostgreSQL as the first choice for RDBMS unless otherwise specified because it works stably and can support real operations. When a small business is a customer's system project, the RDBMS license fee is often too high to pay. In such cases, customers will be happy to propose PostgreSQL, which is stable, reliable, and free to use. Unless it is a situation that requires a paid database, I think PostgreSQL is sufficient. It is not inferior to the function.

Cons

When you are looking for something you want to look up in a manual, it is often difficult to find it and, in the end, you often consult blog articles written by experts instead of the manual. I want the structure of the manual to be easy to understand.

AvatarImg
AvatarImg

Cristiano D.

Information Technology and Services, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Very reliable database

Reviewed 4 years ago

PostgreSQL is a very reliable, stable and quick RDBMS. In my experience it has no problems managing hundreds of millions of records. From a DBA point of view, has a very low TCO since once configured it seldomly needs further intervention by the DBA. It comes with PostGIS plugin, so it is very easy to manage geographical data types

Pros

A very powerful RDBMS at the best price point: free Integrated with spatial extension PostGIS Very quick and stable, it manages flawlessly hundreds of millions of records

Cons

Table partitioning is limited Multimaster replicas are available only through a third party distribution

AvatarImg
AvatarImg

Morgan C.

Information Technology and Services, 51-200 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

De facto RDBMS for the Internet

Reviewed 5 years ago

We have run many sites on PostgreSQL with Django at high performance. We use NoSQL where appropriate, but in every case we have still used Postgres for the main data store, and used the key value stores for caching and queueing.

Pros

PostgreSQL is open source. We use it for pretty much every site or system we build. It scales well and needs a minimum of tuning. We only fall back to MySQL when absolutely necessary.

Cons

We still encounter software which can only run on MySQL, especially PHP applications. For those we'll tolerate MySQL but otherwise we would prefer PostgreSQL support.

CW
AvatarImg

Carolyn W.

Higher Education, 501-1,000 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Low-cost alternative to Microsoft SQL Server

Reviewed a year ago
Pros

Cost saving was the main benefit. We switched for the cost saving and also to stay in synch with our vendor Ellucian.

Cons

The transition period was challenging. In particular, we needed to bring on a temporary staff member to help rewrite our 1000+ reports and dashboards from the Microsoft SQL Server language to PostgreSQL. We used the free (unrelated) tool from SQLines to help with this task: https://sqlines.com/sql-server-to-postgresql. I wish the PGAdmin software had a better built-in search feature, but otherwise it seems to have all the same functionality as SQL Server Management Studio.

AvatarImg
AvatarImg

Muhammad T.

Computer Software, 11-50 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

The best relational option

Reviewed 4 years ago

PostgreSQL is a very powerful, great option for large companies that will establish a large database that requires the maximum database manager and needs to squeeze all its benefits.

Pros

PostgreSQL is a robust database that provides highly scalable value, offers superior performance to the options presented as their competitors specially for complex queries, provides flexible data types ,it have many extensions one of them is postgis that adds support for geographic objects.

Cons

Hard learning curve, a lot of GUI controllers are buggy and that is very clear when working on multiple server versions (Backups & restore), the documentation is a bit messy

UA
AvatarImg

Usman A.

Retail, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

A very reliable, steady and no cost RDBMS

Reviewed 6 months ago

Overall experience on PostgreSQL has been good. A very low maintenance is require which is definitely a plus point. Also, see many medium to big size organization using this RDBMS for their mission critical application.

Pros

Steady and reliable. Open source and doesn't require licensing Very less performance tuning is required

Cons

Don't find native ETL Tool Yet to see functionality of data marts and data warehousing

LS
AvatarImg

Levi S.

Computer Software, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

YES

Reviewed 5 years ago

PostgreSQL is my go to for databases for the web development work I do. It has a ton of datatypes that are super useful and has a lot of the features found in the giant (and expensive) competitors. This is a fantastic tool.

Pros

PostgreSQL is powerful, performant, and a snap to integrate with the languages I use.

Cons

The documentation sometimes doesn't make it immediately obvious which version you are looking at. You have to be really careful you aren't using old documentation with a newer version of the product.

AvatarImg
AvatarImg

Jash T.

Internet, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

My favourite one

Reviewed 4 years ago
Pros

The best of databases available in Linux-based hosting. Very efficient, fast, relational and transactional. It has many more possibilities than MySQL, among other things, a lot of unique keys in one table, UUID as a primary key. This is my favorite database, I have been programming it for over 5 years. I recommend to all those who value order and stability.

Cons

it has no weaknesses, well, maybe only those in love with their MySQL bases :)

AR
AvatarImg

Verified reviewer

Machinery, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Easily the best cost/performance ratio on the market

Reviewed 5 years ago
Pros

Powerful, fast, easy. PostgreSQL is straightforward to use, powerful, and it's free to install. Hard to beat that.

Cons

The new management interface pgAdmin 4 is a minor disaster. It was designed from the faulty assumption that database developers/administrators want to use a web interface. I'd like to meet these people as I don't know any of them. Fortunately, pgAdmin 3 is still functional and available. With any luck, it will continue to be so.

AvatarImg
AvatarImg

Alex Danilo M.

Information Technology and Services, 10,001+ employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Postgre review

Reviewed 4 years ago

creation and use of Stored process, triggers, schemas, roles, and transactions.

Pros

PostgreSQL is a great and powerful database system, used in the management of object-related databases, bringing great performances on concurrency, transactions, and schema controls. Furthermore, PostgreSQL keeps focussing on the data secure through the different kind of authentications and access control process. Moreover, PostgreSQL is an open-source license, being very convenient for any company, and any professional developments, counting with complete documentation and community support.

Cons

PostgreSQL has proved to be a great tool, having a great performance on hardy scenarios. However, when is used on a huge amount of object-related requests, the server could show lag issues if the database isn't properly normalized by the developers or database manager or if you have a very low spec server.

AR
AvatarImg

Verified reviewer

Information Technology and Services, 501-1,000 employees

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Very good

Reviewed 3 years ago

our experience is using the database was very positive because it is very easy to use this database

Pros

The database is very good, has many important features, but a very important point is that this database is open source with a very permissive license (based on BSD and MIT), this type of license allows a good legal security and an excellent production cost.

Cons

practically without any negative point, the only one that could be a problem is the difficulty in setting up the bank, but using docker is very easy

AvatarImg
AvatarImg

Juan Carlos F.

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Great quality of software, very productive

Reviewed 5 years ago

All about my work

Pros

All support is available from developers , easy to install in many operative systems, is enough some minimium requirements from your PC.

Cons

Sometimes it's not compatible with some of my databases with previous versions so that is not cool, expensive if you want fully specs.

AR
AvatarImg

Verified reviewer

Computer Software, 1,001-5,000 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

A good SQL Database

Reviewed 2 years ago

Overall, I am quite satisfied with this database.

Pros

It is easy to set up a PostgreSQL database. It can handle multiple requests at the same time thus reducing the latency.

Cons

It is a little on the expensive side and lacks a few features present in noSQL databases.

AR
AvatarImg

Verified reviewer

Financial Services, 1,001-5,000 employees

Used daily for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Good RDMS Application for the Students

Reviewed 7 months ago

Best part is that this can cover by their own triggers , functions datatypes that can be very easy to managed dbs specially like open sources that can be use without any cost effective

Pros

Most of the likely fetcher is multi language support like Java, PHP, C++ , C , Perl, Python, etc.

Cons

when we considering large DBs like data warehouse large number of data reading needed but this is having low reading speed by comparing other rdms applications