G2 Crowd builds the world's largest business commerce platform fueled by $100M in funding 🚀

PostgreSQL

4.4
(276)

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 278 PostgreSQL reviews
LinkedIn Connections
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!

Sign in to G2 Crowd to see what your connections have to say about PostgreSQL
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

What Relational Databases solution do you use?

Thanks for letting us know!
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 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 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 Denishh P.
Denishh 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 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 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 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 Rodrigo P.
Rodrigo P.
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 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.

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

"My experiences with PostgreSQL"

What do you like best?

PostgreSQl is a great piece of open source software that handles the storing, processing and extraction of large spatial and non -spatial datasets incredibly well. I wouldn't hesitate in recommending this piece of software. I particularly like, and regularly use, the PostGIS extension for spatial querying and representation in other software e.g. QGIS. Its the interactivity with other software that makes PostgreSQL stand out. Worth a mention is the backup facility of pg_dump - a quick and simple method to create those vital backups.

What do you dislike?

Not much. I prefer using the GUI pgAdmin to navigate through PostgreSQL but that is not the fault of the software - merely my attachments to GUI's.

Recommendations to others considering the product

Go for it - its easy to setup and start testing with data. Add the PostGIS extension to maximise your geospatial data.

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

We are building a marketplace that is storing and serving up geospatial data on our front end. This was initially done using MongoDB but its ha snow become apparent that Mongo has some issues with querying geospatial data on a large scale. Given the expertise PostgreSQL has with this - we are now starting to shift all our data holdings over so we can handle geospatial data with ease.

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

"PostgreSQL: A great opensource database"

What do you like best?

PostgreSQl is a wonderful piece of software that allows the easy storage, transfer and querying on spatial and non-spatial data. I particularly like, and extensively use, the PostGIS extension for spatial querying and representation with other software, notably QGIS. Its this seamless integration with other open source software that really makes PostgreSQL stand out. Finally, the backup methods through pg_dump are simple to use and ensure you can always take a backup before any major changes.

What do you dislike?

I sometimes find it tricky to use from the command line and prefer using the pgAdmin III GUI for use. This is no fault of PostgreSQL though, merely my own shortcomings with operating databases from the command line.

Recommendations to others considering the product

Go for it - you wont be let down! Its simple to set up, easy to administrate and provides a stable environment for storing and querying large amounts of spatial data

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

We are generating a data marketplace and looking for somewhere to store spatial data and querying this on the fly so we can send back the results to our users. Upon initially using MongoDB it was clear that this solution lacked the geospatial strength we needed so quickly switched to PostGreSQL.

PostgreSQL review by McCourt C.
McCourt C.
Validated Reviewer
Verified Current User
Review Source

"A great Alternative to MS Sql"

What do you like best?

Postgresql is a very lightweight cross platform solution.

This makes it a perfect alternative to some of the larger commercial solutions out there right now.

The community behind it is also first class, loads of support is available via the forums when needed.

My favorite feature however is replication.

Although you will be editing text based config files to get set up, you can literally have one database replicating to another in half an hour(for basic configs).

I know this is possible with other commercial tools, but Postgres is free to use.

I use it for all of my personal projects when possible.

What do you dislike?

Its a little tricky to configure for those who are used to graphical interfaces like in MS SQL server.

Recommendations to others considering the product

Join the communities and read as much as you can about the config.

Dip your toe in and you will be surprised what Postgresql can do and how fast it can be.

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

Really again the replication has allowed us as an ISV to offer enterprise level service to clients whom may not otherwise have been able to afford to do it with commercial offerings.

PostgreSQL review by chedi t.
chedi t.
Validated Reviewer
Verified Current User
Review Source

"postgresql review"

What do you like best?

I've worked with many relationnal databases over the years and mysql was my goto solution for web development for a while. Until I was forced to use postgis extension of postgresql for a geospatial data storage project. Since then, postgresql became my defacto databse.

Very reliable, great performance and advanced features make postgresql a solution for midium to large deployment. Advanced data types, especially spatial in my case, rich feature sets and the possibility to write stored procedures in python are a deal sealer.

It's also opensource, with a good support and a welcoming community.

What do you dislike?

Nothing really, but there is some known gotcha and behaviors that can be confusing for new users. Reading the documentation is a must even if you have a background with other RDBMS.

Tunning the performance of the system is up to the database administrator and the number of options can be overwhelming sometime.

Recommendations to others considering the product

Postgresql is a very advanced database system with an emphasis on extensibility and customization. The documentation is quiet large and the options multiple and you will likely take you a long time to figure it all out but it's all worth it in the end.

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

Postgresql is really the most advanced and reliable database that we have used yet. We are using it in conjunction with Django web framework and a geospatial systems using the postgis extension.

The cost/quality ration is just unparalleled with any other solution.

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

"ACID transcations for the Win"

What do you like best?

ACID is one of the main features that you will need when programming mission critical applications and postgres has it inbuilt. We can also change the transaction isolation level which is very needed for performance. Consistency is also very good you will never have data corrupution or data lost. JSON support in the latest version has made it very easy for us now since we don't need to migrate the schema always like before.

What do you dislike?

Scalability and High availability are major issues in sql databases and in postgres its even harder since there no proper tool to do it. It locks the row on serializale transactions which is really a problem in certain cases. Many databases have other means to solve this.

Recommendations to others considering the product

Yes. If you really don't want uncertainities in your data and want ease of coding then postgres is one of the best. Its also open source and the development work on it is really good.

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

We Are solving Customer Engagement and Employee Engament. We Have Created a Cloud based gamification system where users can build and wire up their business rules and logic and then integrate it into their systems. We don't have any random errors anymore and programming has become easier since we don't need to handle some edge cases anymore.

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

"Simple to use, Easy SQL management tool."

What do you like best?

Coming from a MySQL background it is very similar and allows me to manage my data in any way I see fit.

What do you dislike?

The PostgreSQL management tools out there today aren't the best. It's hard to find a GUI tool that allows me to manage my data simply.

Recommendations to others considering the product

If you are used to MySQL and are unable to use that for your database management needs, PostgreSQL is a great alternative. With all the other tools that are being offered right now, AWS and GAE, this is still light weight and open source.

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

I have a lot of data that I need to keep historical track of and PostgreSQL keeps that all in one place that allows me to keep track of it.

PostgreSQL review by Paul Giancarlo D.
Paul Giancarlo D.
Validated Reviewer
Review Source

"Psql Rules"

What do you like best?

I like postgres, i used for many implementations and works like a charm. You need few minutes for install. So you start work really fast with postgres. Console likes me too, have all the things you need.

What do you dislike?

I think nothing. In my experience you cant used for multiplatform i mean when you use with windows and Linux have to lead with Upper/Less table names.

Recommendations to others considering the product

Just Use. Its great.

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

i build some desktop applications. Fast integration and easy to migrate. I user for OpenERP migration and the most simple was run a command to fix the index for specific tables.

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

"Fast, reliable and scalable open source database"

What do you like best?

I like PostgreSQL because it's a robust alternative to commercial databases. It stands very well against other open source competitors, like the more popular MySQL. It's fast and reliable, managing inserts and updates of tens of thousands of rows flawlesly.

Besides that, it's easy to install and to manage, and it has some handy non-standard SQL commands. Documentation in the official website covers most of the common and advanced tasks with a lot of examples of querys.

What do you dislike?

Managing everything from the command line can be a little bit cumbersome. There are a lot of third party graphical interfaces to access the databases from the desktop (pgAdmin) or via browser (phpPgAdmin) but you have to install them and learn to use then on your own.

The same with reporting tools, there are a lot of nice ones but you have to search and try what is the best for you.

Recommendations to others considering the product

If you are searching for an open source relational database, with no licensing issues, full of features, secure and reliable, choose PostgreSQL.

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

I have used PostgreSQL for ten years now on a very active client-server configuration without any issue. We have experienced power losses and hadware failures but there has never been a single row of data corrupted. Updating to a new version was achieved with a simple export-import command.

Being able to create, alter or delete tables while the company is live in full production is a great feature. Our main data managing app has grow over the years and the original design has changed a lot but PostgreSQL has always cover our needs.

And as always in open source, at zero costs.

PostgreSQL review by Israel F.
Israel F.
Validated Reviewer
Verified Current User
Review Source

"The only RDBMS you will need"

What do you like best?

Highly extensible, several PL implementations, easy to write stored procedures if you already know python, perl or C because it implements them as procedural languages, tons of addons to extend its functionality, functional indexes to improve performance if you need to search by computed values and it makes it really easy to perform queries based on data stored in JSON fields and it supports master-slave replication natively.

It has a lot of tools to check the performance of your queries, the consistency and the health of your database and to collect garbage and clean up your database (EXPLAIN and Vacuum)

If you want a NoSQL data sture, Postgres also have you covered, you can try HStore.

What do you dislike?

It is too large and has thousands of features, so documentation sometimes is outdated and you can get lost very easily if you don't know exactly what you're looking for

Recommendations to others considering the product

Don't use it as a simple data store, that way you won't see the performance improvements

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

Data storage and retrieval with great performance and a lot of tuning options if you model your data correctly.

We could also migrate some logic to the DBMS layer to optimize our application performance.

PostgreSQL review by Josh V.
Josh V.
Validated Reviewer
Review Source

"Simply the best"

What do you like best?

I am a huge fan of the robust data types and procedural capabilities in PostgreSQL. I used MySQL for many years simply because the setup process seemed easier than what PostgreSQL required. When PostgreSQL announced support for the JSON data type, I decided to bite the bullet and give PostgreSQL a more serious look. I've not touched MySQL since then.

In the years since JSON support landed in PostgreSQL, I've learned to appreciate the various options for implementing your own functionality using plpgsql and python. I've also experimented with various Foreign Data Wrappers (FDW) to expose data from other sources (filesystem, mysql, redis, other PostgreSQL instances, etc) as tables in PostgreSQL. I'm constantly impressed.

What do you dislike?

In today's day and age, redundancy and clustering are very important. Plenty of other databases out there offer relatively simple options for setting up replication, sharding, and automated failover. PostgreSQL doesn't have much built in to address these concerns. There are myriad projects that facilitate these important features, but none of them feel great to me. Perhaps I just need more time to invest in them.

Recommendations to others considering the product

Compared to MySQL, PostgreSQL is hands down the better option. More correct behavior when inserting and updating rows. Robust data type options. Long history of being fully open source. Vibrant community.

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

I've used PostgreSQL for a wide variety of tasks from simple structured data storage to data warehousing to powerful analytics. In every case, I've found PostgreSQL more than capable and quite pleasurable to use for the task at hand.

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

"Awesome database with lots of great new features always coming"

What do you like best?

I wouldn't consider myself to be a database expert, but from basic usage via Rails apps, I've been very happy with the features I have used. Full text search, custom data types (json, arrays, etc), performance optimizations, extensions (like Postgis for spatial data), sharding and partitioning support... I've mostly interacted with Postgres via ActiveRecord though. Been very happy with it in multiple production instances across apps of all sizes (from tens of users to tens of millions).

What do you dislike?

When I first started using Postgres it wasn't well known so it was hard to find support for more advanced features... For instance RDS Postgres didn't support replication for a while... That's all been solved now though. I've been very happy with it in the last few years.

Recommendations to others considering the product

If you want an awesome RDBS and have experience with SQL, I highly recommend checking out Postgres. The barrier to switching is very low if you're coming from any SQL database, so you might as well give it a shot.

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

We use Postgres as our main database at my current company and have used it at my previous few as well. It's a great RDBS with a lot of support and some really cool features, and new ones being added all the time.

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

"Best SQL database, and open source!"

What do you like best?

Includes all the usual SQL features, and also has support for lots more:

* Full text search: without needing to configure and maintain standalone services like ElasticSearch, PostgreSQL lets you add full text search to your application, with support for dictionaries, stemming, trigram search, and much more: http://www.postgresql.org/docs/8.3/static/textsearch.html

* JSON columns: can act as a non-relational database with JSON support like MongoDB, which lets you do all that the NoSQL databases can, while also having full relational support as always.

* Can work with geographic objects with the PostGIS plugin, to build searchable and fully detailed maps for POIs and such.

* Has hooks for very detailed analytics with the pg_stat_statements extension.

What do you dislike?

Since it is more strict that other SQL databases, it is hard to make some complex queries which involve joins with groups.

Support for PostgreSQL is pretty high in servers, but operating systems do not support it by default, and so you always need to install it.

I still haven't found a nice GUI to do light support tasks. There's PGCommander for Mac, but it lacks features.

Recommendations to others considering the product

Learn SQL first, and then acquaint yourself with the PotsgreSQL extra features. Most of the time, SQL is all you need, and will leave the door open for migration at a later time.

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

I use it as database engine for all my applications, due to the full text search, and that it's the default database used in Heroku

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

"Postgresql - the default database for new RoR projects"

What do you like best?

Solid SQL database, all standard SQL syntax supported with many nice extensions.

Stable

Excellent documentation and good develop support community

Full internationalization support

Good performance

Support for advanced SQL features, like "WITH" clauses and POSIX regular expressions

Built-in full text search (tsearch)

Support for distributed databases - master/slave replication

Lots of native "C" extensions

Right price - open source

Runs on Windows, OSX, and Unix

Installs on OSX using HomeBrew.

What do you dislike?

PgAdmin tends to crash, losing your query, when you resize the query window. That's been true for over 5 years now. I wish they'd fix that. It might have flaws as larger scales that I use it at, but I haven't seen any yet.

Recommendations to others considering the product

Best open source database out there, definitely better than paid databases like Oracle, and probably better than SQL Server.

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

It's a database ;)

PostgreSQL review by Ramón L.
Ramón L.
Validated Reviewer
Verified Current User
Review Source

"SQL that escalates and does not hurt."

What do you like best?

Postgresql is an sql engine that supports a huge load of transactions and has a great community support, the documentation is wide and implementation is not as hard as some people claim, plus it's supported on most today cloud service providers.

What do you dislike?

If one comes from mysql or sqlite, postgres can be a bit difficult, specially with the database and table specification, but this depends on the SO too so this can be a problem for some and not a problem for others. A lot of the old classic shared hosting providers still don't support postgres.

Recommendations to others considering the product

Learn the migration path if you come from other sql engines. Other than that. The documentation is enough for setting things up.

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

Storing Data is the main goal when you need a database. And postgres does that just right. Mysql falls when managin huge loads of data, but postgres has a nice optimization which allows for a larger data load, and this is the reason a lot of people migrate to pgsql.

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

"Great opensource relational database"

What do you like best?

As of yet, I haven't had any issues with Postgresql. I honestly don't think I've utilized it to its full potential. Some of the features that I've found very helpful are its upsert, or insert on conflict feature as well as the ability to have multiple schemas in order to support a multi tenant data model without having to use multiple databases. It is also quite easy to backup and restore, as well as create followers for high read capacity as well as automatic fallover. Also, we use Ruby on Rails coupled with Heroku for deployment, and Heroku has a great managed PostgreSQL service that makes utilizing all of its features really easy and painless.

What do you dislike?

I do wish there was a free tool similar to SQLPro for Postgresql on Mac. There are some paid tools. But I'm fairly cheap. The default management application PGAdmin is very featureful, but the UX isn't amazing, particularly for simple things.

Recommendations to others considering the product

It works really well for us using Ruby on Rails and deploying to Heroku utilized Heroku Postgres.

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

We use PostgreSQL for almost all our relational database needs, typically for backend data storage for web and mobile applications. It has been fantastic and works great coupled with Ruby on Rails applications.

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

"Best for Any medium scale sized project"

What do you like best?

ANSI Compliant SQL, Verbose logging, Replication ease, Indexing performance

What do you dislike?

Nothing as such , would recommend for further projects also.

Recommendations to others considering the product

Give it a try, it wont disappoint you.

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

Its used for financial Applications for a insurance company. We are creating web and mobile based apps for this company, although previously it was also good with another db product, but with pogres ease of use, and orm compatibility is better.

PostgreSQL review by Industry Analyst / Tech Writer in Internet
Industry Analyst / Tech Writer in Internet
Validated Reviewer
Review Source

"Nice Old fashioned RDBMS for general use"

What do you like best?

This database is complaint to ANSI and has good number of functions which are mostly used in ETL jobs. Most recent AWS Redshift is based on the architecture of Postgres. Relatively fast and intuitive. Supported by most of the standalone and IAAS softwares which makes it usable on any platform.

What do you dislike?

Some of the function I really need are not supported in here. It could have been faster but being a relational database that is what we have to give up. Also it is little hard to connected different databases.

Recommendations to others considering the product

Go for it. if you are looking for latest best RDBMS with better industry level support. It won't hurt you look around with AWS Redshift which is more scalable and fast.

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

Building a data warehouse using 5 of these separate Postgres Instances.

PostgreSQL review by Arthur F.
Arthur F.
Validated Reviewer
Verified Current User
Review Source

"Great open source SQL Database"

What do you like best?

After years using other SQL database, I decided to give PostgreSQL a go.

It is amazing how easy it is to integrate to any solution. I've used PostgreSQL in many environments and I was always glad for choosing this database engine. In every language that I use to develop with Postgres there are built-in tools to make my life easier.

PostgreSQL also supports a huge amount of data types, including user defined types which makes the life of a developer way easier. I also feel that I need way less plugins or tools to develop with. It works perfectly out of the box and has a great performance.

Seeing great tools like Heroku adopting Postgres is amazing and just confirms that this is indeed a great tool.

What do you dislike?

Coming from MySQL I miss the Admin tools. PostgreSQL has loads of tools that you can use to manage your database but none will top MySQL Workbench or even phpMyAdmin. Even trying clone tools like phpPgAdmin, it is just not the same. Working on big project without a great database design tool makes it a bit harder to adapt.

Postgres has great tools, but it still behind comparing to other solutions.

Recommendations to others considering the product

Get used by using the command line interface for PostgreSQL. GUI Tools for PostgreSQL are not the best and the earlier you start using the command line, you will see that you can do so much more work without loosing time drag and dropping and switching windows.

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

I changed to postgres mostly because of my job. After the first few days with it I realied that there was not turning back. PostgreSQL is fast, easy and works great out of the box. The integration with any project is just flawless.

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

"An amazing open source RDBMS and more"

What do you like best?

Where to begin?

I could start with the fact that PostgreSQL allows you to build sophisticated data models in a mixture of SQL and other languages, seamlessly interwoven. It is one of the most programmable database systems on the market, with SQL being extended in Perl, Python, C, C++, Java, and almost any other language you like.

I could also start with the fact that PostgreSQL has a very advanced and extensible indexing system allowing for B-tree, B+-tree, and inverted indexes over all or a portion of rows, and over the raw data or data calculated based on it.

Or I could start with the fact that it is remarkably scalable, that there are 32-TB databases in existence (though the largest one I have personally worked on was "only" 9TB in size), that people use it to serve millions of requests a day, and that it backs some of the largest players in a number of industries.

The fact is, however, that the database is amazing in part because these major strengths reinforce eachother and that to single one out misses what makes the database so great.

What do you dislike?

In a few very advanced corners (table inheritance, non-1NF techniques, and the like) there are rough corners. It is rare to hit these though because they are not commonly used functionality.

Also PostgreSQL currently does not have intraquery parallelism though this is coming (with a parallel sequential scan likely in 9.6).

Recommendations to others considering the product

PostgreSQL lets you really leverage theory but to do that you need to know it well.

It is also worth getting a good book on advanced patterns regarding database design in Informix. Informix shares some common design ideas with PostgreSQL and many of the patterns (though not anything involving jagged rows) transfers easily.

Finally pay careful attention to indexing options and learn them backwards and forwards, if you need to support databases of significant size.

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

Typically we want to use relational databases because we are interested in capturing, storing, and modelling information through the course of some business process. My own experience here ranges from biology research to accounting software, so the set of business problems is very wide, and so I will speak in general terms.

Typically I have found that trying to write software against a well-encapsulated database (i.e. where the data model itself has an agreed API) speeds up development considerably, and it leads to more robust, better performing code. These are many of the same benefits people talk about with regard to NoSQL, but PostgreSQL gives you the same benefits often without moving away from the strengths of SQL.

Additionally, in a number of projects I have worked on, the lack of licensing requirements has been important because it means one can quickly roll out new projects with less internal red tape.

PostgreSQL review by Jesús  G.
Jesús G.
Validated Reviewer
Review Source

"Base de datos robusta y potente "

What do you like best?

Lo que más me gusta de PostgreSQL es que mantiene su velocidad en cualquier tamaño de BBDD y no tiene coste su licencia por lo que en cualquier empresa es un acierto. Asimismo, es multiplataforma.

What do you dislike?

Lo que menos me gusta de PostgreSQL es que no es de las más rápidas del mercado, aunque su velocidad es la misma en cualquier BBDD independientemente de la cantidad de filas de la misma. El soporte también es una de las desventajas.

Recommendations to others considering the product

Es una BBDD gratis, escalable y robusta.

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

Escalabilidad y capacidad de almacenamiento.

PostgreSQL review by Rahul D.
Rahul D.
Validated Reviewer
Review Source

"An Amazing Relational DBMS with Json Functionalities."

What do you like best?

PostgreSQL is the most amazing DBMS available in the market. It makes provides with all the power of Relational Database system plus of the flexibility of using JSON data types The Latest Postgres 10 provides an extensive approach for Partitioning and data workers which are very helpful for handling very large data object.

What do you dislike?

When handling a data set of a few million record, you need to carefully analyze your query plan as it can effect your performance badly.

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

We use PostgreSQL as a back-end for our multiple projects.

PostgreSQL review by User in International Affairs
User in International Affairs
Validated Reviewer
Review Source

"The opensource standard for SQL databases"

What do you like best?

I've been using PostgreSQL for many years, and although there are alternatives, I've found that for most use cases PostgreSQL is the RDBMS to go for.

It's not only because of its simplicity or its features. The main reason is that it is tuned to most workloads and you don't have to fine-tune or play with configuration files a lot: it simply works.

This really feels like the developers put a lot of care when designing the RDBMS engine and when choosing defaults. I still have to find a workload PostgreSQL is not suited for.

What do you dislike?

This is not a complain, as I'm okay with the command line and fine using and configuring it through SSH in my servers, but a lot of colleagues find it difficult to do this. Most of them, accustomed to point-and-click solutions, or more mainstream databases, find it difficult to make the switch.

Recommendations to others considering the product

Don't be amused by its complexity or lack of desktop applications for management. It is a really powerful RDBMS engine, and although it can have some rough edges, overall is one of the most powerful contenders (even against commercial and expensive solutions, like Oracle or SQL Server).

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

When there are applications that cannot be handled with standard solutions, I toss the data to a PostgreSQL database and give it a go. It is not the de facto database for my current company, but I use it when required, as SQL Server (the one we use the most) cannot handle some workloads.

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

"The golden standard for SQL database management systems"

What do you like best?

PostgreSQL is rock solid. It's free, it supports multiple platforms and it's widely used.

You can use it virtually from any programming language, and the support will be production level.

I recommend it for learning SQL and for building web applications.

You can start using it with the official docker image in just a few seconds.

What do you dislike?

It's not easy to find any defects in this software.

I think that the initial server configuration could be easier for beginners, but it is very well documented.

Beware that there is no graphical user interface included with postgresql, but there are a lot of management shells (paid or free).

Recommendations to others considering the product

If you're looking for a SQL DBMS, just fire up a docker container with PostgreSQL and start using it in your next project.

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

I've used PostgreSQL to run heavy traffic web-applications. The DBMS is really stable and it is very easy to fine tune.

Lately I'm using the HSTORE extension to build some schema-less features in some legacy applications.

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

"Fantastic, stable RDBMS for large or small projects"

What do you like best?

Fast, extremely scalable, in active development, easy to learn and use, complies with SQL standards, and can handle large GIS data sets with PostGIS.

What do you dislike?

Upgrading minor versions is sometimes a pain with the PostGIS extension. We occasionally have to dump and reload the entire database to get things working without losing data.

Recommendations to others considering the product

I would recommend keeping separate data directories for each minor version. (E.g., 9.3, 9.4, 9.5). This makes upgrading the database much easier (and possible to rollback if something goes wrong). The old data directories can be deleted afterward.

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

My company's product uses GIS data heavily. PostgreSQL (with the PostGIS extension) makes it a breeze to cut through large data sets. Recent versions have also allowed us to handle data warehousing using materialized views, which dramatically increases responsiveness to the user.

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

"It is a good manager of data bases oriented to objects, it is open source"

What do you like best?

The speed is maintained when managing small and large databases, its installation is unlimited, it is low cost of operation in maintenance and adjustment, it is multiplatform, it is stable during the use of databases, it operates on different Linux web platforms, Window, MacOs X, has an excellent security system (user and passwords), large storage capacity

What do you dislike?

It is slow in incersiones and updates, it has online support but it is not official

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

It is capable of adjusting to several computers and the amount of available memory optimally

PostgreSQL review by Administrator in Legal Services
Administrator in Legal Services
Validated Reviewer
Verified Current User
Review Source

"Great experience with PostGres"

What do you like best?

love the aggregate functions, also JSONB support, as well as views and materizlized views maintenance. very stable and secure. It is easy for me to maintain as an analyst

What do you dislike?

certain data types are not good. i find the admin tools to not be amazing either

Recommendations to others considering the product

i would recommend as a data analytics database. It can be difficult to scale and if you have a lot of data that doesnt easily translate into columns (json) unless you are using a vendor to complete ETL process. I love postgres tho :) Very stable and secure and documentation is great

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

I use postgres as a analytics data warehouse only. I allow acces for all other analysts, and sit analysis tools on top. this works quite well. I am often looking for ways to optimize queries tho

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

"Secure and easy to use database"

What do you like best?

Powerfull and stable db engine, it's cross platform, a great support for business, it has many administrative tools and extensive documentation.

What do you dislike?

Actually nothing specific, maybe the fact that it's less mature that its contraparts dbm therefor it has less popularity in market carring a little bit resistence to use as principal dbm in actually projects.

Recommendations to others considering the product

Read the documentation prior to use this, as simple and related to sql as it might look, you might find yourself bumping into some new functionalities that will require you to use them proper in order to configure and use the tool the way its mean to be.

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

Web apps and projects with tons of data that must be processed.

PostgreSQL review by Alessandra V.
Alessandra V.
Validated Reviewer
Verified Current User
Review Source

"A good relational database for small and medium businesses"

What do you like best?

It's a good and not too heavy solution in terms of relational databases.

It's relatively smooth to install, has several good features and performs well.

It doesn't have too much of a steep learning curve.

There is good online support.

What do you dislike?

There can be some issues installing it in a Windows environment.

Nothing impossible, but it can take time to solve them.

A total newby to relational databases could find it difficult to use it, especially as there is no GUI.

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

I'm using it with Ruby programming, and I think there is a good compatibily between the two.

I've got a powerful solution that is at the same time relatively light.

PostgreSQL review by Haripriya B.
Haripriya B.
Validated Reviewer
Review Source

"Experience in using Postgresql"

What do you like best?

It is free and open DBMS software and have good GUI feature.

What do you dislike?

It sometimes crashed when i open it in normal mode. I need to open in admin mode to open it.

Recommendations to others considering the product

Highly recommended for education field because of its good GUI feature and very easy learning environment. I would suggest the computer science engineering people to use this always.

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

In education field, postgre is used over other databases because of its ease of access and quality of support in all languages.

PostgreSQL review by Terence F.
Terence F.
Validated Reviewer
Verified Current User
Review Source

"Cost Effective alternative Databse"

What do you like best?

It's open source software and a large community that supports the incredible features that the database offers

What do you dislike?

Nothing yet! Replication could be improved

Recommendations to others considering the product

Do a cost / benefit analysis - this is fundamental for any new customer engagement solution that uses your product. A database is the core of any software application and you must understand and search out the issues and requirements that face the customer. Every implementation is unique and needs to be looked at holistically - architecture, security, performance, disaster recovery, reliability etc

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

Most solutions do not need a heavy-weight database like Oracle or MS SQL; PostgreSQL offers a very convenient and powerful database that pack a lot of features.

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

"Small learning curve if you know SQL"

What do you like best?

I liked that it is an open source program and that there is a small learning curve if you already know SQL.

What do you dislike?

I don't like that there is no way to report errors, so there's no way to track bugs or fixes.

Recommendations to others considering the product

If you know SQL, it's easy to pick up and there are great resources on line for free. Also check out https://www.postgresql.org/ for a wealth of information!

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

We use it to run all our reports and pull data from our EHR.

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

"PostgreSQL has been the perfect tool"

What do you like best?

Postgres has been an incredible open source tool for our company as we've grown. We switched from MySQL, which we quickly outgrew, and have been going strong on a Python+PostgreSQL build ever since. It's easy to get new DB users up and running on simple tasks, and has great flexibility with its user defined functions.

What do you dislike?

All the graphical query tools that are also free are mediocre at best. There are some really good ones, but they require a subscription.

Recommendations to others considering the product

Its open source, give it a shot, you won't regret it.

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

Proprietary and client data storage in an easily accessible form as well as powering our software interface by building out data tables on the back end.

PostgreSQL review by User in Marketing and Advertising
User in Marketing and Advertising
Validated Reviewer
Verified Current User
Review Source

"PostgreSQL for storing Advertising Analytic Data"

What do you like best?

The speed in conjunction with the native JSON support. With the on the horizon 9.5 the added features will only deepen my appreciation for Pg. Being able to have all the functionality of a NoSQL type DB on top of a a traditional RDMS makes using something like Couch/Mongo obsolete.

What do you dislike?

I am not the biggest fan of the vacuuming that is required for larger datasets. Eventually most people hit the dreaded "transaction wraparound" error if they are not careful and it is a nightmare to recover from sometimes.

Recommendations to others considering the product

At least give it a shot. Aside from time you have little to lose if it does not work out. The community behind it is huge and growing by the day.

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

We were solving the problem of having non-relational data taht was always changing (think ad copy and sections) but tying it to relational data. PostgreSQL allows us to have the best of both worlds.

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

"Main OLTP engine for a multi-tenant application"

What do you like best?

Flexibility, fullness of features and easy extensibility.

for almost anything you might want there's usually an extension that provides this - if not, it's very easy to write your own.

other than that you have the basics fully covered, Loads of SQL features, fast performance, HA,...

Also, the lack of centralized data dictionary is greatly simplifying design for multi-tenancy applications as it allows for a straightforward approach.

Last but not least, postgresql as a product advances in an impressive rate, catering for more and more use cases and deployment options, with great emphasis on performance and data consistency.

It's exciting to see the product and community evolve - make a quick comparison between 9.2 & 9.5 and you'd be amazed what a couple of years can do.

What do you dislike?

It's still behind some of the big players in terms of the optimizer - it lacks many smart optimizations which means that for really complex stuff, you are still better off with Oracle or SQL Server.

(then again remind yourself of the bill :) )

Recommendations to others considering the product

If you're looking for an OLTP engine for a medium sized DB (100s of GB) you're in PGs sweet spot.

It's free and you'd hardly get any benefits from using commercial products here.

The community support is awesome and very responsive. (and you have plenty of companies doing payed support if needed)

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

We use PostgreSQL as our main OLTP server - almost all of our on-line flows go through PG.

It's great for multi-tenancy, it allowed us to scale well while using a rather simple data structure.

(this in terms translates to a high DEV rate)

PostgreSQL review by Daniel R.
Daniel R.
Validated Reviewer
Review Source

"PostgreSQL used with Ruby on Rails"

What do you like best?

It packs all the features you need in a simple to use interface. It has several GUI tools and you can install it either in windows or UNIX OS.

What do you dislike?

So far there is nothing I dislike. I haven't come up with any problems so far.

Recommendations to others considering the product

I really recommend PostgreSQL, I think is the best relational database out there and it packs the most modern technology too.

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

It's free and we find it really useful even when storing information in JSON columns.

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

"Best in class"

What do you like best?

Everything about postgres is quite lovely. We use it for our startup and its quite cool. We switched from MySQL to postgres. One thing that I most love in postgres is that it is schema based, which makes it cool for our needs.

What do you dislike?

Nothing much I dislike about postgres, Its quite cool. Maybe one thing i would suggest (Not I dislike). Maybe we can have some GUI based tool for querying for non-tech guys to query too. Other than the pgAdmin tool.

Recommendations to others considering the product

If you really want some Database that is less complex and easy to use, then I would suggest to go with Postgres. And the community is also quite growing super fast.

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

We use it as the primary database for our web-app.

PostgreSQL review by Ezequiel F.
Ezequiel F.
Validated Reviewer
Review Source

"Powerful free open source Database"

What do you like best?

I like that is very powerful and also free. It has a lot of interfaces for almost every programming language and lets you storage big objects, like pictures, videos and sound files.

What do you dislike?

I don't like the tool pgAdmin, that lets you manage your databases graphically. It doesn't work well, is really slow, doesn't have prediction when you are writing queries and also stops working without any reason.

Another thing that I don't like is that you have to use LIMIT x instead of TOP x to get some x quantity of rows

Recommendations to others considering the product

Really give it a try. It is very powerful and easy to install and setup. Also it has a graphic tool that let you see how the data is storage in rows and columns

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

I had to manage the databases of my university, so we move from MySQL to PostgreSQL because it was free, allowing the university save some money, but also it is very useful and potent database manager.

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

"powerful open-source database option"

What do you like best?

PostgreSQL is well-documented, powerful, mature, and has a huge user base. Easy to find examples and forum postings when troubleshooting just about any scenario: the odd error message, problems using pgAdmin, figuring out how to integrate PostgreSQL into your node.js application.

What do you dislike?

For some use-cases, PostgreSQL isn't the best option. It's worth considering your needs and looking at SQLite, MongoDB, and others.

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

We needed an open source database for a variety of one-off web apps and dashboards. Postgres does a great job of it.

PostgreSQL review by Dorian Patricia T.
Dorian Patricia T.
Validated Reviewer
Review Source

"Speed and open source"

What do you like best?

The first of its attractions is the speed with which it works, the larger the database at speed and the performance does not decrease, apart from the fact that it can be installed on the computer that does not have to pay for it.

What do you dislike?

Many of its instructions are complicated and not supported as should be the case for any database manager.

Recommendations to others considering the product

inserciones y actualizaciones

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

The first point is that almost the principal optmiation of most processes.

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

"Great and much more friendly alternative to MySQL"

What do you like best?

It follows the syntax of standard SQL, quite closely related with MySQL, and it has wide variety of features not present in MySQL . . . . also is friendly with languages like Python and the likes. The existence also of a local database management software (pgAdmin) and command line tool makes everything much easier for first time users, and for experienced developers as well.

What do you dislike?

Nothing so far, in particular. All in all it is a whole package as an SQL language. I have yet to delve deeper into back-end development and look further into what the PostgreSQL lacks as an SQL language. But so far it satisfied my basic needs in an SQL and back-end language.

Recommendations to others considering the product

A must-use especially if you are a newbie in the field of back-end development. Very developer friendly and complete-packaged.

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

Database management through SQL with the whole package and features needed by a back-end developer.

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

"robust and stable"

What do you like best?

easy to use, one of the best database managers to develop complex applications, apart from being robust and simple.

What do you dislike?

It is usually very basic, it would require more functionalities to be of this tool, a more complete tool, additionally the installation is usually somewhat tedious as it requires certain dependencies.

Recommendations to others considering the product

the best database manager to develop large applications at low cost

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

is the best low cost option to manage pl / sql databases, offers all the necessary benefits

PostgreSQL review by User in Financial Services
User in Financial Services
Validated Reviewer
Verified Current User
Review Source

"The best open source ORDBMS there is."

What do you like best?

PostgreSQL is by far the most fast advancing and promising open source database there is. It has an ongoing development agenda and a very active community. Performance keeps increasing and new functionalities are released with increasing frequency. It's a very robust and trustful solution for any database dependent project.

What do you dislike?

The most likeable thing about PostgreSQL might be the fact that its core developers and general contributors might be more inclined to come up with new features than to address possible underlying bugs.

Recommendations to others considering the product

It has never failed me and I bet it won't fail you either. It's reliable and has a very large user base. Typical solutions and general help can easily be found online when problems arise.

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

Being in a very demanding ever-changing extendable and agile environment, working with applications that supports both structured and unstructured data, I consider PostgreSQL a life saviour. It can actually act as a document database when needed.

PostgreSQL review by Consultant in Hospital & Health Care
Consultant in Hospital & Health Care
Validated Reviewer
Review Source

"Decent Open Source Database Platform"

What do you like best?

As with all things open source, you can't get much better than free. PostgreSql does the job, and does it well. New features are being developed all the time, so you won't be too far behind the SQL standard if you went to this product.

What do you dislike?

If you are expecting top of the line software here, like Microsoft SQL Server or Oracle, you will be wrong. Microsoft spends millions of dollars in R&D to move their SQL Server product forward. You won't be getting that level of tech WOW in PostgreSQL. So you will end up having to follow traditional design patterns to accomplish what you are looking for.

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

A fully featured database for free.

PostgreSQL review by User in Internet
User in Internet
Validated Reviewer
Review Source

"Fast and featureful"

What do you like best?

Postgres is a fast database packed with features and always getting better. Most of the time I just need to use ANSI SQL, but sometimes I need something special to solve a problem and postgres always seems to have just what I need. The licensing is good too, where I'd be afraid of getting locked into vendor-specific features and getting stuck with Oracle, but with postgres I don't have to fear the vendor providing the software.

What do you dislike?

It can be a bit more work to get things set up vs something like mysql. The bit of extra learning curve is well worth it though to get a proper full-featured RDBMS.

Recommendations to others considering the product

Use it.

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

Storing data with strong consistency and being about to step outside the usual relational system when needed.

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

"Great, but size problems"

What do you like best?

Fast fetching large data. Able to store and somewhat able to search json blobs. Able to use inheritance in tables. Based on well known sql language. Lots of info in admin tables

What do you dislike?

The size grows like crazy. After a db export/import it can shrink to 30% the size with the exact same DB which means lots of space was wasted. Tons of tables can be slow to vacuum and that can cause a DB crash.

Recommendations to others considering the product

Preferred over my experience with sql and nosql DB

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

Storing masses of ads on search engine result pages.

It pulls back masses of data faster than we got with mysql

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

"Best SQL Database integrates well with just about any server language"

What do you like best?

PostgreSQL is very robust, easy to use and has a nice documentation. It comes with a lot of built-in tools such as generating unique identifiers (UUID/GUID) and has many ready to use plugins such as PostGIS for geospatial querying. If your organization uses a relational database, then PostgreSQL is as good as it gets.

What do you dislike?

As with any SQL database, PostgreSQL has a lot of limitations. The biggest limitation that in my application is full-text search. To be fair, PostgreSQL does come with some nice tools for full-text search, but relational databases are not designed for this stuff and you're better off using a specialized tool like ElasticSearch, which happens to work pretty well with PostgreSQL.

Recommendations to others considering the product

Make sure that you're comfortable with SQL before using PostgreSQL. Also read the documentaion

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

We use PostgreSQL to keep track of our customer and business records.

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

"Great open source DB"

What do you like best?

I like that the DB is free to use and distribute, however there are tons of resources available for the product.

What do you dislike?

The only thing i can think of that i currently dislike is running a query on several databases at one time. something that is actually much simpler in SQL server.

Recommendations to others considering the product

The product is great and there are tons of online and consultant groups to assist with setup and implementation.

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

We are using PostreSQL for our applications and as a database for external data mining and analyzing.

PostgreSQL review by Administrator in Internet
Administrator in Internet
Validated Reviewer
Review Source

"Fairly scalable, easy to configure, easy to maintain "

What do you like best?

I like that it is both lightweight and fast. It's pretty lean on resource consumption. Replication is easy to set up and pretty well documented by the Postgres Development Group. I like that it was easy to make changes to replication and access permissions without having to do a full restart of the database. I several times found my self impressed by how resilient the database was. Disk filled up? Add more storage and restart the database without data file corruption (YMMV). Your replication slave broke and you don't have the logs on disk for it to catch up? Blow it away, clone the master, and restart replication (don't use the postgres version in the AWS repo).

What do you dislike?

In comparison to any other database technology that I've worked with, Postgres was easy to work with. "It wasn't implemented correctly", "replication was set up wrong", "the server capacity was misguessed when it was launched:" These are downsides to any technology where there is a general lack of knowledge. There's a simple way to avoid those problems: Hire a DBA, or experienced sysadmin and take their advice. There is problem with a lack of general knowledge when it comes to open source technologies combined with the fact experienced technologists all seem to have their own beloved biases. But those problems are not related to the technologies in use, but rather the people that use them.

Scalability never became an issue, but I haven't seen a lot of solutions for building hot-hot clusters, or putting multiple instances behind a connection manager for horizontal scalability, and trying to research multi node clusters will tell you how to set up synchronous/asynchronous master/slave replication at best or make you realize that a lot of the PG user community does not know the difference between high availability and scalability.

Recommendations to others considering the product

As with anything else try to accurately predict your requirements, and when in doubt supersize. Maybe hire someone with some experience to implement, and maintain it. If you hire an expert, take their advice.

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

Postgres made it easy to create redundant copies of data for both our front end web applications, and back end APIs servers. It allowed us to build applications with a high level of data redundancy in our production environments while simultaneously synchronizing that data to a DR environment. The addition of Postgres support in Amazon RDS was also a good indication of that some of the problems that we faced on standalone instances were quickly and easily solvable (as long as you are not using the Postgres packages available from Amazon, which are missing some key utilities).

PostgreSQL review by User in Internet
User in Internet
Validated Reviewer
Review Source

"Best opensource DB"

What do you like best?

The best free DB to use. One of the most stable and with very active community.

Compatibility with Geo Spatial objects, JSON etc.

Unlimited database size with 32TB tables, 1.6TB max row size, 1GB max field size, and unlimited rows per table.

There are so many extensions to use with PostgreSQL.

What do you dislike?

Coming from enterprise RDBMS software like Oracle, some of the features are not very intuitive.

Initial learning takes sometime coming from MySQL type systems.

Configuration changes needed restart.

Handling WALs may be complex sometimes.

Recommendations to others considering the product

PostgreSQL is a free DB to use. Very robust and scalable DB with all required regular RDBMS features.

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

Main use case was storing and handling JSON data. Also to support geo objects.

Another requirement is to have the database on AWS RDS.

PostgreSQL review by Edward F.
Edward F.
Validated Reviewer
Review Source

"A great database to use over most competitors"

What do you like best?

The features in PostgreSQL are excellent, other competing products are years behind in the tools that are already available. It is very configurable for almost any kind of environment and product you are building, if you need high availability, redundancy, clustering, etc. it is supported. Lots of granularity in the data being stored.

What do you dislike?

Coming from a product like MySQL that is much simpler than PostgreSQL can seem a little overwhelming as you get up to speed on documentation and configuration guides.

Recommendations to others considering the product

Get past the initial hurdle of learning how PostgreSQL works and enjoy using it - it offers a lot of great functionality.

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

Needing an open source and free database solution that was more reliable than MySQL but had most of the functionality that exists in Oracle. Our database is rock solid and performs very well, it's been easy to customize as our needs change.

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

"The best for complexe data"

What do you like best?

PostreSQL is performing very good with complexe data designs and multiple data logics, he's also good with data-mining and batch analysis .

What do you dislike?

Replication is harder to setup unlike other Object-relation Database server .

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

We are using PostgreSQL in our API structure, he can handle an enourmous amout of queries fluently .

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

"Postgresql - The Only RDBMS You Need"

What do you like best?

Everything. It supports all the SQL-92 standards, plus some of their own editions. It has a very mature GIS querying and every type of index. It supports in memory and a ton of different trigger languages. There's no feature or item missing from postgresql.

Use it and you will be happy.

It's an exact replacement for oracle without the cost. Supports triggers, procs, functions and everything you can think of including a datascience machine learning package MADLIB.

There's no reasons not to use Postgresql. The drivers for Java and Scala and NodeJS are excellent. Postgresql also powers a lot of servers like Cloudfoundry.

What do you dislike?

The problem with Postgresql is that there's a lot of version and no single owner of the enterprise verison. No really a concern.

Recommendations to others considering the product

There is no reason to not use PostgreSQL, it is amazingly mature coming from Ingres and Dr Stonebreaker. It's been around forever and is really solid. A dozen or so commercial vendors have MPP and datawarehouse forks of it that they use.

Postgresql JSON features are very helpful for front-end usage and the indexes make most queries blazing fast.

We have no dba and really don't need one. The DB runs itself.

You do need to run a few dba tasks weekly like vacuum, analyze and backup.

Check your explain plans and make sure you have adequate queries.

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

We are using it for data warehousing, basic data for web sites, blog storage, backup data and research data. It is also our main analytic database and transactional store.

It has saved us a lot of development time and money. Spring Data JPA and hibernate work perfect with PGSQL. pgADMIN and all JDBC SQL tools work perfect with it.

PostgreSQL review by Consultant in Information Technology and Services
Cons