PostgreSQL Room for Improvement

Jason Tumusiime
Software Developer at a healthcare company with 1-10 employees
It could be improved by using parallelization. We want distributed computing. Some databases handle huge volumes of data better, such as the NoSQL database, MongoDB which can handle 100 000, or a million people using the same data search. PostgreSQL is going to take longer to do this, but it is more structured, and unlike MongoDB data is less likely to be duplicated. Large volumes of data can be handled better in PostgreSQL if the queries are written well. View full review »
Kaan Çelik
Data Analytics and Business Intelligence Manager at a computer software company with 201-500 employees
The pricing could be better. View full review »
Chief technical officer at a healthcare company with 51-200 employees
PostgreSQL is limited to 32 TB in maximum table size for version 9.6 and earlier. This can be problematic for large databases. We currently don't have the multi-tenant feature and we require that with the contract integrated reassurance. To create have one tenant or more tenants, I need to implement or develop a software solution to connect with the multi-tenant, and to connect each tenant. PostgreSQL is not great for software developers, but it is adequate. For developers, databases such as Firebase and MongoDB technology are better. With PostgreSQL, all you need the database for is to save your data. This function on its own is not enough. The database and applications can become very slow. To debug you need to make the database query display information on your device. Some developers are not experienced in developing databases. This is especially difficult for junior software developers, and they often need more experience to be able to deal with that aspect. View full review »
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
455,962 professionals have used our research since 2012.
Director at a tech services company with 1-10 employees
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. View full review »
Mina Riad
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
It still needs to be more mature and have some backup feature. We are normally dealing with Oracle's data, and we have very strong online tools to back up the data and do other things. PostgreSQL still needs to do more in this area as well as in the high availability area. There are many external tools that you can use for PostgreSQL's high availability, but there is no embedded tool within PostgreSQL for high availability. It could have a feature similar to Oracle for working on a distributed system. It can have some scripts to improve the monitoring and some tools to do performance analysis. We have a workaround for most of such requirements except for the support for a distributed system, which is very difficult to have. This area should be included in the core of the database itself. View full review »
IT Innovation & Strategy | Real Estate Strategy, Asset Management & Enabling Functions | GSUS at a comms service provider with 10,001+ employees
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. View full review »
Diego Rosales
Implementation Engineer at aldaris spa
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. View full review »
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
455,962 professionals have used our research since 2012.