Join the 1500 companies using G2 Track to manage SaaS spend, usage, contracts & compliance.
Do you work for PostgreSQL?

PostgreSQL Reviews & Product Details


What is PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system.

Write a Review

PostgreSQL Screenshots


PostgreSQL Profile Details

PostgreSQL Profile Details

Vendor
PostgreSQL
Company Website
Year Founded
1989
HQ Location
N/A
LinkedIn® Page
www.linkedin.com
Employees on LinkedIn®
66
Twitter
@postgresql
Twitter Followers
11,280
Show moreShow fewer

Customers Using PostgreSQL

Cisco
Microsoft
IBM
Adobe
Amazon
VMware
ADP
LinkedIn
Accenture
Hewlett-Packard
Target
Rackspace

PostgreSQL Reviews

Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
All Industries
Write a Review
1-50 of 384 total PostgreSQL reviews

PostgreSQL Reviews

Write a Review
Filter By
Connections
Show reviews that mention
1-50 of 384 total PostgreSQL reviews
Copy Review URL
PostgreSQL review by Subodh Y.
Software Developer
Mid-Market
(51-200 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Developer Friendly Database"

What do you like best?

I have been working from last one year with different database , I realized that PostgreSQL is best database for back end. It is very developer friendly database, we can import and export the database as csv file from database and to database. It is most compatible with python and other language. It provide the facility to make a backup of database. Developer can add row and column directly in table of database and see schema as well as get ER diagram for model.

What do you dislike?

It does not have data type of blob , just because of this some times developer faces the problem to store the images in blob format.

Recommendations to others considering the product

I can say only one thing , just use once then I don't think you will go for other database.

What business problems are you solving with the product? What benefits have you realized?

We have developed an application which is used for video calling , messaging and sharing file etc. As back end team we are using PostgreSQL database. I realized that it is faster than other database. Most powerful feature of PostgreSQL is data type like json.

Copy Review URL
PostgreSQL review by Michell R.
Gerente de Proyectos
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Database manager very powerful and the best thing is that it is free!"

What do you like best?

This management system offers performance characteristics that have evolved over time. Also its use and constant review of the developer community have made it one of the most stable systems in terms of open source refers to. The graphical environment offered by Pgadmin allows an intuitive and easy to manage administration. If you have used other database administration systems, the adaptation to Postgre SQL will be very fast and little traumatic. The SQL statement editor is very practical, which allows to perform the operations most commonly used in any database. Finally, the backups and recovery of databases are carried out quickly and in a few steps. The reliability of this function is very high. Particularly, during the time I have been using this manager I have not presented any type of error or catastrophic loss

What do you dislike?

The main hosting providers do not support database of this management system. The big corporations still have resistance for the use of this manager. The support is provided by the developer community, which produces long periods of time to resolve. It does not have an error identification and traceability mechanism.

Recommendations to others considering the product

Free technologies are not necessarily unstable. If you require a database management system with good security features, information integrity for a medium volume of transactions, try PostgreSQL

What business problems are you solving with the product? What benefits have you realized?

In countries where the use of free technologies is encouraged, great benefits can be obtained because there are no additional payments for user licenses and the client owns the generated code, which allows its administration and modification without inconvenience.

Copy Review URL
PostgreSQL review by Miriam C.
Desarrolladora Web
Mid-Market
(51-200 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Postgresql"

What do you like best?

Postgres is a powerful database manager to handle large amounts of data, it is fast, easy to install and with a very intuitive graphical interface, I am a web application developer and it has been an important key for my knowledge about base managers. data many times I have to design models and this has been a great help for the successful development of my applications.

it's scalable,

integration

customizable

and very easy to use

Estabilidad y confianza en los datos, posee potencia y robustez , extensibilidad usado por gran variedad de lenguaje de programacion

What do you dislike?

It is relatively slow in other database managers

does not have telephone support

the syntax of some commands sometimes is not instuitive

Recommendations to others considering the product

Postgres is a powerful database manager to handle large amounts of data, it is fast, easy to install and with a very intuitive graphical interface, I am a web application developer and it has been an important key for my knowledge about base managers. data many times I have to design models and this has been a great help for the successful development of my applications.

it's scalable,

integration

customizable

and very easy to use

What business problems are you solving with the product? What benefits have you realized?

Important data management of the company

important reports

crosses of data

historical data

operation between dates

advanced searches

relationships between work

standardization

Copy Review URL
PostgreSQL review by Nairoby D.
Administrador de Bases de Datos (DBA). Consultor TI
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Free code database manager"

What do you like best?

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.

What do you dislike?

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

Recommendations to others considering the product

The administration of a postgres cluster is great, we can synchronize a slave and a master and it works perfectly the synchronization and replication

What business problems are you solving with the product? What benefits have you realized?

I work daily in the management of postgres databases, used the console for backup and restore issues since they are much faster

Copy Review URL
PostgreSQL review by Alex Z.
Coordinador de Infraestructura Tecnológica y Seguridad de la Información
Information Technology and Services
Mid-Market
(201-500 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Postgresql"

What do you like best?

Postgres is a powerful database manager to manage large amounts of data, it is fast, easy to install and with a very intuitive graphical interface, I am a web application developer and it has been an important key for my knowledge about base managers. data many times I have to design models and this has been a great help for the successful development of my applications.

it's scalable,

integration

customizable

and very easy to use

Stability and confidence in the data, has power and robustness, extensibility used by a wide variety of programming language

What do you dislike?

It is relatively slow in other database managers

does not have telephone support

the syntax of some commands sometimes is not instuitive

Recommendations to others considering the product

it's free, it handles data fast enough, you can save data and then process it through information systems

What business problems are you solving with the product? What benefits have you realized?

handling large amounts of data for reports basically.

Copy Review URL
PostgreSQL review by Govardhana K.
Automation Anywhere Tool is Very useful
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Review of PostgreSQL"

What do you like best?

PostgreSQL is a good alternative in the open source database world. PostgreSQL gives us a stable and more cost-effective solution for data storage. PostgreSQL is a Advanced version of SQL,which provides support different functions of SQL like, foreign keys, sub queries,triggers and different data types

What do you dislike?

Clustering -- we'd love to see clustering built into the product itself instead of third-party.One drawback that I have personally experienced is that it is a bit harder to get community support or to Google for results. However, with more use of PostgresSQL the community support is getting better.

Recommendations to others considering the product

Postgre SQL is well suited well in a POC and quick turn around time development activities.PostgreSQL also seems to be user friendly to non-DBAs.

What business problems are you solving with the product? What benefits have you realized?

This Tool is very helpful for small scale organization

Copy Review URL
PostgreSQL review by Maria L.
Consulente IT
Small-Business
(2-10 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"The definitive DB you need"

What do you like best?

- Its free and open Source!

- Transactional support for schema migration,

- Large variety of custom functionality and plugin,

- Great overall performance - perfect for system with low hardware specs - it is light and well optimized

Huge community with a great support

What do you dislike?

- Backup and Restore of large DB are a bit slow, with some significant performance gap compared with other DB

- Not very User Friendly for new users or for those who are used to using paid software

- The absence of the possibility of the clustering is essential for us, and we must therefore rely on a third part software.

Recommendations to others considering the product

It's one of the best DB that you can find!

Its:Open source, have a huge and great community, new versions are released every six months (they are very stable too), it support JSON, XML and Geospatial

What business problems are you solving with the product? What benefits have you realized?

We doing Web-based product and we used it for storage and DB purpose. It is used by our entire organization and is well-integrated iwth our business process. With it we have reduced costs due to licensed sotfware, and speeded up the development in general. We find in PostgreSQL everything we need!

Copy Review URL
PostgreSQL review by User
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"PostgreSQL is great for database management!"

What do you like best?

PostgreSQL allows us to easily run queries and cross-reference information from various tables of data we have stored. As a subscription-based service with millions of user emails and information, this is extremely important.

What do you dislike?

While simple for someone who knows SQL there is a learning curve. It would be amazing if PostgreSQL allowed for easy implementation of a UI that was friendly to those who are not familiar with the coding behind queries to run searches in order to pull information from various sources.

What business problems are you solving with the product? What benefits have you realized?

We are able to search our information for potential abuse by users, as well as find accounts that may have been impacted by a bug in our system and mass resolve issues. More recently as we migrated billing systems some accounts had fallen through the cracks and were not billed in a few months. We were able to use PostgreSQL to write a query in order to find those accounts and bill them going forward.

Copy Review URL
PostgreSQL review by Dr,joseph t.
ICT Specialist
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

"why people prefer most to use post gre sql"

What do you like best?

in postgresql people are able to have fool access of their data hence monitoring it is very easy,however monitoring the database is in real time .it also has the tools that give easy use of the software.in addition it give multiple integrations of different databases and also acquiring analysis of data is easy.

What do you dislike?

although each software has its weakness but for now i could not tell any limitions ,hence if anything against the software comes across i will be able to raise the grevances required in order to rectify.

Recommendations to others considering the product

i personally i recommend those people who want to keep their data secured each and every time hence they will be able to access data very easy.however i would prefer them to use the software so they can share data and discuss it in real time and see full infrastructure in the cloud

What business problems are you solving with the product? What benefits have you realized?

it has helped me to keep my information in quality and quantity manner without any data loss,it also helped me to keep data in secure way hence nobody can intrude to the software without permission of the user.it also helped me to analys my data at any time at any place

Copy Review URL
PostgreSQL review by Ahmadou N.
Soccer Referee
Enterprise
(1001-5000 employees)
Validated Reviewer
Review Source
Copy Review URL

"Database as you know it"

What do you like best?

I pretty much enjoy the elastic factor in its design and implementation. Offers a huge deal with data storage and security. As compared to MySQL and other database systems, PostGresSQL stands out as the go-to database when it comes to data redundancy and better maintenance.

The pricing is not bad either and cloud solutions providers offer great supports. I should know, I use them whenever I need.

What do you dislike?

The setup is not that easy mostly on the Linux environment. The user has to have a better knowledge about the installation and usage before engaging on this database choice but it is worthy to spend time and energy learning.

Recommendations to others considering the product

If you are looking for a database that offer more tools as compared to the general SQL you are used to, try PostGresSQL, I guarantee you will never look back

What business problems are you solving with the product? What benefits have you realized?

Data storage and maintenance.

It is the database of choice when it comes to cloud storage and I use it mostly from Heroku and Amazon ASW platforms

Copy Review URL
PostgreSQL review by User
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"An Open source database for small to large scale organizations for free"

What do you like best?

The PostgreSQL server has the advantage of having the security features of a paid service database, and the features of an open source database such as contact support, strong customer base which makes the service unique.

What do you dislike?

There are few technical glitches while trying to login using PostgreSQL server, because of this issue I had to uninstall the application multiple times to login into the server. It also has a problem regarding the duplication and restoring the database.

Recommendations to others considering the product

This PostgreSQL server is advantageous for performing the data analysis directly from the database, this product has a good security feature with a very inexpensive price for the customers. This is what makes the PostgreSQL server advantageous.

What business problems are you solving with the product? What benefits have you realized?

I have used the PostgreSQL server to store the data required for performing the data analysis. The advantage of using SQL server is I can automate the data wrangling and ingestion process by connecting through the application programming interface using python for PostgreSQL (psycopg2) package.

Copy Review URL
PostgreSQL review by ALEXANDER J.
Ingeniero III
Enterprise
(1001-5000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Excellent Database Manager"

What do you like best?

Database with excellent features to store data, integration with many applications developed in different languages ​​of application development, compatibility with Windows operating systems, Linux, etc. Ease of integration with ETL solutions, to store data warehouses to interact with business intelligence software, allows replication of data with streamig replication, the availability of operational continuity through the implementation of pgpool, binaries to perform backup and recovery processes , implementation of WAL, possibility of executing auto vacuum to keep the objects of the database clean, version updates of the postgresql SMBD, are easy and applications are not affected.

What do you dislike?

The postgresql database management system has a weakness that does not have high availability mechanisms, does not include cluster administration, only includes isolated tools for the implementation of continuity of service, and integrates a group of solutions to support postgresql as This is the case of pgpool

Recommendations to others considering the product

Before the implementation of postgregar in your infrastructure, make a test plan for the compatibility of the applications developed, perform a intonation postgresql of SMBD, so that the performance of the work is adjusted to the servers where it is installed. Implement a backup and backup plan, install a good software to monitor the performance of the database, I recommend NAGIOS as software for monitoring, from my own experience I recommend installing the postgresql SMBD under the Debian operating system, and verify the configuration files to customize the parameters for the best performance of the postgresql SMBD.

What business problems are you solving with the product? What benefits have you realized?

Reduce maintenance and licensing costs

Copy Review URL
PostgreSQL review by John R.
Co-founder, lead developer
Small-Business
(2-10 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"By far the most powerful and advanced open source database software"

What do you like best?

The developer community behind Postgres is phenomenal. Not only do they keep the software active, they give their time speaking and teaching about the software. The speed and reliability of the software is also great.

What do you dislike?

Postgres number one priority is data reliability, then speed, which causes some features like COUNT() to be slower than I'd like. While this is ideal 99% of the time, there is that 1% when I wish there was an option to configure the software to make COUNTs faster, even if it meant less reliability for that qeury's result.

Recommendations to others considering the product

Setup and configuration are not easy, but it's mostly system administrators and DBAs using it so that is to be expected. Admin tools, such as pg_basebackup, have improved.

What business problems are you solving with the product? What benefits have you realized?

Postgres powers our web based software, Intervals. It's been the best choice we could have possibly made for over 11 years since we first adopted it. We have benefited most from the speed improvements and replication features.

Copy Review URL
PostgreSQL review by Rishabh K.
Senior Software Developer
Retail
Validated Reviewer
Review Source
Copy Review URL

"User Friendly and Fast"

What do you like best?

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.

What do you dislike?

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

Recommendations to others considering the product

The administration of a postgres cluster is great, we can synchronize a slave and a master and it works perfectly the synchronization and replication

What business problems are you solving with the product? What benefits have you realized?

I work daily in the management of postgres databases, used the console for backup and restore issues since they are much faster

Copy Review URL
PostgreSQL review by Joy P.
Project Manager
Mid-Market
(51-200 employees)
Validated Reviewer
Review Source
Copy Review URL

""Amazing Database Manager""

What do you like best?

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.

What do you dislike?

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.

Recommendations to others considering the product

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

What business problems are you solving with the product? What benefits have you realized?

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.

Copy Review URL
PostgreSQL review by Ashish G.
Software Engineer
Information Technology and Services
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Open source object-relational database management system for Web Developers"

What do you like best?

PostgreSQL or simply Postgres implements the SQL standard very well. Postgres provides a easy to understand tool called pgAdmin to interact and manipulate database. It provides support for complex data types like Array and Json. It can handle workloads ranging from small web applications to large data warehousing with many concurrent users. It is available till 10,000 rows on Heroku.

What do you dislike?

PostgreSQL query syntax for some complex queries like array,string functions and case operator are is not easy to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as MySQL and it is bit harder to google search results.

Recommendations to others considering the product

I recommend PostgreSQL to all web application who are looking for cost effective database. It supports almost all types of backend server like, Java, Ruby, Python etc. Postgre SQL provides high level of parallel queries. It support very useful types like array and JSON.

What business problems are you solving with the product? What benefits have you realized?

From last one year we moved from MySQL to Postgres for database needs reason being of its support for multiple concurrent connections in affordable price. We are now using Postgres database for our new projects. I got benefit using PostgreSQL in term of price, speed, support of complex type and easy to learn query syntax.

Copy Review URL
PostgreSQL review by Consultant in Higher Education
Validated Reviewer
Verified Current User
Review Source
Copy Review URL
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Rock Solid stability"

What do you like best?

PostgresSQL is one of the most stable and functionally rich open source RDBMS. It performs really well while implementing complex queries. It is also convenient to shift your database architecture into PostgresSQL. Because of its ubiquity, you can find solutions to any issue you might face on the online community. , PostgreSQL is offering an amazing amount of functionality for any database, let alone an open-source project. And in almost every case, the current functionality is just the first part of a long-term roadmap that the developers will continue to follow.

What do you dislike?

PostgreSQL's functionality in areas like Partitioning or query parallelization has been fairly weak. Also it's syntax is a wee bit different than most of the other SQL vendor languages but it's not significantly different.

What business problems are you solving with the product? What benefits have you realized?

The business problem that I am solving with PostgreSQL was to query data for further processing. I was working on generating intelligent reports with data from an Alfresco Architecture whose data resided in a PostgreSQL database. The benefits I observed were, it was free to use and the queries functioned perfectly.

Copy Review URL
PostgreSQL review by Matthew D.
CTO
Mid-Market
(201-500 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Backbone of our stack"

What do you like best?

Postgres is an incredibly stable database workhorse. It handles production traffic with ease, and its default settings are generally very stable and scalable. It links easily to all sorts of ETL tools and supports all major ORM libraries.

What do you dislike?

Well, just like any SQL database, by default it's not vertically scalable. So once you can't upgrade your database server hardware further, you sort of hit a cap, until you put in sharding logic.

Recommendations to others considering the product

Realize that, if you're going to use this for production, you need DB experts on your team, even if you're getting postgres from AWS or from Heroku

What business problems are you solving with the product? What benefits have you realized?

Running our business and powering our website

Copy Review URL
PostgreSQL review by Ross M.
Corporate GIS Data Coordinator
Government Relations
Enterprise
(5001-10,000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"PostgreSQL - the heart of our GIS"

What do you like best?

PostgreSQL with PostGIS and pgRouting offers us a flexible, robust and reliable open source database platform on which to build the rest of our GIS infrastructure. The open source license gives us the freedom to install and use it as we like.

What do you dislike?

If I had my way I would switch out all our other RDBMS for PostgreSQL.

Recommendations to others considering the product

PostgreSQL offers a solid database platform on which to build applications for organisations not willing to pay large annual maintenance fees. It scales well from small single use applications to large clustered enterprise-wide systems. The open source license lets you install as many instances as you need for free. The open source, standards compliant database allows you complete flexibility in designing the database and any applications it underpins. PostGIS and pgRouting are database extensions that add greatly to the capabilities of the product and are core to our GIS infrastructure. Documentation for the product is second to none and the user community is excellent. If you so wish, support contracts are available from a number of suppliers in the UK and internationally. PostgreSQL is also available from many cloud service suppliers and runs on all major operating systems.

What business problems are you solving with the product? What benefits have you realized?

PostgreSQL replaced Oracle at the heart of our GIS infrastructure. We have saved money on software licenses, reskilled a number of people in database administration and reduced the number of files stored in directories to almost zero by putting the data in the database. The database is becoming the single source of truth for all spatial data in the organisation. The flexibility offered by the database has improved the efficiency of a number of different data creation and maintenance workflows and as a result we have grown the number of users from 10 to 75.

Copy Review URL
PostgreSQL review by Lakshmi B.
HR Manager
Information Technology and Services
Mid-Market
(51-200 employees)
Validated Reviewer
Review Source
Copy Review URL

"My experience with PostgreSql"

What do you like best?

PostgreSQL is a comprehensive, sophisticated database system offering countless features. As of PostgreSQL 10.0, the documentation alone is roughly 3,500 pages

What do you dislike?

…not so great as an ODM, as is true of any relational database. If you are storing data as an object/document, you should consider Mongo or something along those lines.

Recommendations to others considering the product

Deep Security has been tested with these PostgreSQL 9.6 distributions: PostgreSQL Core Distribution and Amazon RDS for PostgreSQL. The Deep Security Manager installer will check that you have a supported database installed. However, there is no ongoing monitoring of the database version, so if you decide to upgrade your database after installing Deep Security Manager, you must ensure that you upgrade to a version that is supported by the manager.

What business problems are you solving with the product? What benefits have you realized?

Parallel queries

Advanced locking mechanisms

Many different types of indexes (btree, gist, gin, hash. sp-gist, brin, bloom, etc.)

Advanced cost-based query optimization

Tablespaces

Copy Review URL
PostgreSQL review by Internal Consultant
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Flexible and fastest Data base for higher scale projects"

What do you like best?

Postgres data base is light weighted and flexible data base.Recently we have migrated to Postgres and its really easy to develop and maintain.Since it is open source we got advantage to spend money on cloud services to maintain independently.This data base has lot features and we can use for large scale applications.

What do you dislike?

Some of the common SQL language syntax can be maintained without customizations.Some time we feel difficulty to find syntax in online.Otherwise, this DB is better than other open source DB tools.Some times we found some bugs which is related to tags and queries, especially libraries can be improved and documentation can be provided in detail level.

Recommendations to others considering the product

Strongly recommended DB for any open source ideas.

What business problems are you solving with the product? What benefits have you realized?

We are able to reduce cost by migrating to open source Db. We are able to separate all functions and views without any extra efforts while migrating. These DB helped us to reduce overall cost in Cloud as well, on top of all advantages, query language is very simple.

Copy Review URL
PostgreSQL review by User
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Great Database System"

What do you like best?

Well, over time MySQL and PostgreSQL have grown closer and closer together, but for the longest time I've enjoyed using postgres over other free open source RDMBS because it had more analytical functions. Postgres has been supporting tricky things like window functions which was always super useful for tricky aggregations for reports.

However, what I like best about postgres is probably the actual documentation that is easily available that includes tons of explanations and examples. This means I can quickly make changes and figure out how to make my application needs work just by myself, even if I've never had to use Postgres or another RDMBS to do that task before.

What do you dislike?

I can't say I dislike anything about postgres. The things that are 'bad' about postgres are what you get for having a relational database that uses hard disk as storage. But those are normal things that honestly don't usually slow you down or hurt your application.

Sometimes I'll use redis for a fast, non-relational in-memory database, but otherwise I always use postgres since it's free, documented well, and a great tool.

Recommendations to others considering the product

These days you can drop in replace for MySQL pretty much, but I prefer postgres for the great documentation.

What business problems are you solving with the product? What benefits have you realized?

Well, I simply use postgres to save data in one place like any database. Postgres is a great open source relational database system so it helps keep your data in one place and normalized. I will often setup mini web apps for my company's other teams to quickly pull/aggregate data and reports, and postgres is great for that.

Copy Review URL
PostgreSQL review by Carson W.
CTO
Small-Business
(2-10 employees)
Validated Reviewer
Review Source
Copy Review URL

"Powerful, Flexible, Database"

What do you like best?

I have used this database for a number of years now and have to say it gives one the most bang for one's buck. It is extremely powerful, and flexible with the addons provided, hstore, jsonb, ltree etc. its by default powerful, so if you're looking for a simple database this is not for you. This database is still fairly easy to use, but it leaves out a lot of things that are default to mysql (mariadb)

What do you dislike?

I wish that the ltree implementation supported dashes so full uuids could be used. Otherwise there isn't really that much to complain about, better support for built in under the hood horizontal sharding would be nice but that would be hugely complicated and probably wouldn't work.

Recommendations to others considering the product

Give it a chance, the cost of learning is worth the power it affords.

What business problems are you solving with the product? What benefits have you realized?

Our data storage for our whole app is in postgres.

Copy Review URL
PostgreSQL review by Jennifer G.
Pharmacy Technician
Hospital & Health Care
Validated Reviewer
Review Source
Copy Review URL

"Great Database"

What do you like best?

This is an amazing database! Not only is it reliable but It has great features that make it easy to store data and use multiple languages. It's easy to customize and I love that it is compatible with Linux as that is what I primarily use. Also, it is great that there is a community still involved in this software who are able to teach new (or even experienced) people using PostgreSQL.

What do you dislike?

I've had some issues with PostgreSQL running a little slow and I'm not a huge fan of all of the syntax, as some of it seems a bit counterintuitive. As a result, I think it is pretty difficult to use as a beginner.

What business problems are you solving with the product? What benefits have you realized?

As an intern, I primarily used PostgreSQL to manage simple tasks under some guidance. However, even in that role I could tell that it is a very powerful database with a lot of benefits to someone who knows how to use it.

Copy Review URL
PostgreSQL review by Allison T.
Junior QA Tester
Financial Services
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Simple and easy to use"

What do you like best?

I like how simple this software is. It doesn't try to get you with a fancy UI or anything crazy intricate. it's straight forward and it is easy to use for anyone who has SQL experience. Whether in the classroom or at the workplace, it's a really great program for database work. It's user friendly in the sense that is is basic and easy. It may not have all the bells and whistles of other software but that's kind of what I like about it. The output pane when doing queries is nice and simple to read. it's easy to make sure you can see all of the data you need to see in your databases. I also like that the SQL editor gives you color differences on the words so you know that you are entering the correct information. It will come up red if it thinks something is wrong.

What do you dislike?

It's hard to tell sometimes which DB on your server you are in, as it doesn't highlight it very well. It also is somewhat annoying to have to open a separate screen for actually running SQL.

Recommendations to others considering the product

Learn up on SQL!

What business problems are you solving with the product? What benefits have you realized?

We are able to look up information quickly when a user needs to know about data that we can only find within the database. It's great for when we are looking into defects and also for writing automation tests. There are a lot of benefits.

Copy Review URL
PostgreSQL review by User in Program Development
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"PostgreSQL review"

What do you like best?

Although the speed of response may seem deficient in small databases, that speed is maintained by increasing the size of the database, which is not the case with other programs, which slow down brutally.

Unlimited installation: You can not sue a company for installing it on more computers than the license allows, as there is no cost associated with the software license. This allows for a more profitable business with large scale installations, we should not worry about being audited to see if we comply with the license, and there is flexibility and development without additional licensing costs.

Considerable savings in operating costs: PostgreSQL has been designed to have lower maintenance and adjustment than products of commercial suppliers, retaining all the features, stability and performance.

Stability and Reliability: No database crashes.

Extensible: The source code is available for free, so that whoever needs to extend or customize the program can do so without costs.

Multiplatform: Available on almost any Unix, with 34 platforms in the latest stable version, plus a native version of Windows in test state.

Designed for high-volume environments: Using a row storage strategy called MVCC, it gets better response in large volumes. In addition, MVCC allows read-only accesses to continue reading consistent data while updating records, allowing hot backups

Graphic design and database management tools.

It supports the SQL92 / SQL99 standard and standard type data, clauses, functions, and extended commands of PostgreSQL.

It can operate on different platforms, including Linux, Windows, Unix, Solaris and MacOS X.

Good security system through the management of users, groups of users and passwords.

Great storage capacity.

Good scalability as it is able to adjust to the number of CPUs and the amount of memory available optimally, supporting a greater number of concurrent requests to the database correctly.

What do you dislike?

Compared to MySQL it is slower in insertions and updates because it has intersection headers that does not have MySQL.

Online support: There are official forums, but there is no obligatory help.

Consume more resources than MySQL.

The syntax of some of your commands or statements is not at all intuitive.

Recommendations to others considering the product

YES

What business problems are you solving with the product? What benefits have you realized?

Multiversion concurrency control; the MVCC; this method adds an image of the state of the database to each transaction. This allows transactions to be made consistently, offering great performance advantages. For example, it is not necessary to use read locks when performing a transaction, which provides greater scalability. thus solving scalability problems.

Copy Review URL
PostgreSQL review by George L.
Data Engineer
Computer Software
Enterprise
(10,001+ employees)
Validated Reviewer
Review Source
Copy Review URL
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"PostgresSQL with Greenplum"

What do you like best?

The greenplum database running PostgreSQL is a good database for large workloads that run on massively parallel databases like Greenplum. I can distribute the tables by a certain column identifier and be able to link different tables together for efficient workloads.

What do you dislike?

I dislike the PGAdmin III interface which is made for PostgreSQL developers because it's an old program and the new one, PGAdmin 4 does not support older versions of PostgreSQL databases. Version compatibility is a big deal and my company still uses the older version of PostgreSQL so I am stuck with using an older version of the application to manage the database.

Recommendations to others considering the product

For companies considering PostgreSQL, you need to seriously consider the backend provider whether it be Greenplum/Pivotal or Amazon, you must make the proper selection that will be sufficient for the data that you are working with. With Amazon Web Services, it becomes price efficient to run these databases in the cloud at a reasonable cost with great efficiency.

What business problems are you solving with the product? What benefits have you realized?

PostgreSQL has been able to help us conduct data quality operations and archive data in an efficient manner.

Copy Review URL
PostgreSQL review by Momataj B.
Data Engineer
Enterprise
(1001-5000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"OLAP Database Management System"

What do you like best?

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.

What do you dislike?

Table Indexing, A found it bit complicated compared to Oracle and MS SQL

Recommendations to others considering the product

Yes, Mostly when people ask me the cheapest database system for small enterprises

What business problems are you solving with the product? What benefits have you realized?

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

Copy Review URL
PostgreSQL review by minh p.
Graduate Assistant
Research
Enterprise
(10,001+ employees)
Validated Reviewer
Review Source
Copy Review URL

"classic relational database"

What do you like best?

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.

What do you dislike?

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.

Recommendations to others considering the product

If you are looking for a free relational database, PostgreSQL is the way to go.

What business problems are you solving with the product? What benefits have you realized?

I use it for transportation data collection. It performance is very impressive, but it was a bit difficult to get used to at first.

Copy Review URL
PostgreSQL review by Joancel C.
Software Developer
Validated Reviewer
Review Source
Copy Review URL

" A great database manager without license costs."

What do you like best?

is a free software, available for the most used operating systems (Windows, macOS, Linux).

The graphical tool PgAdmin is easy and intuitive,i can manage, interact and manipulate different databases easily.

You can use it in read-only mode, with this option we can do maintenance or recovery without completely blocking the system.

What do you dislike?

It doesn't have official online support, although there is a lot of information in forums.

the syntax for some complex queries is a little complicated if you don't have knowledge in SQL language.

The installation and configuration of PostgreSQL is not so easy.

Recommendations to others considering the product

is an excellent database management software, with multiple functionalities and great handling of large volumes of data, and is free!!

What business problems are you solving with the product? What benefits have you realized?

High volume data management, creation of relational databases, maintenance of our clients' databases can be done without the need to block the system completely because several users can work with the database at the same time.

Copy Review URL
PostgreSQL review by Ramon B.
Senior Software Engineer, R&D
Broadcast Media
Enterprise
(1001-5000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Use as PostgreSQL not as MySQL; get to know it the philosophy behind it first!"

What do you like best?

Awesome built in data types, JSON with indexing to then work with triggers and locks!

Best of both NoSQL and SQL. The community is very active, as well as several commercial enterprise offerings.

What do you dislike?

I found there to be a steep initial learning curve to be able to build an application effectively to use all the built-in magic if the development team come from using MySQL or MSSQL. Once the brain wraps around some of the over loaded terminology

Recommendations to others considering the product

have your team take the time to read or watch an introduction to postgresql methodology, and well as a comparison against MySQL. The hour/hour and a half of time in the beginning can save hours/days of reworking to use the internal tools to scale properly.

What business problems are you solving with the product? What benefits have you realized?

We needed a database or databases that we could effectively have json stored, indexed, but allow for locked tables.

Copy Review URL
PostgreSQL review by Aby J.
Technical Lead
Information Technology and Services
Enterprise
(5001-10,000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"ITS FREE"

What do you like best?

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.

What do you dislike?

For some, not having support online or with an official help center can be a big disadvantage

What business problems are you solving with the product? What benefits have you realized?

We have a DMS product where we are using PostgreSQL as DB

Copy Review URL
PostgreSQL review by Jeffrey L.
CEO
Computer Software
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Open Source, Enterprise-ready Database"

What do you like best?

Rich support for SQL, real booleans, JSON in the schedule with query support, rich plugin library, solid performance and reliability.

What do you dislike?

Nothing, really. As a SQL RDMS PostgreSQL is quite good. I suppose that Oracle has better support for very large databases and clustering, but PostgreSQL is good enough for 1000's of concurrent connections on a 14Gbyte DB.

Recommendations to others considering the product

Do. No downside for us.

What business problems are you solving with the product? What benefits have you realized?

We've been able to deploy our ERP system, with over 500 tables and > 10Gbyte data bases, with no drama or license fees. We keep our server up to date and have not had a single failure due to a database issue in over 10 years of use over ~20 servers.

Copy Review URL
PostgreSQL review by Samarth J.
Samarth Jain
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

"A powerful open source software"

What do you like best?

1. Postgres is open source and free to use.

2. Postgres is Acid compliant and thus no data is lost.

3. Since PostgreSQL supports JSON field which was not supported by Mysql which we were using before, it has become very easy for us to work with JSON data sets. We can easily query JSON fields using Postgres query language.

4. Postgres also has a very strong community, thus it is very easy for new developers to adapt as they can easily find support online

What do you dislike?

I couldn't find anything to dislike in PostgreSQL till now as it gives me all the features that were required in our web application.

Recommendations to others considering the product

A very powerful Rdbms

What business problems are you solving with the product? What benefits have you realized?

1. Postgres has helped us to store and query JSON fields which was the biggest problem that we were facing with mysql.

Copy Review URL
PostgreSQL review by Melissa P.
Software Programmer
Banking
Validated Reviewer
Review Source
Copy Review URL

"PostgreSQL Review 2019"

What do you like best?

The fact it is an open source database which means its free to use.

Postgre has multiple updates a month, making it ever improving to be the best database software possible.

PostgreSQL's query optimizer is far superior to many others it makes retrieving information and the data you need almost instantaneous.

What do you dislike?

It's takes awhile to load due to using all allocated resources from your computer.

It's also causes computers to crash depending on the size of the database(mind you these are older computers/laptops using not the best of processors).

Recommendations to others considering the product

I would recommend

What business problems are you solving with the product? What benefits have you realized?

It allows us to grab out clients information in a matter of seconds.

It also allows us to update delete and insert new customers as the click of a mouse no query writing, saving time and giving us more time to devote to our clients.

Copy Review URL
PostgreSQL review by Matthew W.
Software Developer
Mid-Market
(51-200 employees)
Validated Reviewer
Review Source
Copy Review URL

"Great open source database"

What do you like best?

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.

What do you dislike?

Bad free tooling - pgAdmin4 is very awkward and slow to use.

Recommendations to others considering the product

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.

What business problems are you solving with the product? What benefits have you realized?

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.

Copy Review URL
PostgreSQL review by Andres P.
Small-Business
(2-10 employees)
Validated Reviewer
Review Source
Copy Review URL

"Motor de base de datos "

What do you like best?

Es el más avanzado en la actualidad y de código libre, lo que lo convierte en un sin fin de ventajas: Instalación ilimitada y gratuita para los diferentes SO, Unix, Linux y Windows de 32 y 64bits, es capaz de ajustarse al hardware (procesadores y ram disponible) para crear un rendimiento optimo.

Se puede administrar las bases de datos de forma gráfica, con la herramienta pgAdmin, lo que lo convierte en una forma mas fácil e intuitiva de gestionar una BD. Es potente estable y segura.

What do you dislike?

En bases de datos pequeñas es algo lenta en inserciones, mejora en este aspecto, cuanto mas grande es la base de datos. No posee un soporte oficial como tal. Tiene foros oficiales donde realizar las dudas o problemas que puedas tener.

Recommendations to others considering the product

Muy recomendable para la creación de bases de datos de forma segura, consistente y optimizada.

What business problems are you solving with the product? What benefits have you realized?

Para implementar el mantenimiento y la administración de las bases de datos de una manera segura y optimizada, lo que se traduce en accesos rápidos a consultas ya sea para los accesos a usuarios como el tratar información.

Copy Review URL
PostgreSQL review by Internal Consultant
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"Excellent DB with great features"

What do you like best?

This DB is open source and its really useful for any small or large scale projects.We are using this from last couple of years and it seems to be very useful product till now.Migration is really easy and SQL can be maintained in well manner.This DB helped us to overcome some performance issues and its really useful to reduce cost.

What do you dislike?

Some of the query tags is not supported in postgres and query language is difficult to understand for initial beginners. This can improved and documentation is hard to follow.

Recommendations to others considering the product

Strongly recommended product for large scale projects.

What business problems are you solving with the product? What benefits have you realized?

This DB helped our team to reduce maintenance support and it is easy to deploy in cloud. It also helps our teams to manage functions , views and other code in well defined format and performance was really good.

Copy Review URL
PostgreSQL review by Anastesia S.
Intern
Internet
Mid-Market
(51-200 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Experience of using Postgresql"

What do you like best?

PostgreSQL is user-friendly and GUI based database which is convenient for students to use. That's the best thing I like about it.

What do you dislike?

I don't have any dislikes about PostgreSQL, because it's in the best stage of performance.

Recommendations to others considering the product

For free and open sourced database software, pls use PostgreSQL because it is the best I can recommend for students.

What business problems are you solving with the product? What benefits have you realized?

I used Postgresql for my database project in which I saved all the data to be displayed on a PHP based website in PostgreSQL. I was easy to connect between the database and PHP and my project was successful.