PostgreSQL Reviews

Stability, compound & functional indexing, MVCC, transactional DDL, GIS extensions, recursive queries, common table expressions, materialized views, procedural languages, triggers, and excellent documentation. PostgreSQL feels more like a mature, feature-rich, performant data platform than a simple datastore (I'm looking at you MySQL & Mongo).

Full ACID compliance for all transactions (including those with DDL changes) is supremely helpful when making modifications to the schema. The query planner and indexing functionality is second to none, making it one of the fastest database platforms available.

I would like to see the ability to reorder columns on a relation, as well as change the base SQL query that generates a materialized view without having to drop the view, provided the view's structure is unchanged.

I've been using it for over 12 years now.

Replication has been very easy to set up in recent versions. That said, there is a learning curve when it comes to server configuration.

We had no issues with the performance.

PostgreSQL does an excellent job of scaling.

There are companies that offer professional support. I personally have found the IRC channel to be an extremely effective channel of support, as many users and core contributors to Postgres often hang out there.

I've also used MySQL and MongoDB, but neither of those technologies provide any competitive advantage over PostgreSQL in any respect that comes to mind.

The initial setup was fairly straightforward. That said, configuring the server past defaults can be rather complex. Properly tuning the server requires a fair amount of knowledge concerning the architecture of PostgreSQL itself.

In-house. That said, it's very easy to spin up an instance using Amazon Web Service's RDS product.

PostgreSQL is completely free and fully open-source.

PostgreSQL is the world's most advanced and performant SQL database available. It essentially beats out MySQL, Oracle, SQL Server, and often MongoDB on virtually every use case.

PostGres is a fantastic modern RDBMS and its open nature allows you to get as low level as you need. You can define functionality, you can call from SQL and dig deep into the query planner with it's excellent explain functionality. The true open community is loaded with helpful people who believe in OSS. Every feature in PG is first, present, but secondly mature and just works. You may have bugs in your code but PGSQL will never be the cause of it.

It drives our enterprise architecture we are building.

The only thing that could potentially be improved is PGAdmin3, the DB Client that's has not been updated in quite a while. PostGres keeps ahead of the curve on it's feature set. For instance the new JSON column that's come out recently to provide nosql functionality that has been benchmarked to outperform mongo.

We had no deployment issues.

The product is quite stable, and provides awesome performance.

There's been no issues with scaling it for our needs.

It has a great support community.

I started with this product.

It's very straightforward initial configuration if you start with your distro packeges.

It's very easy, and you only need to familiarize yourself with its file structure. Sometimes you need to write your own plugin, so sometimes it is better to have it implemented by a vendor.

It's free as it's open source.

It's go good reliability and is very compliant with standards. If you are installing relational DB you likely know how to use one. If you're not familiar with RDBMS's make sure you look into and use the features of the DB like views etc. They all serve a purpose and will improve your development if leveraged properly.Huge feature set.

JSON support, especially the new JSONB data type is valuable . We used to have a mix of PostgreSQL and MongoDB to solve some of the complex problem around data schemas, now, we rely solely on PostgreSQL as our main datastore. Same flexibility with rock solid performance.

PostgreSQL has been a key component of our business, it is a rock solid product with years of expertise behind it, it is more cost-effective than Oracle and allows us to focus on innovation rather than licensing costs.

JSON support although great, it still has some gotchas, querying and manipulating JSON will be one of the topics I'd like to see some improvement, still feels not natural to work with it.

I've been using it for around four years.

There have been no issues with the deployment.

We haven't had any issues with the stability.

We haven´t hit the point yet when scalability is a problem, but it would be nice if horizontal scalability comes out of the box

So far the community has been great with us, every time we have a question or not sure what is the best way to tackle a problem, we have encountered someone that is able to share his knowledge with us.

It was pretty straightforward, initially our setup was not complex on purpose, we were looking for a simple yet reliable setup, that allows us to gain expertise before moving to a more complex one.

All in-house. My advice is to try to keep things simple, it is harder to learn from complex setups where the setup itself is a problem too, work on complexity once you feel comfortable with the expertise you have gained.

In our case, our ROI is very high, we do not pay for licensing, we use the community version of PostgreSQL and sometimes use companies that provide a hosted PostgreSQL.

We evaluated Oracle, MongoDB and CouchBase. Although those seem to be different products, they have some common features that worked for us, we decided to go with PostgreSQL because of its reliability and proven track record.

PostgreSQL is a great product, very mature and is evolving into other areas beyond SQL, in this times of connected devices and big data analytics, PostgreSQL can still be considered one of the key components and works very well with others. Being reliable is still one of the best ways to get a good ROI.

We use it as an intermediary database for the collection of a variety of data points out of our data systems.

There are many departments that have different data, single points of truth. We asked them to give us different datasets, and we accumulated them in our Postgres-stored database.

It's an intermediary for a machine learning model.

I am more of a fan of doing things straight out of Python, but with the size of the data sets, we were forced to do it in SQL.

What I like is that it's quite powerful in terms of performance.

Part of the reason we use this solution is because of its simplicity and because it works. It does all of the basic things it's supposed to do and it's not anything fancy.

They are fulfilling their customer's needs. 

I had some issues when I integrated with the Jupyter Notebook. 

In the system administration, if you open the connection to the database with a notebook, there is no automatic closing of this connection. 

I would like to see seamless integration with other tools such as Jupyter Notebook. We use it with Anaconda.

Also, possibly more streamline integration with more programming languages. An API for some different languages such as MARGO and JavaScript could be interesting.

I have been using PostgreSQL for one year.

I had an issue where we couldn't find the fault, and it happened on occasion at the end of the day. Some of my basic queries would stop running. 

I had some queries run for two days and some run for a day, then I would have to try it again the next day and it would complete in 20 seconds. Sometimes, it seemed to catch itself.

I haven't had any contact with technical support from PostgresSQL. I do my research using Google.

I did not initialize this database, but from what I understand it's very basic. It was simple to do.

I would prefer programming languages to query languages. Scripting, for instance.

If you have a relational database then you want to use PostgresSQL. I would recommend this solution to others who are interested in using it.

It's suitable for everything we use. There was nothing exceptional from my perspective, but it did everything we needed it to do.

I would rate this solution an eight out of ten.

It is easy grow it from a small environment to a large one.

We use PostgreSQL as the basic tool for offering our data warehouse and BI solutions. This way my customers have a free tool and I can offer a lower price for our services.

It should have a better native client tool to manage the databases.

I've been using it for nine years.

We have had no issues with the deployment.

There have been no performance issues.

It's been able to scale for our needs.

I've never used it , but this tool has a big community and they are always open to helping.

We had some problems with bigger customers using MySQL so we moved to PostgreSQL.

It's very straightforward if you are using the default configurations. It can become complex when you begin to change these configurations to adapt it to fit your environment.

In-house because we a are a technology company. I always advise to look for a consulting company, sometimes the default configuration is not enough and the tool can become a bottleneck if it isn't properly configured.

My advice is to always begin with the free licenses, and if you see that your tool is becoming a strategic solution, you can look into obtaining professional licenses.

Overall it is an excellent RDBMS and it is easy to use and administer. In PostgreSQL 9.5 the table inherent Foreign Data Wrappers(FDW) is available. This extension is available for most databases which makes building server federation very possible.

In 9.5 support for FDW was improved which means it is now possible to import a complete foreign schema. Foreign Table inheritance is now supported as well. They have also improved the Foreign Query optimization since v9.4. Lastly, It has low maintenance requirements so not much has to be done as far as DBA tasks go.

We were able to use the latest features described above to facilitate the integration of disperate data sources into our Postgres Data Warehouse.

• Improved support for parallel query execution
• Merge Joins
• Improved Handling of Materialized Views

I've been using it for years.

We have had no issues with the deployment.

There have been no performance issues. It's a very stable environment.

It's been able to scale for our needs and easy to extend when needed.

Although there is no tech support, it has a large user community who are always helping each other.

The last few versions work great out of the box without much config changes. Don't be afraid to try it.

• Very good indexing solutions, especially for arrays and text search on large quantities.
• Very good behavior on large databases (>800GB) and large tables.
• Datatypes - support for vectors, XML, JSON, UUID and the functions and operators for them are very useful.
• Programming languages - I deeply appreciate the extensibility of the server to allow more than one language for scripting functions. We mostly use PL/SQL, but recently I've tried PL/v8 and was astonishing to see that it works.
• Execute with Query Parameters is a big plus for us as there are no type conversions needed to run dynamic queries reducing the run time by approximately 25%
• There is a huge amount of community interest in developing and supporting the product.

All of our BI needs are implemented using PostgreSQL functions. Our tools are designed in such a way that the BI is implemented as much as possible through our database. We need a lot of flexibility to extend the BI logic on a specific installation.

Synchronous replication is needed, and although I have only searched the web for a couple of hours the only solutions I could find were at the application level of the database.

XML and JSON manipulation functions need to be improved as for some applications we need to add new elements to these "structures". To do this with JSON I currently use a PL/v8 extension.

We have had no issues with the deployment.

There have been no performance issues.

It's been able to scale for our needs.

Try it out! Sometimes, due to the high degree of configurability and extensibility, you might see some issues arise, but it's not that difficult to figure out what's happening. You will definitely be amazed by the SQL features and extensibility.

PostgreSQL gives you much more flexibility because it's open source.

It improves the query performance a lot and helped in some real time and analytic reporting

Sometimes it hangs and then we need to stop and start the services again

I've used it for three years.

We've had no issues with the deployment.

There have been no stability issues.

We have had no issues scaling it.

7.5/10

7.5/10

No other solution was used.

It was straightforward.

We used a vendor team.