PostgreSQL has complete SQL dialects and is useful for writing sophisticated and complex queries. We have experience with Oracle database. My partner is experienced in DDA and he writes sophisticated SQL queries. The solution helps to get the job done in the best possible way.
In today’s age, most developers do not have strong SQL knowledge or language command. They find it difficult to write even a SQL statement. These developers write cool queries which perform badly on the database end.
As DBAs, we constantly urge the developers not to write bad queries, help them learn more, and write placebo commands.
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.
System/Security Engineer at CACI International Inc
Consultant
2021-12-04T04:30:12Z
Dec 4, 2021
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.
System Architect at a university with 1,001-5,000 employees
Real User
2021-10-22T09:13:54Z
Oct 22, 2021
Postgres is rock solid when deployed according to best practices as documented by the PostgreSQL community. When it's installed correctly, PostgreSQL is an enterprise-grade solution.
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.
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.
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 most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use.
PostgreSQL is a versatile and reliable database management system commonly used for web development, data analysis, and building scalable databases.
It offers advanced features like indexing, replication, and transaction management. Users appreciate its flexibility, performance, and ability to handle large amounts of data efficiently. Its robustness, scalability, and support for complex queries make it highly valuable.
Additionally, PostgreSQL's extensibility, flexibility,...
We often use PostgreSQL for operations monitoring because we are a manufacturing company.
The product is easy to use and works fast for relational databases.
Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful.
PostgreSQL has complete SQL dialects and is useful for writing sophisticated and complex queries. We have experience with Oracle database. My partner is experienced in DDA and he writes sophisticated SQL queries. The solution helps to get the job done in the best possible way.
In today’s age, most developers do not have strong SQL knowledge or language command. They find it difficult to write even a SQL statement. These developers write cool queries which perform badly on the database end.
As DBAs, we constantly urge the developers not to write bad queries, help them learn more, and write placebo commands.
The stability and the abundant community support resources.
Scalable, stable, and easy to manage database system, with a straightforward installation.
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.
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 very scalable and comes with a bonus: no licensing issues as you scale with your databases.
The solution is scalable, it is very good.
Initial setup is simple.
Postgres is rock solid when deployed according to best practices as documented by the PostgreSQL community. When it's installed correctly, PostgreSQL is an enterprise-grade solution.
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.
PostgreSQL is stable. It's available, stable, and reliable.
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.
The solution provides complete support in terms of the SQL dialect and behaves nicely when it comes to transactions.
The product is very similar to the SQL Server.
The most valuable feature is the performance.
The solution is quite stable.
It's a standard reliable database management system.
The solution has many valuable features such as it easy to use and the interface is intuitive.
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.
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.
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 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.
What I like is that it's quite powerful in terms of performance.
The product is quite flexible.
With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things.
Clustering will be the number 1 feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance.
The database has excellent performance.
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.
The most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use.