PostgreSQL Valuable Features
Clustering is the number one feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance. MySQL has to be licensed, but PostgreSQL does all the same things. I have deployed both. You benefit from the way you use it.View full review »
Subdirector - Digital Products and Services at a media company with 501-1,000 employees
We are increasingly using their support for JSON, which we find to be very complete, something I made use of in the past. The solution provides complete support in terms of the SQL dialect and behaves nicely when it comes to transactions. One can change the database structure transactionally. This is one of the few databases that allows this. I like it.
The solution is comparable in sophistication with that of Oracle. Each product has a few things less and more than the other. We also like that the solution is open source. We have good performance with a small footprint. It's rather nice. It's very robust.View full review »
System Architect at a university with 1,001-5,000 employees
It's an open-source database, so we can see the code used for that database. Also, we use it because it's lightweight, easy to deploy, and scalable for particular projects, especially if we're dealing with something that requires a Docker deployment.View full review »
The most valuable feature is support for the Timescale DB extension. We managed to reduce the storage space needed to 10% of the original size, without affecting data integrity, and we significantly improved the performance.
The database engine is easy to manage, the tuning is friendly, and the integration with supported extensions is friendly too.
The database engine is free and open-source, too. Since we did everything internally, it has greatly reduced the costs of setting up our systems.
It also supports diverse kinds of replication, which is crucial for a high availability environment that we plan to set in the near future.View full review »
The solution is very easy to use. You don't have to be extremely knowledgeable or technical to take advantage of it.
The product is quite flexible.
We find it to be one of the cheapest options on the market. It's not expensive to use.View full review »
Head of Technical Support at a real estate/law firm with 51-200 employees
Overall, the solution is very good.
The solution is free to use.
It is easy to use and quite stable. It's as robust as Oracle, however, SQL Server is easier to use I think.
The product is very similar to the SQL Server.
The installation is quite fast.View full review »
System/Security Engineer at a tech services company with 10,001+ employees
The main value is that it is open source, which means it is free. Our organization has the initiative to go to open source to cut down on cost. Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. So, there is a big push to go to Postgres.
It is a great product, and it just works.View full review »
Senior IT Manager at a pharma/biotech company with 1-10 employees
The solution is quite stable and very reliable.
On the cloud side of the product, the solution scales quite well.
The initial setup is quick and easy.View full review »
IT Systems Administrator at a transportation company with 51-200 employees
It is a pretty comprehensive database system. Its performance is good, and it does what it is supposed to do. It also integrates very well.
Chief technical officer at a healthcare company with 51-200 employees
I can use Unity Kinematic. It's not easy but you can create a multi-tenant database in Postgres and I think it's a must-have in software development. With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things.View full review »
The solution is open-source and therefore free to use.
You can do the same actions as you can with the SQL Server.
It's a standard reliable database management system.
The solution comes with an option to work in dark mode, which I appreciate.
Sr Lead Data & Information Architect at a pharma/biotech company with 5,001-10,000 employees
It's easy to install in Oracle and it's quite good to use for the canned database for content applications.
The solution is quite a good database.
Their pricing is very good.
The solution is very easy to use.
It's quite scalable.
The stability is good.
The installation is simple.View full review »
It is very useful for both structured and unstructured data. You can store unstructured and structured data in PostgreSQL. It is easy to use. You can easily manage things through PostgreSQL Admin.
It is cost-effective. Its on-premise version is free. It is agnostic of on-premise or cloud. You can install it on the cloud or on-premises. It is available with all clouds, and you can also install it on desktop or Windows Servers.View full review »
PostgreSQL makes it very adaptable to several descriptions of a record. Instead of having several tables or several relations for one entity, I can adapt this entity. It can be a multiform entity. For example, here in Mexico, a company and a person can be sold to us as a physical entity or a physical person.
Each of these entities has some things that are common, such as name and registration for an identity for the ISR in the US and in Mexico's it is called the SAT. We have to have different characteristics for each of them. In PostgreSQL, I can easily create a field for this moral person, with a different set of fields. It allowed me to have some plasticity on each entity that I am describing. People that are working inside the company, have some requisites that are different from one position to another. This plasticity allows me to move it for every person that is inside the company. PostgreSQL allows me to do all of this will ease. This feature is called H store, it is wonderful.
I'm using the replication that they have inside, in case one company may wish to have the solution on-premise, they can have the replication feature that is already embedded and it's free. You don't have to pay again for that solution.View full review »
Director at a tech services company with 1-10 employees
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.View full review »
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
It is easy to install and easy to manage. There is no license on it, so it is free.
There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre.View full review »
IT Innovation & Strategy | Real Estate Strategy, Asset Management & Enabling Functions | GSUS at a comms service provider with 10,001+ employees
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.View full review »
The built-in code procedural language is the most valuable. It has a built-in layer for code procedures.
Its installation is very easy and quick, and it is free. It is also stable, and its performance is also good.View full review »
Software Engineer at a computer software company with 10,001+ employees
What I like most about PostgreSQL is its ease of management.View full review »
Postgres SQL is quite a good database.
The performance is good.View full review »
System Architect at a computer software company with 10,001+ employees
It's a useful solution, that can be widely used.
It is easy to use.
PostgreSQL has a large community.
The performance is good.View full review »
Senior Solutions Architect at a manufacturing company with 51-200 employees
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.View full review »
It is very simple to manage.
It is easy to use.
My main concern is that I can use it to connect with the interface. It is simple, it's good.View full review »
Senior DBA & IT Consultant at MA Consulting
I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable.View full review »
Director Of Sales Marketing at a energy/utilities company with 10,001+ employees
PostgreSQL is very easy to use. I have experience in Oracle SQL and PostgreSQL uses the same syntax which makes it is easy for me to develop.View full review »
Information Technology Administrator at a tech services company with 51-200 employees
The solution has many valuable features such as it easy to use and the interface is intuitive.View full review »
This is an open-source solution, operates at a high speed, and supports more than one SQL language.
It integrates with different platforms, the upgrades are quite fast and the solution keeps getting better.View full review »
Principal Engineer at a manufacturing company with 201-500 employees
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.View full review »
Project Manager at a comms service provider with 201-500 employees
It is easy to use.View full review »
The most valuable features are:
- The price
- It is scalable and is used by our clients in small business environments
- It is a simple product to use.
IT Specialist at a government with 1,001-5,000 employees
The most valuable feature is the performance.View full review »
Senior Software Engineer at a tech services company with 5,001-10,000 employees
This solution is very good and efficient in joining big tables. It also provides a lot of options that, from a developer's point of view, can be utilized in a project.View full review »
Full Stack Developer at a tech services company with 10,001+ employees
We are able to create many different types of jobs and items with this solution making it one of the most valuable features.View full review »