PostgreSQL Reviews

By far indexes is the most useful and robust feature. Also, the query optimization engine is simply great. It is very complete, clear and useful documentation, forums and diverse information channels.

Most of the enterprise I have worked has been startups and small to medium software industry and data analysis. One of the most improvement it is not in the mean time but in the middle to long time. At first sight it seems to an overkill implement a product as PostgreSql for small projects; even managers and investors tend to put some resistance to it. Then, as soon as projects start scaling and data set increase in size, concurrency, consistency and data types, is were you think PostgreSQL was one of your "hit" on the project design, time give you lot of credits.

I think that data types that decrease the breach against NoSql Databases will be the next steps. I am not talking about changing to a pure NoSql DB but to some features that will face the big change in data analysis and maintenance that that DB are facing nowadays. Also tools for distributed replication and clusters should be more researched and improved; anyway nowadays there is some of them.

I have been using PostgreSql since University where I teached students some DB theory concepts. The course was focused on indexing and benchmarking. Also I use it on software industry, as a DB manager, designer and operator; common tools were PL/pgSQl, indexing and tuning; using about 3.0M per month DB tuples inserted and about 500tps on peak points. Finally I use it on personal projects, for small data sets (~1.000).

We have had no issues with the deployment.

I have faced just a few issues working with PostgreSql, one of them was specifically on Hash Index (see as example http://www.postgresql.org/docs/9.2/static/sql-createindex.html.

We have had no issues scaling it for our needs.

Most of the great value of PostgreSQL is the variety of technical support you can find Consulting, lots of forums, and big communities who have been using and documenting PostgreSQL for a long time. I have never faced a problem or question that couldn't be solved using these channels.

I have worked with MySQL and Oracle solutions. Against MySQL, performance is the big difference. PostgreSQL is far more robust and mature than MySQL, especially when you think about keys and indexes. Against other databases, such as Oracle, the easy installation steps of PostgreSQL is the best difference for me.

I have faced a few issues while installing it and configuring it; most of them related to incompatibility while using old Ubuntu Linux versions.

I have always implemented it in-house, and as all solutions for everything on vast areas, is highly recommended read guides on how to install it.

ROI is by far fair enough for startups and enterprise projects that are expecting a big grow in the mean time.

PostgreSQL license is a fair enough for small to medium size business solutions.

Just read the comparisons between different database engines, and read some documentation so you can exploit most of the powerful tools and functions it has.

• Security
• HA and DR
• Performance
• Maintenance

I worked as a consultant/trainer. I have a few installations of Dev/Test in my VMs, and I don't have anything in the production installation in our organization.

It's not very user friendly, as it is open source and has no immediate support. You can download the Enterprise version of Postgres that is a GUI installation and also have a support contract.

I've been using it for five to six years. I did the PostgreSQL DBA’s training and led the implementation and data migration projects.

We also use the EDB Postgres Plus Advance Server v9.3 (EnterpriseDB). We use it to evaluate the Database migration from Oracle to Postgres. The data level migration was successful but for objects, and at the security level, you have to fix issues manually.

We've had no issues but setting up the replication, security, and login is different from other databases.

We've had no issues with the stability.

There have been no issues with scaling it for our needs.

As mentioned earlier, there's no support contract for open source but with EDB (EnterpriseDB) you have the open to purchase the support contract. I don’t have any experience with EnterpriseDB support.

It's straightforward, as it's an open source product.

We did it in-house.

As it's open source the ROI is quick.

The core product is free but you have to pay for third-party utilities / plugins and support.

I have evaluated MySQL and Ingres previously and then PostgreSQL. My personal choice is PostgreSQL. I also worked on a migration project from Ingres to Oracle.

• Positive - 100% free as it's open source
• Negative - it's hard to find expertise

If you are planning to migrate an existing environment, please go through with the full UAT cycle at data, connectivity, objects and apps level.

The most valuable features are a good feature set, understandable, and good tuning features. It is, also in our experience, the best open source GIS enabled database, with good support from other open-source tools.

The product has easy installation procedures for the OSes we are working with and gives also a good possibility to tune the database for the given usage.

The database is used to set-up customers projects and is our standard database which we use.

One of the features it needs is a tighter integration with business intelligence software, so that the optimisation of the requests can be handled natively in the database. These features are on the roadmap, and are already partially released in the latest version.

We have been using this database for about 18 years.

We have had no issues with the implementation. Most of the issues we have encountered in external installation where due to misconfiguration.

There have been no issues with the stability. Most of the issues we have encountered in external installation where due to misconfiguration.

We had no issues scaling it for our needs. Most of the issues we have encountered in external installation where due to misconfiguration.

We have up until now not needed additional customer or technical support, these can be purchased by supporting companies.

We have been using Oracle software, and in some cases MS SQL server. The price difference between the used products and PostgreSQL was one of the issues. The second was the ease of installation and the availability on different platforms.

The initial setup is easy to perform, but the tuning is a bit more complex. The installation support on Linux flavours is excellent and has native installation packages.

Implementation and installation was carried out in house.

The pricing of the database is open-source and our investment in the product is based on training.

It can handle complex SQL queries.

It has helped to cut costs because it's open source.

It needs better support for JSON and web services.

I've been using it for 13 years.

We had no deployment issues.

We've had no stability issues.

There have been no issues scaling it for our needs.

It's open source, so there's no technical support available.

It was simple to setup.

We implemented it with our in-house team.

There was an immediate return-on-investment of 100%.

We also looked at MySQL and other databases including open source, standards, compliance, and enterprise features.

We have no regrets and are satisfied with it. I would advise you to go ahead and implement it.

It supports full text search, and windows functions.

All our data is stored in PostgreSQL, and we use a BI solution on top to gather all the important metrics to our business, so the whole company has a clear picture of what is going on.

It lacks the ability to distribute queries across multiple installations out of the box.

I've used it for seven years.

No issues encountered.

I've never experienced any data loss.

No issues encountered, even when querying through third-party applications.

I've never had to deal with customer service.

The support in the community is excellent, the documentation is great, and questions submitted to the mailing list are quickly answered. The IRC support is also excellent.

I used MySQL, but I needed support for full text search. PostgreSQL adds this, and also many more advanced SQL functions.

Setup was very easy on all platforms that I use - Linux, Mac OSX, and Windows. It is a simple walk-through installation.

It was done in-house.

It's a free solution, and we use it as a data store, it's all return.

PostgreSQL is free software. The only cost of setup was a few developer hours, and with it being stable, we don't have any day-to-day costs.

• MySQL
• Microsoft SQL Server

PostgreSQL is one of the most stable data sources out there, and it offers you the most advance and modern functions on SQL so you can do more with less.

6 years

Authentication config could be made easier.

It's very stable.

The use of extensions for integration with different databases is valuable.

Our organization has MySQL, Oracle, PostgreSQL and flat files in our processes, and the use of extensions has facilitated the integration between these processes. Also, it's only 7-8/10 when comparing it to an Oracle database.

The use of XQuery besides XPath into PostgreSQL. It would also be nice for them to add some backup features similar to the one that Oracle Recovery Manager has. Also, a tool to query archive files would be a nice addition, and being able to change the execution plan through hints like we do in Oracle. There are some more but these would be my favorite ones.

I've got six years experience with PostgreSQL, and 18 with Oracle.

No issues encountered.

No issues encountered.

No issues encountered.

I'd rate it as 10/10 as an open source product with an active community.

I'd say it's good.

We initially only used an Oracle database, but we decided to add PostgreSQL as an option because of its similarity to Oracle. Also, it's free and is the best open source database.

It is simple, especially when you know the main components of a database.

We implemented it in-house.

We didn't have any setup costs because it is free.

• MySQL
• SQL Server
• Sedna XML

I'd say go for it. It is stable, and easy to use but you should get an understanding of it to implement backup strategy.

It allows us to have an alternative solution to licensed DB's.

It requires enterprise integration improvements from the security, and audit perspective (AD integration etc.). Also, integration into existing BI tools is not present.

I've used it for three years.

They provide a high level of technical support.

We switched due to a common OS integration strategy.

We had an RFP process to evaluate between similar product categories.