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
10,052
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 339 total PostgreSQL reviews

PostgreSQL Reviews

Write a Review
Filter By
Connections
Show reviews that mention
1-50 of 339 total PostgreSQL reviews
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 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 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
Internet
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 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 Crowd 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 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 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 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.

Copy Review URL
PostgreSQL review by Joancel C.
Programador
Computer Software
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 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 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 Crowd 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.

Copy Review URL
PostgreSQL review by Samir M.
Enterprise
(5001-10,000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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

Copy Review URL
PostgreSQL review by Denish P.
Sr. Database Architect
Computer Software
Enterprise
(1001-5000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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

Copy Review URL
PostgreSQL review by Alex S.
Trans. Engineer 2: Survey Party Chief
Government Administration
Enterprise
(5001-10,000 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
PostgreSQL review by George G.
GIS/Web GIS Developer & Database Administrator
Civil Engineering
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
PostgreSQL review by Danylo H.
DevOps/AS3/C++ Developer
Entertainment
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"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

Copy Review URL
PostgreSQL review by Antonio R.
Analista de Gestion TIC
Telecommunications
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
PostgreSQL review by soma s.
Trainee
Computer Software
Validated Reviewer
Review Source
Copy Review URL

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

Copy Review URL
PostgreSQL review by Michal M.
Analityk Systemowy
Information Services
Small-Business
(11-50 employees)
Validated Reviewer
Review Source
Copy Review URL

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

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

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

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

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

Copy Review URL
PostgreSQL review by Arik B.
CEO & Co-Founder
Computer Software
Small-Business
(2-10 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
PostgreSQL review by Thanh P.
Software Engineer
Information Technology and Services
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
PostgreSQL review by Industry Analyst / Tech Writer in Computer Software
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

"PostGreSQL always works"

What do you like best?

PostGreSQL is fast with very slow latencies and is available on most of the clouds. I find it's SQL flavor, particularly amenable to my style of coding and easy to interface to natural query.

It is robust and always works, without crashing and easily distributable.

What do you dislike?

It is not yet extended to a NoSQL formulation and has limitations on blob objects.

Recommendations to others considering the product

I would definitely recommend PostGRE, to anyone needing an honest, high performing and reliable database. Botlibre, a company I work with uses postgre for all its bots and it is robust.

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

I have used postgre for medical records and for hosting compressed archives on my local server. I now use it as a plan B on AWS RDS.

Copy Review URL
PostgreSQL review by Hari A.
ECM Developer
Information Technology and Services
Enterprise
(10,001+ employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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

Copy Review URL
PostgreSQL review by Rickert M.
Software Developer
Information Technology and Services
Small-Business
(11-50 employees)
Validated Reviewer
Verified Current User
Review Source
Copy Review URL

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