PostgreSQL Global Development Group

PostgreSQL

4.5 / 5 23 reviews

Who Uses This Software?

All industries, all sectors, all countries


Average Ratings

23 Reviews
  • 4.5 / 5
    Overall
  • 4.5 / 5
    Ease of Use
  • 4 / 5
    Customer Service

Product Details

  • Starting Price
    Not provided by vendor
  • Free Version
    Yes
  • Deployment
    Cloud, SaaS, Web
    Installed - Mac
    Installed - Windows
  • Training
    No
  • Support
    24/7 (Live Rep)

Vendor Details

  • PostgreSQL Global Development Group
  • www.postgresql.org
  • Founded 1992
  • United States

About PostgreSQL

Free open source post-relational database system that runs on all major operating systems. PostgreSQL's 25 year development history provides a huge range of features for Developers and DBAs, delivered in a robust software server used world-wide. PostgreSQL is rated in the top 5 databases by DBEngine, above most commercial systems. With millions of deployments in embedded systems, major cloud providers and major on-premise installs, PostgreSQL is the most popular choice for new app development.


PostgreSQL Features

  • Backup
  • Creation / Development
  • Data Migration
  • Data Replication
  • Data Search
  • Database Conversion
  • Monitoring
  • Performance Analysis
  • Queries
  • Relational Interface
  • Virtualization

PostgreSQL Reviews Recently Reviewed!


Adheres well to current SQL standards, and easier to learn as a result.

Feb 15, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money

Pros: - Open-source.
- Rich variety of data and character types.
- Fully ACID-compliant
- Designed for reliability and data-integrity; developer-focused

Cons: - Somewhat slow for inserts and updates ( due to pgsql having to check for triggers and such )
- Some SELECT queries may be slower than their counterparts
- Large footprint makes it ill-suited for read-heavy operations
- Replication is poorly-implemented
- Not well-suited for low-concurrency projects

Capterra-loader

Good structured Database

Jan 15, 2018
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: The best part of this DB is it comes in various pack at free and enterprise level, so user can use it's in own way

Cons: Sometimes the installation process feel problem as compare to other existing DB like MSQL, OracleDB.

Scalable

Jan 10, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I use postgresql even in my small projects it's very secure fast and in case I have a big project I can scale it.

Cons: The user system is kind of weird when you compare it to other DBMS, but except that I do not have any big issue with postgresql!

Open source object-relational database management system for Web Developers

Jan 09, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money

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.

I love Postgres! I would recommend it to anyone!

Dec 07, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: I love the ease of the data flow. It is easy to input and easy to read. It makes my life so much easier.

Cons: If they could scale sideways, yet still be a relational database that would be amazing. No one does that though.

Overall: When I use Postgres I am happy. It does what I want, how I want, when I want. You can't get that just anywhere.

Capterra-loader

Postgres is the most effective Open source Database

Dec 04, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: It's open source. So, its great for startup companies. It is fully SQL compliant. The admin tool PGAdmin is powerful. I am impressed with the custom data types supported by Postgres mainly JSONB.

Cons: We faced problem while using custom data types like JSONB. Inserting data to these type of columns via Hibernate is not straightforward. We referred a couple of articles on that to resolve the issue. https://github.com/thjanssen/HibernateJSONBSupport/tree/master/PostgresJSONB

Capterra-loader

Good DBMS. Handles a lot of data without loss of performance

Dec 04, 2017
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: It is very fast for running queries from bash (logged in by SSH) or within PGAdmin (from a distant client) ; the ability to lauch queries from PHP permits building web-apps using the database very simply.

Cons: Using variables in not as simple as in MySQL. It needs to use plSQL or mixing bash and SQL.
I prefer PgAdmin 3 rather than PgAdmin 4. This new version seems to priorize design rather than ease of use.

Overall: It is a lot more efficient than the old database manager we used before.

Capterra-loader

Great quality of software, very productive

Nov 21, 2017
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

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.

Overall: All about my work

Used in grad level data science courses

Nov 14, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: PostgreSQL is a good relational database that supports user defined data types.

Really nice/helpgul to have documentation publicly available

Cons: PostgreSQL is not widely used so it can be very difficult to get community support

Replication is harder than with MySQL

Capterra-loader

Best free open source database which is also available in the Amazon web services as PaaS

Nov 13, 2017
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Good full text search capabilities
Good UI tool from PG Admin
Good Security features
Good User and group management

Cons: Requires good stability
Good scalability in the enterprise environment
If we put large text, some times response is very slow
Some times auto vaccume takes time

Overall: Free of charge
Open source
Many available plug-ins
Able to usw in AWS as PaaS

Great choice for small and medium organizations.

Nov 09, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Relatively small memory use, good performance and easy to learn and use. Good price for the package.

Cons: The chance to become private like Mysql and others. It can have a better customer support, the server runs on Linux which is not easy for some people.

PostgreSQL is te best DBMS out there.

Nov 09, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: PostgreSQL is a robust yet very easy to use DBMS. You can trust PostgreSQL to save your data no matter how big it its. It is very well documented and the community that develops it is the best (thanks guys!). In the newer versions it nows supports saving JSON data so you can use it as a NoSQL solution. PostgreSQL is simply the best.

Overall: Having a robust DBMS for our database is great.

Capterra-loader

Postgres is simple and to the point.

Nov 07, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: There is a huge community of power users online and I feel like I can always get my questions answered with a quick google search.

Cons: There's not really anything that I dont like...maybe if Postgres hosted their own knowledgbase that contained their SQL operators.

Overall: The online community of postgres users is fantastic. I love being able to dive into answers from users who have used the tool more often than I.

PostgreSQL is reliable, feature-rich, and allows us to process thousands of transactions per second

Oct 12, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: PostgreSQL is durable and fault-tolerant by design; great effort is taken by the developers to ensure reliability is maintained.

This cautious approach does not hinder development though; constant enhancements are delivered in every release, with new features generally arriving ahead of much more expensive commercial products.

With both community and commercial support, bug fixes and security issues (although rare) are always addressed quickly, and generally resolved far quicker than most commercial vendors.

With a wide selection of both free and commercial tools to accompany it, we are easily as productive if not more than we would be with a commercial offering.

Overall PostgreSQL has excellent speed, reliability and support of SQL standards; coupled with its "free forever" licensing, there is no risk of costly vendor lock-in.

Cons: There's very little to dislike about PostgreSQL, and the "free forever" BSD style licensing means you've nothing to lose in trying it for prototyping you next project. I've no idea why anyone would use anything else.

Runs a large database containing a millions of records without breaking

Sep 12, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: I can say that it's really hard to go wrong in recommending PostgreSQL to anyone with even a small amount of technical knowledge.

Cons: I think it's not easy to understand how to do database backups and for that reason i don't like do it

The best software for database administration.

Jul 12, 2017
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: It allows you to make almost everything to a database, and the way you can make triggers and functions very easy. It have endless posibilites

Cons: You need to set up very carefully the users and permission, otherwise you can end up deleting the base database.

Overall: I learned up how to administrate a data base to the maximum thanks to this software

Runs a 150GB DB containing a quarter million records without breaking a sweat

Jun 07, 2017
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Pretty much everything, although there are a few features from commercial databases that I'm hoping will make it in. After having used it for several years, and a certain "M" competitor for several years prior, I can confidently say that it's really hard to go wrong in recommending PostgreSQL to anyone with even a small amount of technical knowledge.

Cons: - Setting up replication can be a bit tricky
- There isn't really a good repository for an up-to-date (or per-version) list of common tips, tricks and queries. Often can be some googling to track down what you're looking for

I had a good experience since the first time i used this in my college

Jun 07, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: I like the powerful security levels in this database system despite being open source, and i like work it in different operative systems.

Cons: I think it's not easy to understand how to do database backups and for that reason i don't like do it

Overall: it's a powerful open source database system, and it's a trendy software

I consider PostgreSQL like the best open source relational database, it is very robust.

Jun 07, 2017
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: It has a lot of features and functionalities. It is open source. It has a balanced and clear GUI through pgAdmin

Cons: It is not the database that many language use by default like MySQL, you have to make a couple of additional steps to set the configuration but it worth it.

Overall: Its technical characteristics make it one of the most powerful and robust databases in the market.

Love your relational database again!

Apr 20, 2017
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Easy to install, high performance, hold many kinds of data fields, highly reliable

Cons: The CLI is not the best option when your tables have several columns

Overall: Postgres is by far the strongest database relational engine, it's a one package solution, it will hold tons of transactions with no problems, it is highly reliable and high performance based.

We use Postgres to hold the data for both our web app and Mobile apps, we use a web service layer that interacts directly with the data base and it works like a charm.

It will also allow you to store things like JSON objects (JA! Take that MongoDB!) and use those objects and even create search queries based on that data.

Recommendations to other buyers: If you come from MySql world this is by far the best open source db option that you might use

PostgreSQL - Powerful Database with ease of use and portability

Jan 11, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: A strong and powerful alternative to many other popular DB's.

Overall: During different database evaluation for a Project, I found "PostgreSQL" to be a strong relational database, what I was looking for an Oracle like DB, to support all the features that are supported by Oracle, here I found that alternates for most of the options available in other DB were available.

Also, the admin features were pretty straight forward and a lot of support was available online which made it even easier to use.

great DB option for SQL based DB seeker

Dec 06, 2016
5/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money

Comments: Bullet-proof DataBase with big scalability. It's SQL-based so very easy to use and lots of people are familiar with its syntax, yet provides more features than mySQL

Simply the Best RDS

Nov 11, 2016
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Comments: if you need a RDS look no further as postgres is simply the best relational database around. its a no brainer. its free and has the best features you could ask for including jsonb and upsert.