G2 Crowd Acquires Siftery to Create a New Way to Buy and Manage Software Spend 🚀

PostgreSQL

4.4
(287 reviews)

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

Work for PostgreSQL?

Learning about PostgreSQL?

We can help you find the solution that fits you best.

PostgreSQL Reviews

Chat with a G2 Advisor
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 299 PostgreSQL reviews
LinkedIn Connections
PostgreSQL review by Miriam C.
Miriam C.
Validated Reviewer
Verified Current User
Review Source

"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

Sign in to G2 Crowd to see what your connections have to say about PostgreSQL
PostgreSQL review by Nairoby D.
Nairoby D.
Validated Reviewer
Verified Current User
Review Source

"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

What Relational Databases solution do you use?

Thanks for letting us know!
PostgreSQL review by Alex Z.
Alex Z.
Validated Reviewer
Verified Current User
Review Source

"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.

PostgreSQL review by Maria L.
Maria L.
Validated Reviewer
Verified Current User
Review Source

"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!

PostgreSQL review by ALEXANDER J.
ALEXANDER J.
Validated Reviewer
Verified Current User
Review Source

"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

PostgreSQL review by John R.
John R.
Validated Reviewer
Verified Current User
Review Source

"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.

PostgreSQL review by Ashish G.
Ashish G.
Validated Reviewer
Verified Current User
Review Source

"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.

PostgreSQL review by Ross M.
Ross M.
Validated Reviewer
Verified Current User
Review Source

"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.

PostgreSQL review by Jennifer G.
Jennifer G.
Validated Reviewer
Review Source

"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.

PostgreSQL review by Allison T.
Allison T.
Validated Reviewer
Verified Current User
Review Source

"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.

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

"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.

PostgreSQL review by George L.
George L.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd 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.

PostgreSQL review by Joancel C.
Joancel C.
Validated Reviewer
Review Source

" 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.

PostgreSQL review by Ramon B.
Ramon B.
Validated Reviewer
Verified Current User
Review Source

"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.

PostgreSQL review by Jeffrey L.
Jeffrey L.
Validated Reviewer
Verified Current User
Review Source

"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.

PostgreSQL review by Andres P.
Andres P.
Validated Reviewer
Review Source

"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.

PostgreSQL review by Samir M.
Samir M.
Validated Reviewer
Verified Current User
Review Source

"Powerful, Lightweight, and feature packed"

What do you like best?

Postgres is great for what it is. A well packed version of SQL that does everything you need your database to do.

What do you dislike?

Not much. If using it for standard data storage, Postgres has everything that you'll need. It's easily connectable to your codebase and the syntax is sql just with extra functions which make life easier.

Recommendations to others considering the product

Postgres is great for what it is, an easily implementable SQL database that plays nicely with other pieces of your system.

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

We're using Postgres as half of our back end data store. It's not a triple store, so we need a second database to accomplish that, but most of our system is run thru Postgres

PostgreSQL review by Denish P.
Denish P.
Validated Reviewer
Verified Current User
Review Source

"The best open source database product "

What do you like best?

Postgres can be used as multi-model database

- RDBMS

- Document store

- Search Engine

- Geo spatial database

- Key-value store

- JSONB

What do you dislike?

Lack of mature GUI tools

Built in sharding support

Recommendations to others considering the product

If you are using any closed source database, you should explore Postgres. I have converted a couple of Oracle and MongoDB applications and users love it!

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

Postgres should be your first choice for the data store for mission critical applications. You can use Postgres to store any data and you don't have to look for other database systems to store various kinds of data. Postgres FDW helps to connect to your existing databases i.e SQL server, Oracle, MySQL, Hadoop, Cassandra so Postgres should be hub for your all your data needs

PostgreSQL review by Alex S.
Alex S.
Validated Reviewer
Verified Current User
Review Source

"Excellent (and FREE!) Enterprise-Level DB."

What do you like best?

Several items: 1) it's FREE; 2) the ability to program functions and triggers in a variety of languages; 3) it is ACID-compliant which is extremely important to me.

What do you dislike?

Although it will run on Windows machines, it does seem (to me) that PostgreSQL is much more at home on a *nix computer. I had some strange access/permissions issues with some Windows directories/files whereas on Linux it was a non-issue. Your mileage may vary.

Recommendations to others considering the product

It is FREE!

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

The NPO that I am assisting currently uses MS Access and has been doing so since circa 1992, with a very large number of data entry additions which were prone to error. Furthermore, their membership has grown from approximately 300 folks in 1992 to about 4,000 in 2017. This has made their existing setup a nightmare. I volunteered to normalize their data and streamline their data entry procedures with feedback from their current data manager with respect to possible refinements on the data entry forms. Essentially, we are implementing PostgreSQL as a back-end and because of the wide variety of tools available and its versatility, it should provide a large degree of DB future-proofing for the NPO.

PostgreSQL review by George G.
George G.
Validated Reviewer
Review Source

"The go to Spatial Database"

What do you like best?

Excellent performance on handling and manipulating Spatial Data. Free and Open Source.

What do you dislike?

The lackluster and inconsistent front end management studios.

Recommendations to others considering the product

If you wish to hanlde spatial data in any way PostgreSQL is the way to go. Works well with everything, it is really easy to develop and maintain and has a ton of tools setup around performance (e.g. PgBouncer). The PostGIS spatial extension is the best perfomance-wise (e.g. GIST Indexing) and most complete toolkit in the market (especially true for 2D data). It doesn't have a great Management Studio but PgAdmin has come a long way and the extremely dilligent documentation makes up for that. It is free, it has a growing active community, it's the fastest growing Relational Database and the best one as of date for spatial data. PostgreSQL is the way to go.

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

Storing, handling and serving spatial data on my GIS & WebGIS applications.

PostgreSQL review by Danylo H.
Danylo H.
Validated Reviewer
Verified Current User
Review Source

"A mature database management system"

What do you like best?

- very stable

- featurerich configuration, supports reconfiguring on fly

- lots of plugins (extensions)

- improving with each release

- ACID

- self-heal on start

- popular

- allows continuous backup and replication

- fast queries

- extended SQL (PG/SQL)

- fast restart

- has alot of GUI tools, has tuner program

What do you dislike?

- had problems with WALs filling up disk space. After disk space is full, it is hard to start service - simply removing extra WAL files can make DB corrupt. So there should always be a method to quickly create free space on disk partition

- some configuration options can't be reconfigured on a fly (max_connections, listen_addresses)

- may be problematic to install on Windows (it involves creating dedicated user `postgres`, automatic, but our colleagues had problems with reinstalling)

- had problems with removing tablespaces

- had problems with table and index bloat (autovacuum not helping), requires periodic maintenance

-

Recommendations to others considering the product

- monitoring and alerting for disk size

- acompany with Barman backup manager

- use plugins/extensions (I recommend pg_repack plugin for database bloat redux)

- friend of mine recommends Amazon Data storage servers

- don't place indices on faulty disks - though they don't hold actual data, Postgres won't recreate them on device failure (I've placed indicies on a separate tablespace in instance store of EC2 server. After server reboot it was hard to start postgres)

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

- managing large database for game data (using Hibernate ORM).

- data reliability

PostgreSQL review by Antonio R.
Antonio R.
Validated Reviewer
Verified Current User
Review Source

"A performant open source alternative to Oracle and SQL Server"

What do you like best?

It is open source, it means we can look at the code and help to improve the product and troubleshoot bugs

What do you dislike?

it is very strict on its SQL language, Mysql lets you slack a bit, postgresql does not.

Recommendations to others considering the product

Read a lot about SQL, it uses strict language so you cant get away with things like In MYSQL. I recommend Heidisql to use with Postgresql, it is a great front end.

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

Data storage, We migrated an entire database from aging Oracle and SQL server to postgresql and we are very happy with it. We currently have many databases with it and we love it. Everything we think of a new product we choose Postgresql without a doubt.

PostgreSQL review by soma s.
soma s.
Validated Reviewer
Review Source

"Best Database Server"

What do you like best?

The best thing about this database is, it is open source. We can customize it according to our requirements. Postgres is portable with all the platforms and programming languages. It does not requires more command line configurations. It is most reliable and stable database.

What do you dislike?

There are some problems with postgres when we compared it to the mysql database. Low budget hosting sites supports mysql than postgres mostly. In terms of speed, mysql needs less work than the postgres. Also more open sources support mysql but not postgres. These are some of the problems with postgres.

Recommendations to others considering the product

The postgres is the best database server, which is an open source. It is more profitable for the business models. There are high sql standards. It has more features than mysql database.It is considered one of the most reliable databases on data reliability and correctness. It can also helps in solving the database related problems. It can be installed and run on many types of platforms like Windows, Linux and Unix. There are many GUI tools of high quality available for this postgre sql from both the developers and the commercial providers.It provides the better support than the proprietary vendors. It gives personalized view. It is easily configurable, also it has subquery support.

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

Postgres is the good for the embedded applications.It's reliability is high. I found that it is more flexibility for concept research and deployments without any licenses which costs more.

PostgreSQL review by Michal M.
Michal M.
Validated Reviewer
Review Source

"Free and really good database not only for scientists but also for business applications"

What do you like best?

This is free

big community

a lot of extensions

the ability to use Python

it just works

What do you dislike?

Limiting the number of columns in the table. However, other databases have similar limitations.

Older versions had very nice tools, in particular the SQL client. In newer versions, it has been replaced by a nicer graphical solution that is slow and sometimes slightly annoying.

Recommendations to others considering the product

A complete tool, free and easy to integrate with other software. For this you can create your own functions in PL-SQL and Python. Accessibility, stability, sense of security - these are the main features that caused me and the organizations for which I work to reach for this product.

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

I used PostgreSQL in Data Mining and BI projects. I used it as background database for solutions based on JIRA. Moreover I used PostgreSQL for specialized engines that are working in on-line class systems.

PostgreSQL review by User in Computer Software
User in Computer Software
Validated Reviewer
Verified Current User
Review Source

"Excellent open source object-relational database management system "

What do you like best?

Once you've used it for awhile, it's natural. It's easy to see all the data you need, doesn't overcomplicate things either. Wildcard Search queries are simple and I love the number of extensions there are available for developers to take advantage of.

I enjoy using the PostgreSQL app on Mac OSX. I always know when I have it running because I can see the icon on the top of my Desktop.

What do you dislike?

Installation can be tricky your first time around. I just helped a new developer set it up and it only took a few minutes of looking at the docs to give myself a reminder. The new developer was overwhelmed by the PostgreSQL documentation that he had kinda given up. After that, you'll quickly get the hang of it. PostgreSQL query syntax for more complex queries can be difficult and take a moment to learn but once you've gotten the hang of them, you'll be fine.

Recommendations to others considering the product

Although the documentation is a bit overwhelming at first glance, take some time and read through it. It'll help you in the long run and it's really not the scary.

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

We use as our main database for 5 different projects. We've never had any issues and we like the flexibility it offers us.

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

"Complete Open Source DBMS"

What do you like best?

Open Source, so no licenses to pay.

Fully compliant with SQL (including inheritance, for example) and ACID.

Good performance and stability on large databases.

Extensible.

With the extension PostGIS, it is one of the most powerful DBMS for GIS, among both commercial and open source alternatives.

What do you dislike?

Not as simple to master as other alternatives such as MySQL (of course, it has more features).

No native clustering (there are some extensions trying to solve this).

Some GUI tools are not reliable, but you can always go back to command line to do whatever you need.

Recommendations to others considering the product

If you need a relational DBMS, go with PostgreSQL. If you need a relational DBMS with support for geographic data or json data with complex queries, definitely go with PostgreSQL.

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

DBMS for Information Systems, and Geographic Information Systems.

PostgreSQL review by Arik B.
Arik B.
Validated Reviewer
Verified Current User
Review Source

"Excelent and flexible open source SQL database"

What do you like best?

PostgreSQL is a mature database server with large user's community and continue development. Installation is very simple and also integration with multiple development environment is supported we user C++ library, PHP and Java integration

What do you dislike?

would like better admin package, managing changes as versions is bit complex

Recommendations to others considering the product

This is an open source SQL database that include many of the much more expensive solutions and it is open source with wide community of contributers

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

We use PostgreSQL as our system DB and benefit from wide range of features and extensions. We need to access the database from several environment and this is very simple and supported with large number of libraries and connections.

PostgreSQL review by Thanh P.
Thanh P.
Validated Reviewer
Verified Current User
Review Source

"Object-relational database management system, free and open source"

What do you like best?

A simple database server: store and query data

Multiversion concurrency control (MVCC) per "transaction"

Support JSON data type from version 9.2

Developer can define their objects, inherit from default system defined.

Has full text search and asynchronous notifications

What do you dislike?

Performance and slow on older version. Need update at least 9.4 for better performance

Recommendations to others considering the product

PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.

Support full text search and regular expression

JSON and BJSON data type for flexible data

Snapshot a version of database whenever transaction trigger.

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

Full text search and regular expression

JSON and BJSON data type for flexible data

Snapshot a version of database whenever transaction trigger.

PostgreSQL review by Hari A.
Hari A.
Validated Reviewer
Verified Current User
Review Source

"Postgres is the most effective Open source Database"

What do you like best?

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.

What do you dislike?

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

Recommendations to others considering the product

Postgres is the most effective Open source Database

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

We are using Postgres as a database choice for a custom product development. This database will contain a large amount of data. As an open source, it provides enterprise level RDBMS functionalities.

PostgreSQL review by Rickert M.
Rickert M.
Validated Reviewer
Verified Current User
Review Source

"Awesome open source database"

What do you like best?

I love the large feature set built into Postgres. In particular, range queries are a godsend for time-based applications. Full-text search functionality means I don't have to bother with an elastic search installation. There is also much additional functionality that can be gained via extensions such as postgis.

What do you dislike?

Replication can be a pain to configure compared to other DBs. Hosted solutions like RDS takes care of this though.

Recommendations to others considering the product

If regulations require you to encrypt data at rest, Postgres might be problematic. Postgres does not support database level encryption out of the box. Encryption at rest could possibly be achieved via full disk encryption. You can get this on medium sized RDS instances on Amazon. Otherwise, there is an extension for row level encryption.

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

I used Postgres for a scheduling web app. Because range queries are built in, it's a lot less effort to query compared to MySQL. It's also more efficient. I also use the full-text search functionality for our built-in knowledge base, as well as the trgm extension to order search results.

PostgreSQL review by ERICK W.
ERICK W.
Validated Reviewer
Verified Current User
Review Source

"PostgreSQL is very Effective in data strorage and retrival of information"

What do you like best?

The simplicity in the software, it detects IP addresses automatically without manual configurations which can be hectic to the technician.

What do you dislike?

Sometimes it gets disconnected to the database and one has to configure it a fresh in order to collect information from the database.

Recommendations to others considering the product

PostgreSQL is very user friendly as even learners can use with with no experience at all i would strongly recommend it to Others

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

Using it to to store data of a management software that we design to our clients

PostgreSQL review by Eric M.
Eric M.
Validated Reviewer
Review Source

"Scalable, flexible databases for any use"

What do you like best?

Data of almost any format fits well in Postgres. You can use one database instance to house multiple databases, but also host multiple discrete schemas in each database (each with its own set of tables). The scope with which you can shape and manage data structures is remarkable!

What do you dislike?

Some key features from other database systems (like UUIDs for identifiers) are not included by default and require installing separate extensions (pgcrypto for UUIDs). Forgetting to install an extension before importing data can lead to data loss and errors all over the place!

Recommendations to others considering the product

Keep your data structures clean and ensure your relations don't blend across schemas too often. While cross-schema queries are possible, building your application to use them will limit you in terms of scalability should you ever wish to spread your database across multiple servers/instances.

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

We use Postgres to host our primary application database. It's given us massive scalability by allowing us to tie multiple microservices together into one application.

PostgreSQL review by Damon B.
Damon B.
Validated Reviewer
Verified Current User
Review Source

"A solid database with a long track record"

What do you like best?

PostgreSQL has a long history as a go-to open source database with a full set of features, an active development and user community, and an accessible and robust toolset. Users of PostgreSQL and its derivatives (Vertica, RedShift) will feel equally at home. The toolset has remained largely compatible since I started using it around 1999.

What do you dislike?

PostgreSQL isn't always the first to adopt new features, or to adapt to new changes in the computing world. This is two-way street: one way it means the platform is stable and its constraints are reasonably well-known, in the other direction it means that PostgreSQL misses out on performance opportunities around multi-core query execution, optimization for the shift of the CPU/RAM/SSD/disk balance, and clustering/failover.

Recommendations to others considering the product

Compare PostgreSQL to other platforms like MySQL, RedShift, Vertica. Decide on whether you want your database to do much of the optimization work for you (Vertica) or need to scale elastically (RedShift). Either way, PostgreSQL is a solid and free starting point that remains largely compatible with its cousins.

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

I have used PostgreSQL in a number of scenarios, including as a backend for MediaWiki, a hand-coded website, a SQL application ported from MySQL, a SQL app ported to Oracle, a Reporting database ported from Oracle, and some data warehouse/analytic tasks.

PostgreSQL performed admirably in each, with the caveat that the more one deviated from the traditional RDBMS with many small transactions, the more work was placed on the developer to optimize their data structures or query strategy to wring the most from the database.

PostgreSQL review by Carlos Alberto P.
Carlos Alberto P.
Validated Reviewer
Review Source

"The most efficient relational database manager"

What do you like best?

Postgresql is by far the most efficient database manager, this is based on the selection algorithm used in order to determine the fastest route and with the least use of equipment resources, in addition to the effectiveness of the results shown.

What do you dislike?

There are few things to say negative postgresql however its response time to very simple queries is not as efficient as others in its style, it should be used when the power of its core is required for simple consultations is a waste of resources

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

In our experience we had to make queries that involved the union of multiple tables as well as to use the inheritance one of the characteristics of the database manager to show important information of the company

PostgreSQL review by Chethan M.
Chethan M.
Validated Reviewer
Review Source

"Review on Postgres"

What do you like best?

PostgreSQL is the SQL DB and been gaining popularity in the recent years. Today, After MySQL acquisition the community and many organisations do not consider MySQL though its popular and one of best. The next best is PostgreSQL also because of its good performance results. PostgreSQL is implements SQL standards very well and it supports advanced SQL stuff. As PostgreSQL is Open source, its been preferred by larger community and even few ECM tools Like Nuxeo ECM recommends best results.

What do you dislike?

PostgreSQL is not very easy to understand or use unlike MySQL, it requires a little learning curve for new folks. The initial installation also requires some background and will take time for first few installations or integrations with other tools.

Recommendations to others considering the product

Yes

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

PostgreSQL was considered mainly because it is open source. Also, its been recommended by experts due to its good results on performance front. PostgreSQL has support for all OS versions like windows, linux and others.

PostgreSQL review by Tomas D.
Tomas D.
Validated Reviewer
Verified Current User
Review Source

"great database with easy and robust backup and recovery"

What do you like best?

The way how easy it is to customize the database to suit your needs.

One can use DB Protection for PostgreSQL using IBM Spectrum Protect to have a very efficient and fast backup as it o my backup changes in the database.

Https://ligtas.org

ANSI SQL complaint.

Easy to migrate

What do you dislike?

The way how the transaction logs are handled can be problematic especially during a recovery if you perform that multiple times

Recommendations to others considering the product

consider use a space efficient backup like "DB Protection"

https://ligtas.org

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

We can scale from very small to large enterprise

PostgreSQL review by User
User
Validated Reviewer
Review Source

"Psql is more user-friendly "

What do you like best?

Compared to Oracle, Postrges seems to be more forgiving to first-time sql users. The statements allowed by Postgres are more logical and structured which really makes sense to most sql users when they first get started.

What do you dislike?

Postgres has a lot of functions and packages that you can add to extend the core functionality, but those addons are usually hyped by web forms. It's usually not something that a non- db admin can do. Materialized views and time functions that are really helpful for marketing or data transference require someone who knows what they're doing, but those online articles don't make that clear. You'll really need to partner with a pro to make sure you get the most performant system while also adding any packages or functions.

Recommendations to others considering the product

Really read thru the addons because it can do a lot, but you'll need some help.

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

The biggest benefit is the performance and ease of use to get off the ground.

PostgreSQL review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Great Alternative to traditional Commercial Databases"

What do you like best?

PostgreSQL has grown in both popularity and features. It is now on par with many of the commercial database servers. Because of its popularity, if you need commercial support, you can find it. If you can go it all alone, you can save you (and your company money). It is available for many OSes to suite your needs

What do you dislike?

Windows support has lagged behind Linux/Unix for a number of years. Some of the tooling feels weird when you run it on Windows. I think if they want better adoption on Windows, they should create native (non-cli) tools.

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

We are replacing expensive commercial database servers with PostgreSQL. This has helped us avoid the cost of expensive database serves when an Open Source solution would do just fine.

PostgreSQL review by Lucian M.
Lucian M.
Validated Reviewer
Verified Current User
Review Source

"Postgres - a great database for Canvas LMS"

What do you like best?

Scalable, stable, reliable database app, easy to use. It provides a strong platform to work with databases for different applications, including the LMS (learning management systems). PostgreSQL provides stability and performance for large projects also.

What do you dislike?

Nothing major, needs good programming for efficiency. You can backup the database using the dump command, then you can restore different constructs and sections.

Recommendations to others considering the product

It is a stable database for different application projects.

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

Canvas LMS, Websites, Financial apps

PostgreSQL review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"PostgreSQL is an excellent alternative"

What do you like best?

Features, Open-Source, Extensibility, Programing Languages support, easy to install and maintain.

We are switching from Oracle and SQL Server to PostgreSQL for different use cases like Web development using .NET, Java and PHP, also we switch our Control-M application from Oracle to PostgreSQL too with and excelent result.

The short experience until now is awsome because the developers and DBAs dont suffered the change and the database performance for our use cases is really good.

What do you dislike?

I would like more features for auditing because the current solutions for audit actions and events doesn't meet our requirements.

Recommendations to others considering the product

Yes, PostgreSQL is robust, easy to use and maintain and with an excellent set of features that compete directly with the biggest players like Oracle and SQL Server.

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

Application development in-house is now build using PostgreSQL, before we used Oracle and SQL Server.

License cost reduction without loosing professional support was the main benefit.

PostgreSQL review by User
User
Validated Reviewer
Review Source

"Imprescindible!"

What do you like best?

- Interfaz gráfica muy fácil de usar para llevar a cabo tareas de todo tipo.

- Permite unir tablas.

- Mejor rendimiento cuanto mayor es la BD. Se ajusta al hardware disponible.

- Libre, Opensource. Multiplataforma.

- Gran comunidad de desarrolladores. Brindan un excelente soporte técnico.

What do you dislike?

- No aconsejable para BD pequeñas, aunque tb tienen un rendimiento aceptable.

- La configuración lleva su tiempo. Menos intuitiva que MySQL.

Recommendations to others considering the product

Excelentes herramientas para gestionar una BD y poder sacarle el máximo partido de una sencilla desde su interfaz.

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

El poder almacenar y administrar una BD grande de manera consistente y eficaz, con grandes ventajas de rendimiento, lo que asegura un acceso a la información óptima.

PostgreSQL review by Judy (Morgan) L.
Judy (Morgan) L.
Validated Reviewer
Verified Current User
Review Source

"My favorite database ever!"

What do you like best?

That's hard - I love how quickly it installs, I love that we get every feature we could hope for and more, it's fast, it's smart, the documentation is easily accessible and understandable without a "certification", when you get stuck on a problem, people that work on the product answer your questions on the forum!!

What do you dislike?

Never sure how to pronounce the name!!!!

Recommendations to others considering the product

Postrgresql is really everything you want from Oracle, but it's free AND easier to use.

New features come out regularly and if there are issues, they are fixed quickly instead of sometime years from now.

The documentation is really thorough and easy to use - for all of the features. There are add-ons that are well supported and that add even more amazing functionality.

I don't really know why you would choose any other database.

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

We moved off of Oracle and life has been grand:

1. saving $$$$, for our company and our customers

2. our installs now take minutes instead of hours

3. we can use all of the features and not worry about an audit discovering we're using something we haven't paid for

4. the database is fast

PostgreSQL review by User
User
Validated Reviewer
Review Source

"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

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.

PostgreSQL review by Consultant
Consultant
Validated Reviewer
Review Source

"built-n procedural extensions and lightweight posgres"

What do you like best?

postgres is lightweight and easy to install/reinstall development version in local system,

optimization techniques are different using Query planner/Optimizer and analyze, explain.

What do you dislike?

Difficult to maintain Transaction control in stored procedures like start/begin and end transaction and commit in between execution. for Large data volume like 20-50~ million, giving performance issue even required a lot of table partition/correctly setting up indexes and was required more query optimization

Recommendations to others considering the product

If you want to know cost of each query then it provide great Query planner/Optimizer using analyze, explain. Configuration management can very easily done using a few files like pg_hba.conf and postgresql.conf but it is very tricky based on your data volume.Like cache memory ,configuring (auto)vacuum

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

Business preferred to use Postgres because it support major cloud technology. PL/SQL is much more mature technology than any of the PostgreSQL procedural extensions. JSON support allows for Postgres to transfer data as raw text and without attributes and markup overhead which was great benefit for resulting to display at UI

PostgreSQL review by Ian H.
Ian H.
Validated Reviewer
Verified Current User
Review Source

"PostgreSQL is the best database system I've used"

What do you like best?

Coming from a MySQL background, I love the variety of data types in Postgres: JSON, arrays, etc, all fill a need that MySQL didn't. I especially like how easy it is to manipulate dates, something that has sped up development a ton in terms of automated testing. The ability to enforce checks on insertion is very helpful, too. I've used NoSQL before, and I much prefer the rigidity of an RDBMS. All too often I've had to deal with corrupt data because of the temptation to fool around directly in the database rather than using the application layer.

What do you dislike?

Probably the most difficult thing about Postgres is its permissions model. It's not very intuitive, in my opinion, and I think those issues need to be resolved before it can gain the sort of traction MySQL has. Right now it's just not easy for a beginner to get set up and secure.

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

We've mainly used Postgres as an inventory system; nothing too fancy, but Postgres has made it much more enjoyable.

PostgreSQL review by Gurmeet Singh K.
Gurmeet Singh K.
Validated Reviewer
Verified Current User
Review Source

"One of the best open source databases."

What do you like best?

Nice clean user interface.

Its one of the best open source database.

Administrator control and configurations are good.

Ease of creating schema and tables is also good.

What do you dislike?

Lack of features compared to Microsoft sql server and oracle database.

Stability is very important feature to have in any database. That needs improvement.

Recommendations to others considering the product

If you are looking for open source database for your project. Go for PostgreSQL

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

Trying to use it with one of the new web application.

PostgreSQL review by Niels M.
Niels M.
Validated Reviewer
Review Source

"PostgreSQL - The perfect database for our needs"

What do you like best?

One of the best feature of it is it's array datataype. We needed to define a table with a huge amount of floating data fields/columns. The normal column amount was restricted to 1300 fields. For our use case we needed more and dynamically. Postgresql offered us the array datatype double which doesn't restrict us in the amount of values and can easily be accessed by it's index.

What do you dislike?

The inhouse db managment tool is a bit slow and buggy. A shame they don't deliver one useful one with it.

Recommendations to others considering the product

The price and features are unbeatable.

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

The dynamic calculation of business benchmarks can be achieved comfortable.

PostgreSQL review by Manjushri S.
Manjushri S.
Validated Reviewer
Review Source

"PostgreSQL database review"

What do you like best?

PostgreSQL is an open source database and in that way has a great advantage over other licensed databases like Oracle. Currently, we have been trying to migrate all legacy applications from Oracle to postGRESQL.PostgreSQL database works very well with hibernate JPA and we have been using it extensive along with the Spring framework.

What do you dislike?

There is no good client to use the database been using pg admin and I am not really a big fan of the interface provided by pgadmin, we cannot "pin" any query results unlike the SQL developer.

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

Have been using postgreSQL for couple of applications on the financial domain. Works great with simple applications with relatively less complex database design. Have hosted postGRESQL on AWS and used cross region replication, encryption.

PostgreSQL review by Marco P.
Marco P.
Validated Reviewer
Verified Current User
Review Source

"Performant, reliable and scalable"

What do you like best?

We use PostgreSQL in production since 8 years now, in a multi-nodes HA setup based on the built-in streaming replication. PostgreSQL is a great database, offering high performances and allowing to easily scale read-replicas with the built-in streaming replication.

What do you dislike?

The major issue with PostgreSQL is the complexity of doing a major version upgrade with nearly zero downtime. Starting from PostgreSQL 10 this issue has been largely reduce thanks to the logical replication.

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

We use PostgreSQL as main data storage for our online service.

PostgreSQL review by User
User
Validated Reviewer
Review Source

"Awesome Tool!"

What do you like best?

The best things I like about PostgreSQL is all the functions and tools it provides to perform fast querying and calculations. Also I actually love how it integrates with other tools such as Postgis, that we used it to draw polygons and check if certain coordinates where inside these or not. It worked incredibly fast. Finally I love psql, is my goto tool, really fast to open a new connection to a database and perform queries right away over this one. I also love that the tool is open source, I'm a big supporter of that

What do you dislike?

I don't dislike much about it, just that sometimes the querying is kind of slow when you are trying to get loads of data out of the db.

Recommendations to others considering the product

It is a tool that has a huge community around it that it is always there to help through the different communication channels you have. Moreover it is really easy to set it up and also not difficult to learn. So developers will be able to reach a high level of understanding in little to no time.

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

We are storing large amount of data in our db's to later perform analytics with it. The main benefits we've realize while using it is the large amount of functions and transformation we can perform while querying. It actually makes our life easier.

Kate from G2 Crowd

Learning about PostgreSQL?

I can help.
* We monitor all PostgreSQL reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.