Coming October 25: PeerSpot Awards will be announced! Learn more
2020-11-06T07:13:00Z
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
  • 0
  • 8

What needs improvement with PostgreSQL?

Please share with the community what you think needs improvement with PostgreSQL.

What are its weaknesses? What would you like to see changed in a future version?

27
PeerSpot user
27 Answers
SS
Software Engineer at DXC
Real User
Top 5Leaderboard
2022-02-16T09:06:03Z
16 February 22

They should make PostgreSQL more secure. It's stable, but from a security point of view, it still needs improvement.

Moises Nájar - PeerSpot reviewer
Executive Director at Extware Consulting
Real User
Top 5
2022-01-25T17:22:46Z
25 January 22

PostgreSQL could improve by providing a geographical solution for tracking trucks and people in the field. They might already have features similar to this and I have not found them. I haven't done research about this topic.

DE
System/Security Engineer at a tech services company with 10,001+ employees
Real User
Top 5
2021-12-04T04:30:12Z
04 December 21

They need to have a better graphical interface. There is a tool called pgAdmin 4 that they use, which is free. It is written in Java, and it is slow. They need to have a better product that is similar to Toad for Oracle, but, of course, it is hard to get something that's really great and free. Other than that, it is great.

AA
Projects Manager at Emery Investments
Real User
Top 10
2021-12-02T13:57:00Z
02 December 21

As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself. I would like to see it become more user-friendly.

RS
Head Channel and Capacity at a computer software company with 201-500 employees
Real User
Top 5
2021-12-02T11:09:25Z
02 December 21

PostgreSQL could improve by adding data warehousing tools.

NB
Senior Software Engineer at Endava
Real User
Top 5Leaderboard
2021-11-30T14:04:00Z
30 November 21

In the next release, I would like to see better integration with other platforms.

Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
634,550 professionals have used our research since 2012.
NP
System Architect at a university with 1,001-5,000 employees
Real User
2021-10-22T09:13:54Z
22 October 21

I'd like to see better memory management. I think that that's one of the few areas that Postgres does not handle as well as MySQL does or did.

SJ
Director Of Sales Marketing at a energy/utilities company with 10,001+ employees
Real User
Top 5Leaderboard
2021-10-21T07:46:43Z
21 October 21

The performance of PostgreSQL could improve.

Ruben Conti - PeerSpot reviewer
Owner at Intersoftware sas
Real User
Top 5
2021-10-05T20:41:00Z
05 October 21

There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time. We haven't tried the latest version, but they're supposed to add some of the most important things.

SP
IT Systems Administrator at a transportation company with 51-200 employees
Real User
Top 5
2021-08-26T14:17:25Z
26 August 21

There are some products out there that have a slightly different method of implementation for the SQL language. Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. I would probably like to match all of those products together. It is just down to the functionality. For example, Oracle has a number of options within SQL that are outside of what you would class as the SQL standard. PostgreSQL misses some of those, but PostgreSQL does other things that are better than what Oracle does. I would like to merge those two products so that there is a certain amount of functionality in a single product.

PG
Subdirector - Digital Products and Services at a media company with 501-1,000 employees
Real User
Top 20
2021-08-17T15:04:30Z
17 August 21

The solution could be improved through an upgrade to the latest version. A better graphic user-interface would be nice to see. There is nothing I particularly dislike about the solution. The data propagation in master-slave configurations would be a good example. This is one of the features that I understood the least, yet we have it working and use it to propagate from the content management system database to the multiple publishing databases. This said, I would like this propagation feature to be simplified for new users and to come with better explanation. However, I will refrain from giving criticism on this point, as I do not know if they already handled this in the last version. Overall, I have only praise for the solution. I cannot point to anything in particular that we are missing out on at the moment. What comes to mind are features that I have yet to try, although I don't have any wish lists for PostgreSQL at the moment. I don't know how it stacks up when it comes to the importing and exporting of data. For databases involving this, we just make use of Redshift, which is verified from PostgreSQL and developed by Amazon.

MS
Head of Technical Support at a real estate/law firm with 51-200 employees
Real User
Top 5Leaderboard
2021-07-09T11:23:41Z
09 July 21

If you look at overall PostgreSQL, it could be easier to use. I'm not yet able to use all of the features on the product at this time. I'm not really able to customize it. The integration could be easier. SQL Server has an easier integration process, for example, as a comparison. With Postgres, you can run it in Windows Server, however, there are other things that you have to run. The product is more for technical people. For example, SQL Server is for anybody. Even newer users can just pick it up and learn from it and mess with it and run it. You can't do that with PostgreSQL. It has more of a learning curve. YOu need more training and documentation.

RP
IT Specialist at a government with 1,001-5,000 employees
Real User
Top 5
2021-06-18T05:31:41Z
18 June 21

The solution could improve the integration.

Dimitris Iracleous - PeerSpot reviewer
Lead Technical Instructor at codehub
Real User
Top 5
2021-06-15T14:22:28Z
15 June 21

The performance is too low, although we haven't tested for this. The interface climate could be better. There are many third party ones that we can use so it would be nice to see more support with the database diagrams.

hugodpereira - PeerSpot reviewer
Computer engineering student at a educational organization with 501-1,000 employees
Real User
Top 5Leaderboard
2021-05-19T14:16:03Z
19 May 21

The interface could be much better. Maybe it took a little bit longer to understand the menu options and so on. On top of that, it's a web interface. It makes it uninteresting to look at. It's not so appealing as the options that Microsoft offers. It's a separate program that works separately and you don't mess with the browser. It works okay, you can do what you need to do, however, it's not, in my opinion, so professional-looking. That said, it's open-source so I can understand that they prefer to do it like that. The installation process could be better organized. The stability could be better. they release new versions all the time and they aren't quite as stable as we'd like them to be.

KR
Information Technology Administrator at a tech services company with 51-200 employees
Real User
Top 5Leaderboard
2021-04-10T07:23:40Z
10 April 21

Instead of the installation agent downloading all the packages for the install, it should allow the user to download the packages separately on their own to do the install. In a future release, the installation agent should take less time to create all the databases, especially the small Oracle databases that I was using.

Ariful Mondal - PeerSpot reviewer
Consulting Practice Partner - Data, Analytics & AI at FH
Real User
ExpertModerator
2021-03-03T21:38:03Z
03 March 21

It would be good to have machine learning functionality in this solution, similar to Microsoft SQL Server and other solutions. Machine learning capability for a basic level or a common user would be useful. It can also have good reporting capabilities.

JP
Principal Engineer at a manufacturing company with 201-500 employees
Real User
2021-02-14T14:42:23Z
14 February 21

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.

Faustine Chisasa - PeerSpot reviewer
Engineering Supervisor- Corporate Data Solutions and Services at TZ Telecoms. Corporation
Real User
Top 5Leaderboard
2021-02-04T21:04:00Z
04 February 21

PostgreSQL uses high memory compared to its counterparts when a highly demanding load is involved, especially one that makes many concurrent connections to the database. Like many other databases, the tuning is manual through a configuration file. It would be useful if the database engine could detect the specifications of the machine in which it is installed and so bring some levels of auto-tuning. PostgreSQL replication support isn't so straightforward for multi-sources and master replicas. It will be great if native support of those replication modes become available in the future.

Karel Van Der Walt - PeerSpot reviewer
Data Architect at ACPAS Loan Management Software
Real User
Top 5
2021-01-23T14:46:33Z
23 January 21

PostgreSQL doesn't have a feature for temporal SQL, which is useful for selecting version(s) of a row. Specifically the syntax SELECT FROM

FOR SYSTEM_TIME AS OF ... This feature should be included in PostgreSQL. This feature is available in MariaDB, SQL Server, Oracle Database, and DB2.

LW
IT Innovation & Strategy | Real Estate Strategy, Asset Management & Enabling Functions | GSUS at a comms service provider with 10,001+ employees
Real User
2021-01-13T22:09:33Z
13 January 21

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.

Kaan Çelik - PeerSpot reviewer
Data Analytics and Business Intelligence Manager at a computer software company with 201-500 employees
Real User
Top 5
2020-12-27T09:14:05Z
27 December 20

The pricing could be better.

KA
Chief technical officer at a healthcare company with 51-200 employees
Real User
2020-12-12T18:23:00Z
12 December 20

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.

Jason Tumusiime - PeerSpot reviewer
Software Developer at a healthcare company with 1-10 employees
Real User
Top 20
2020-12-07T17:50:00Z
07 December 20

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.

RM
Director at a tech services company with 1-10 employees
Real User
Top 20
2020-11-26T08:52:22Z
26 November 20

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.

MR
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
Real User
Top 5Leaderboard
2020-11-25T20:46:48Z
25 November 20

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.

Diego Rosales - PeerSpot reviewer
Implementation Engineer at aldaris spa
Real User
Top 20
2020-11-06T07:13:00Z
06 November 20

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.

Related Questions
Netanya Carmi - PeerSpot reviewer
Content Manager at PeerSpot (formerly IT Central Station)
Dec 12, 2021
Which is better and why?
See 1 answer
Dovid Gelber - PeerSpot reviewer
Tech blogger
12 December 21
PostgreSQL was designed in a way that provides you with not only a high degree of flexibility but also offers you a cheap and easy-to-use solution. It gives you the ability to redesign and audit your database with great ease. This allows you to have the kind of database that you need on a case-by-case basis. Instead of being locked into an inflexible database format, you are in control and dictate exactly what format the database will take at any given time. You can easily manipulate it, which means that you will be able to use PostgreSQL in the way that will help your organization the most. PostgreSQL is also pretty easy to use. Its designers made it so that you don’t have to have an extensive technical education to use it. It is pretty intuitive and has excellent documentation to answer any employee questions. Furthermore, PostgreSQL also offers you a cheap solution whose hosting and maintenance can be handled totally in-house. PostgreSQL’s open-source nature makes it extremely cheap to implement. Resources that might have been spent on setting it up can now be saved and redirected to areas of greater need. Furthermore, the program has two different download options. It can either be downloaded and used on-site or it can be downloaded to the cloud. Both of these allow you to be totally independent. You can host it from your headquarters or access it from anywhere you choose. Firebird SQL offers you the ability to scan your database code and search it for many types of issues. It can also compile reports based on any of the problems that it may find. However, it lacks the flexibility that PostgreSQL offers. It cannot be customized in the same way, which leaves you with fewer options. Conclusion While Firebird SQL is a fairly competent product, we found PostgreSQL to be superior. PostgreSQL’s greater flexibility and dual download options make it the more robust solution.
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
Mar 02, 2022
Hi, We all know it's really hard to get good pricing and cost information. Please share what you can so you can help your peers.
2 out of 18 answers
MR
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
25 November 20
It is free. There is no license on it.
RM
Director at a tech services company with 1-10 employees
26 November 20
I'm not sure what the licensing costs for the solution are.
Related Solutions
Download Free Report
Download our free PostgreSQL Report and get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
DOWNLOAD NOW
634,550 professionals have used our research since 2012.