IT Central Station is now PeerSpot: Here's why

PostgreSQL Valuable Features

Jason Tumusiime - PeerSpot reviewer
Software Developer at a healthcare company with 1-10 employees

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 »
PG
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 »
NP
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 »
Buyer's Guide
PostgreSQL
July 2022
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
621,548 professionals have used our research since 2012.
Faustine Chisasa - PeerSpot reviewer
Engineering Supervisor- Corporate Data Solutions and Services at TZ Telecoms. Corporation

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 »
Kaan Çelik - PeerSpot reviewer
Data Analytics and Business Intelligence Manager at a computer software company with 201-500 employees

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 »
MS
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 »
DE
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 »
NK
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 »
SP
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.

View full review »
KA
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 »
hugodpereira - PeerSpot reviewer
Computer engineering student at a educational organization with 501-1,000 employees

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.

View full review »
EK
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 »
Ariful Mondal - PeerSpot reviewer
Consulting Practice Partner - Data, Analytics & AI at FH

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 »
Moises Nájar - PeerSpot reviewer
Executive Director at Extware Consulting

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 »
RM
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 »
MR
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 »
Hardik  Parashar - PeerSpot reviewer
Associate Data Engineer at Digit Insurance

This solution is very good for getting data. It is very useful for reporting purposes. We also use one of the tools of IBM Cognos for reporting purposes.

For small-scale setups, the solution is stable.

The solution is open-source and free to use.

View full review »
LW
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 »
Ahmed-Ramy - PeerSpot reviewer
CEO at TMentors

We've been happy with the capabilities. It doesn't have the issues that MySQL does have. 

The community support and the open-source community for it are good.

It's a stable solution.

We do find the product can scale. 

View full review »
Karel Van Der Walt - PeerSpot reviewer
Data Architect at ACPAS Loan Management Software

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 »
SS
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 »
Dimitris Iracleous - PeerSpot reviewer
Lead Technical Instructor at codehub

The solution is quite stable. This said, it's more prestigious to use MySQL, although we haven't made comparisons for safety and reliability.

View full review »
Ashif  Shaikh - PeerSpot reviewer
Senior Database Administrator at a tech services company with 501-1,000 employees

Postgres SQL is quite a good database.

The performance is good.

View full review »
PB
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 »
RU
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 »
Florent ADODO - PeerSpot reviewer
IT Assistant at Hotel 2 Fevrier

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 »
MA
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 »
SJ
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 »
KR
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 »
Sundaresan Subramanyan - PeerSpot reviewer
Founder and Managing Director at Analytic Brains Technologies Private Limited

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 »
JP
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 »
PA
Project Manager at a comms service provider with 201-500 employees

It is easy to use.

View full review »
Diego Rosales - PeerSpot reviewer
Implementation Engineer at aldaris spa

The most valuable features are:

  • The price
  • Stability 
  • It is scalable and is used by our clients in small business environments
  • It is a simple product to use.
View full review »
RP
IT Specialist at a government with 1,001-5,000 employees

The most valuable feature is the performance.

View full review »
NB
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 »
VR
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 »
Buyer's Guide
PostgreSQL
July 2022
Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: July 2022.
621,548 professionals have used our research since 2012.