PostgreSQL Reviews

PostgreSQL is probably the most SQL-standard-compliant RDBMS on the market. It also goes way beyond standard relational paradigm combining key-value stores, arrays, and columnar stores into a single engine. With the introduction of Foreign Data Wrappers it also enables connecting various different data sources to the database, so it's possible to have, for example, a CSV file-backed foreign tables or to import a MSSQL schema into PostgreSQL.

PostgreSQL allows us to have a single database engine used for OLTP and OLAP workloads, for relational and non-relational data. Its robust and battlefield-proven replication makes us sleep better.

Logical replication would be a major improvement and it's already being worked on. It'll enable true multi-master replication and active-active setups. More OLAP-related performance improvements are also on the way with parallel query processing and parallel background workers being to most significant ones.

v9.5 came out at the end of last year, but I've used previous versions as well. At the moment all the new deployments I'm installing are based on 9.5 since developers are very keen to adopt it and administering it is a breeze.

PostgreSQL is the most advanced open source database in the world and therefore is considered by some to be complicated, but it's not. Deployment is easily done in major GNU/Linux distros.

PostgreSQL is rock-solid-stable, once set up and configured correctly it just continues to work.

There are plenty of clustering solution/ideas that enable horizontal scalability.

PostgreSQL has a very active community and in most cases that's enough of a support. There are a few commercially focused companies, and a lot of freelance consultants [with the writer of this amongst them]. Bugs are always resolved in a timely manner.

If you can type "apt-get install postgresql", you can consider yourself expert in installing PostgreSQL.

While the initial setup is easily done by any member of Ops team, it's important to have a dedicated DBA resource to take care of it. PostgreSQL has superb documentation, it is probably the best documented IT project. We have an in-house team and almost never have to use external consultants. PostgreSQL is very much different from the most popular RDBMS, so it's best to seek a PostgreSQL-focused professional for the in-house team.

I work with few other RDBMSs, but nothing compares to PostgreSQL when it comes to ACID and SQL compliance, stability and the ease of administration.

Get a dedicated, PostgreSQL-focused resource, it's hard to convert DBAs with background in other denominations.

Speed and price, it’s fast and reliable, and free.

Due to budget restraints procuring software is always an issue, and mainly production systems are well maintained. However development systems are not usually so well off. As PostgreSQL is free, this enables us to develop applications without having to think about budgets, and give us greater flexibility. There is still reluctance by business to accept free ‘Open Source’ software, but proof of concept development can be achieved at no to low cost.

Simplicity in design and improvement with programming languages like PHP.

I've used it for four years.

In development it’s super sensitive with comma, quotations, and letter cases. It should not be. If we use uppercase sometimes it works and sometime not, and its need to be single quote sometimes but sometimes double quote.

There have been no issues with the stability.

We've had no issues with scaling it.

I've never used customer services, but it needs a better documentation.

We use both MySQL & PostgreSQL, some applications have better compatibility or built in tools, this decides which database we use.

It's straightforward.

So far we have not had any issues with this database are we are using this in development and production systems.

The product is free, which is a huge benefit. There are options to create clusters and maintenance on the databases is easy and fast. The management studio with product is create and intuitive.

We used this product for applications which require a database. Since MS SQL Express has limitations and regular MS SQL requires pricey licensing, PostgreSQL was an easy choice. The deployment is quick and easy and works with very little configuration, if any at all.

The commands for PostgreSQL work, but are behind the curve compared to Microsoft SQL and MySQL. Adding additional functionality to be move comparative to Microsoft SQL would be a nice to have. For experienced users needing to make configuration changes, it is straightforward, but for users who are new to PostgreSQL they need some help working within the config files, a GUI for config may help with this.

We've been using it for four years.

I've never had any issues performing multiple deployment.

There have been no issues with the stability.

We have had no issues scaling it.

I have never had to contact support, but the documentation they have is very good and extremely detailed.

We use Microsoft SQL (all versions), MySQL, PostgreSQL, SQLite, etc. We use PostgreSQL when the application supports it and where it makes more economic sense to use it.

Following the setup documentation was extremely straightforward and simple to follow. We have no issues with the install, config or operation of the application.

We did an in-house implementation for PostgreSQL. The documentation made it easy to do and was very simple to follow.

PostgreSQL is free to use.

Ensure its a good fit for the application you are using and integration you may have planned. Review all documentation prior to moving forward and always test the new versions before just cutting over.

We use this solution for the back-end database.

The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution.

PostgreSQL could improve by being more user-friendly. In SQL Server they have a studio where you can easily do management but not in this solution. 

I have been using PostgreSQL within the past 12 months.

I have found the solution stable.

The solution is scalable but it could improve.

We have approximately 10 users using this solution in my organization.

We are using the open-source version for eight years. We have to rely on our own skillset to manage it.

The installation is easy.

We did the implementation ourselves but it is always recommended to use an expert.

This solution can offer a cheaper choice for customers since it is open-source.

I have evaluated SQL Server.

If you have a startup company with a normal production environment then this PostgreSQL should be fine. However, if there is a professional environment where there will be some support requirements and mission-critical applications, then they should choose an alternative, such as SQL Server.

I would recommend this solution to others.

I rate PostgreSQLa seven out of ten.

We design it and put it as part of our system and sell the system to various airports. We've designed our own schemas, and we track events that are meaningful to airports so that they can create their reports, view statistics, and make meaningful decisions that make sense for them.

It has completely met our needs. It works, and it is robust. We haven't had any problems with what PostgreSQL does for us and the way it does it. That's why we've been using it for so long. We understand it, and it does the job.

When you get a large number of records in a database and start doing various queries, it can adversely impact the performance of the live running systems. That's an area we continue to look at and mean to improve, but it is not only because of PostgreSQL. It is also because of the way the schemas are put together, and certain events are triggered. So, it is because of both parties.

I have been using this solution for 18 years.

It is pretty straightforward.

I would rate PostgreSQL an eight out of ten.

We primarily use the solution for management. We have a managed ERP solution, however, it's all in-house.

The ease of use has been a great benefit for us in the organization.

The solution is very easy to use.

The database has excellent performance.

It's easy to audit the database. When the user makes some changes to the database, it's easy to audit the changes. It's fairly easy to manage.

The human resources, the HR, within the system needs improvement.

The user interface could be a bit better. 

Just the basic functionality could be improved overall.

I've been using the solution for two years at this point.

The stability is very good. It doesn't crash or freeze. It's not buggy and it seems to be glitch-free. It's good.

Really, I didn't have any problems with scalability. If a company needs to expand it, they can do so.

We only have developers that use the solution. 

We don't plan to increase usage in the future.

We don't use technical support, and therefore I can't really evaluate them. I have no idea if they are knowledgeable and responsive.

They do have documentation and manuals that are okay. They're pretty helpful.

The company used a Microsoft SQL Server previously. I don't know what the reasons were for changing, however, due to the fact that, when I arrived at the business, they already had Postgre.

I don't have any experience with the implementation. I didn't handle the process personally.

I'm unsure as to how long deployment takes.

You don't need too much staff for maintenance. We have one person that handles it.

It's my understanding that the solution was handed in-hours. We didn't use an integrator, reseller, or a consultant for the deployment.

I'm not sure what the licensing costs for the solution are.

I believe we are on version nine of the solution. It's one of the latest versions.

I'd advise new users to maybe be aware of the syntax of the sentences of PostgreSQL due to the fact that it's a little different than SQL or Oracle.

Overall, I'd rate the solution an eight out of ten. So far, we've been using it and we haven't had any problems.

I am using it to gain knowledge of the product, as I am an implementation engineer. Some clients are public organizations, migrating from Oracle to PostgreSQL.

We use it daily.

The most valuable features are:

• The price
• Stability 
• It is scalable and is used by our clients in small business environments
• It is a simple product to use.
  

The user interface for the clients could be easier to use as they are small businesses.
From a technical support perspective, the documentation could be improved. The simplicity and availability of documentation and transparency need a little improvement. The product also needs more service support. However, there is a good online community that can help to quickly find a solution.

I have been using PostgreSQL for one year.

The product is very stable.

The setup of PostgreSQL is straightforward.

We use an in-house team.

I would rate PostgreSQL a ten out of ten. 

In my experience, the most valuable features of PostgreSQL are streaming replication, rich indexes support, extensibility and NoSQL features such as hstore and JSONB. This features are very mature and stable, we use them in many projects, they're predictable, always work as expected and without problems.

In future releases I would like to see built-in realization of multi-master cluster with sharding, effective partitioning, incremental backup, optimizations for SSD, connection pool facilities, and built-in replication for tables and databases.

I've used this solution for five years.

There are no issues with deployment. Postgres has a very verbose and clear documentation and install instructions.

From a scalability point of view, there are no difficulties. It works out-of-box without any third party tools, but streaming replication allows you to scale read-only workloads. For write scalability, Postgres-XC or Postgres-XL should be used.

I don't use any services and technical support, and th community's support is very helpful, friendly and the members have rich experience with PostgreSQL.

I don't use any similar solutions such as Microsoft SQL, Oracle, or MySQL.

The initial setup is simple and doesn't take a long time, but in serious projects, PostgreSQL requires additional configuration optimizations as do the other RDBMS.

We did it all in-house. You should read all the official documentation as all the answers are there.

PostgreSQL is an amazing product, very stable, predictable and reliable with rich set of features.