PostgreSQL Valuable Features

Chethan Rao S - PeerSpot reviewer
Software Engineer at Medflix

Compared to MySQL, Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful. Indexing is better in Postgre due to the algorithm it uses, such as B-tree indexing. 

Moreover, Postgres has a specific data type called JSONB, which stores JSON in binary format, resulting in optimized performance.

View full review »
KS
Senior Analyst Applications, Projects and Processes at ADVA Optical Networking Israel LTD.

PostgreSQL is very powerful, easy to manage, and has many features.

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 »
Buyer's Guide
Open Source Databases
March 2024
Find out what your peers are saying about PostgreSQL, Firebird, MariaDB and others in Open Source Databases. Updated: March 2024.
765,386 professionals have used our research since 2012.
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 »
Albert Lacerda - PeerSpot reviewer
Managing partner at Dynamis Informatica

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.

View full review »
SE
Software developer at MTNIrancell

The product is easy to use and works fast for relational databases.

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 »
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 »
Hazel P. - PeerSpot reviewer
Data Quality Engineer at Nidec Corporation

We often use PostgreSQL for operations monitoring because we are a manufacturing company.

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 »
it_user448206 - PeerSpot reviewer
Senior Application Programmer/Analyst, Team Lead at a university with 10,001+ employees

PostgreSQL has excellent support for many programming languages. We've been able to integrate it with Java, PHP, Perl and .NET without any issues. 

Replication is also working pretty good in a master to read only replica setup in AWS. 

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 »
it_user442602 - PeerSpot reviewer
Sr. Database Engineer at a non-tech company with 5,001-10,000 employees

Twice now, I have been involved in the decision by a company to migrate away from MS SQL Server to Postgres. The first time, it was simply a matter of scalability. Once you approach 10 TB of data, managing it in MSSQL becomes problematic. You reach limits on performance, backup/recovery and general maintainability. The second company that I assisted in performing this migration chose Postgres due to the TCO as well as the ability to scale the databases horizontally.

The feature that I find most useful (and in fact critical) is the extensibility of Postgres. We installed the extensions that were important to us and ignored anything that wasn’t useful. This allows us to maintain a highly customized configuration that is still able to be supported and maintained by third-party vendors.

View full review »
AM
Global Data Architecture and Data Science Director 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 »
Faustine Chisasa - PeerSpot reviewer
System Administrator at TZ Telecom Ltd.

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 »
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 »
NK
Senior IT Manager at Excelra

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 »
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 »
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 »
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 »
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 »
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 »
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 »
DI
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 »
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 »
it_user457323 - PeerSpot reviewer
Senior Database Engineer at a consumer goods company with 1,001-5,000 employees

The reliability, performance, and extensive list of features are what I think matter the most in a production environment.

View full review »
it_user456468 - PeerSpot reviewer
Senior DB Engineer at a university with 1,001-5,000 employees

For this question I will focus on our usage of PostgreSQL in the company. A great differentiator for this database, if compared with other providers, is its easy extensibility and the existence of data types that would fall in the category of NoSQL. In particular, HSTORE (key/value store) and JSON (documents). This feature makes it possible to combine the strengths of relational and non-relational artifacts. Specifically transactionality and indexing vs. hierarchical structures and flexibility.

View full review »
it_user457146 - PeerSpot reviewer
Co-Founder, CTO at a computer software company with 51-200 employees

Stability, compound & functional indexing, MVCC, transactional DDL, GIS extensions, recursive queries, common table expressions, materialized views, procedural languages, triggers, and excellent documentation. PostgreSQL feels more like a mature, feature-rich, performant data platform than a simple datastore (I'm looking at you MySQL & Mongo).

View full review »
it_user212523 - PeerSpot reviewer
TIBCO Middleware Architect & System Administrator at a tech services company with 1,001-5,000 employees

JSON support, especially the new JSONB data type is valuable . We used to have a mix of PostgreSQL and MongoDB to solve some of the complex problem around data schemas, now, we rely solely on PostgreSQL as our main datastore. Same flexibility with rock solid performance.

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 »
HP
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 »
JT
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 »
it_user494835 - PeerSpot reviewer
Founder and CEO at Shreeyansh Technologies | The Database Company
  • Integration with various programming languages
  • Partial indexes
  • Online backups/recovery
  • Replication
  • Hot standby
  • Cascading replication
  • Partitioning
  • Performance
View full review »
it_user86943 - PeerSpot reviewer
Senior Developer with 501-1,000 employees

PostGres is a fantastic modern RDBMS and its open nature allows you to get as low level as you need. You can define functionality, you can call from SQL and dig deep into the query planner with it's excellent explain functionality. The true open community is loaded with helpful people who believe in OSS. Every feature in PG is first, present, but secondly mature and just works. You may have bugs in your code but PGSQL will never be the cause of it.

View full review »
it_user234651 - PeerSpot reviewer
Senior Software Engineer, Technical Lead at a tech services company with 51-200 employees

PostgreSQL, especially the latest versions, comes with a very rich set of server side programming tools, while providing speed, data consistency and the transaction's coherence.

This is a very wide answer, but this large environment is providing fast solutions to various needs and I see this the main power.

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 »
KV
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 »
it_user383829 - PeerSpot reviewer
Founder and Business Intelligence Consultant at Know Solutions

It is easy grow it from a small environment to a large one.

View full review »
DZ
Developer at a tech services company with 11-50 employees
  • Stored Procedures
  • Full Text Search

One of our products crawls information from different web sites and then detects if some keywords are there based on a business logic. The business logic was programmed in Stored Procedures using Full Text Search to detect keywords that we wanted in the extracted text. Doing it this way, we keep the logic in the database and we only need to constructs need crawlers that feed the database with more text to process.

View full review »
it_user130935 - PeerSpot reviewer
President with 51-200 employees

It is fast, compact, flexible, and scalable. I like the fact it is not tied directly to a server OS, such as Microsoft SQL Server. Being open source it is very budget continuous for our clients.

View full review »
LR
Analista Funcional Líder at a government with 5,001-10,000 employees

PostgreSQL is an open source database, so there is no associated licensing cost for the software and we always have a new version easily available. It runs on all major operating systems, although I have always used it on UNIX platforms.

It also supports storage of binary large objects, including pictures, sounds, or video. It is highly scalable, both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate.

PostgreSQL runs stored procedures in a lot of programming languages (Java, Perl, C/C++, etc.). It includes many built-in functions from basic math and string operations to cryptography and Oracle compatibility. Triggers and stored procedures can be written in C and loaded into the database as a library. PostgreSQL uses a multiple row data storage strategy called MVCC to make PostgreSQL extremely responsive in high volume environments. Allow hot backups.

View full review »
it_user464529 - PeerSpot reviewer
CEO at a tech services company with 51-200 employees
  • Replication which enables us to use it for High Availability.
  • The Foreign Data Wrapper means we can integrate it, and provide interoperability with other databases.
  • Multi-master Replication helps us to distribute a database geographically without any hassle or performing maintenance for synchronization as this it is all done during the replication process.
  • PostgreSQL has a cleanly designed object basis RDBMS, so there are many opportunities to hook/plugin the PostgreSQL to get more functionalities and features.
View full review »
it_user488589 - PeerSpot reviewer
Technology Architect at Broadridge Financial Solutions

The graphical query plan analyzer in pgAdmin III tool is a very valuable feature. Fast bulk data load and extract feature using COPY is a very useful feature I have used.

View full review »
it_user457224 - PeerSpot reviewer
Partner - PostgreSQL support manager at a tech company with 51-200 employees

PostgreSQL provides the perfect combination of freedom, reliability, stability, security, performance, power, and ease of use. Freedom because it is the only world-class RDBMS not owned by a company. Reliability because anyone looking among the tons of public bugs from other RDBMSs such as Oracle or DB2, and does a comparison with PostgreSQL bugs, will feel confident. PostgreSQL is secured by design, with their own firewall for host-based authentication. PostgreSQL has a superior optimizer, the performance is very good in heavily loaded environments, and it has unique features such as partial indexes and full text search support with GIN indexes. Regarding power, PostgreSQL is a best of breed RDBMS in terms of SQL capability, procedural languages (many of them), programming language and datatypes support (including JSON) and async LISTEN/NOTIFY. Finally, the ease of use or autonomy, is a very valuable factor; PostgreSQL have all the configuration in two single files (postgresql.conf and the "firewall" pg_hba.conf).

View full review »
FA
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 »
it_user493518 - PeerSpot reviewer
Director of Operations / Senior Software Engineer at a computer software company with 51-200 employees

PostgreSQL does a great job with scalability and performance. Since we are using Django/Python – it works great with PostgreSQL as well. The current features that really help us are Full-Text Search, Array Fields, and JSON Fields.

View full review »
it_user457197 - PeerSpot reviewer
Senior PostgreSQL Database Adminstrator at a financial services firm with 51-200 employees

This database is highly reliable and offers excellent disaster recovery. In short, I can depend on it to be available and operational.

View full review »
it_user67833 - PeerSpot reviewer
Software Engineer at a tech vendor with 11-50 employees
  • Stability
  • Standard SQL for ease of development with pre-existing knowledge
View full review »
it_user434985 - PeerSpot reviewer
Sr. Database Architect at a tech vendor with 501-1,000 employees

PostgreSQL is the only open source and multi-functional database solution out in the market today. I have used it to replace Oracle (RDBMS) up to MongoDB (Document DB). Postgres has very rich SQL and NoSQL features that gives it a special place in database industry. It’s easy configure and manage features helped to increase adoption in last decade or so.

View full review »
it_user254172 - PeerSpot reviewer
Senior Consultant / Manager Technical Operations at a tech consulting company with 501-1,000 employees
  • Security
  • HA and DR
  • Performance
  • Maintenance
View full review »
it_user271512 - PeerSpot reviewer
Manager at a tech services company with 51-200 employees

The most valuable features are a good feature set, understandable, and good tuning features. It is, also in our experience, the best open source GIS enabled database, with good support from other open-source tools.

The product has easy installation procedures for the OSes we are working with and gives also a good possibility to tune the database for the given usage.

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 »
DM
Developer at a comms service provider with 51-200 employees
  • Free and open-source RDBMS, with a permissive license
  • ACID compliance
  • Multi-version concurrency control
  • Custom data types
  • Array data types
  • PL/Python stored procedures
View full review »
it_user140712 - PeerSpot reviewer
Consultant at a tech consulting company

Strong enforcement of data types, because it can catch many errors and mistakes and protects data. Standard conformance, because in the end you are not locked to single vendor.

View full review »
PA
Project Manager at a comms service provider with 201-500 employees

It is easy to use.

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 »
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 »
it_user249057 - PeerSpot reviewer
Software Engineer at a tech services company with 51-200 employees
  • Very good indexing solutions, especially for arrays and text search on large quantities.
  • Very good behavior on large databases (>800GB) and large tables.
  • Datatypes - support for vectors, XML, JSON, UUID and the functions and operators for them are very useful.
  • Programming languages - I deeply appreciate the extensibility of the server to allow more than one language for scripting functions. We mostly use PL/SQL, but recently I've tried PL/v8 and was astonishing to see that it works.
  • Execute with Query Parameters is a big plus for us as there are no type conversions needed to run dynamic queries reducing the run time by approximately 25%
  • There is a huge amount of community interest in developing and supporting the product.
View full review »
it_user457251 - PeerSpot reviewer
Data Architect at Blue Treble Solutions

In my experience, the data quality and extensibility are valuable.

View full review »
it_user441456 - PeerSpot reviewer
Senior Database DevOps Engineer at a tech services company with 1,001-5,000 employees

PostgreSQL is probably the most SQL-standard-compliant RDBMS on the market. It also goes way beyond standard relational paradigm combining key-value stores, arrays, and columnar stores into a single engine. With the introduction of Foreign Data Wrappers it also enables connecting various different data sources to the database, so it's possible to have, for example, a CSV file-backed foreign tables or to import a MSSQL schema into PostgreSQL.

View full review »
it_user268557 - PeerSpot reviewer
Chief Data Officer at a university with 5,001-10,000 employees

There are many valuable features, but the most valuable to me are Windows functions, Python scripting, and the fact it has a good PGSQL language.

View full review »
it_user252288 - PeerSpot reviewer
Software architect at a tech services company with 51-200 employees

Many supported features out of box like fulltext search, partitioning, easy replication - slony, pgpool-II and streaming wal and additional features such as JSON, XML, arrays in columns, and many extensions for it as PostGIS.

View full review »
it_user127413 - PeerSpot reviewer
Director GIS/Analytics/IT at a non-profit with 501-1,000 employees

Speed and price, it’s fast and reliable, and free.

View full review »
it_user306153 - PeerSpot reviewer
Senior Programmer at a tech services company with 51-200 employees
  • Easy to use
  • Vastl documentation
  • Tough product
View full review »
it_user298746 - PeerSpot reviewer
NOC Manager with 51-200 employees

The product is free, which is a huge benefit. There are options to create clusters and maintenance on the databases is easy and fast. The management studio with product is create and intuitive.

View full review »
it_user241635 - PeerSpot reviewer
DevOps Engineer at a transportation company with 51-200 employees

By far indexes is the most useful and robust feature. Also, the query optimization engine is simply great. It is very complete, clear and useful documentation, forums and diverse information channels.

View full review »
it_user184266 - PeerSpot reviewer
Database Expert at a tech services company with 51-200 employees

The use of extensions for integration with different databases is valuable.

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 »
RP
IT Specialist at a government with 1,001-5,000 employees

The most valuable feature is the performance.

View full review »
it_user437376 - PeerSpot reviewer
PostgreSQL Database Administrator at a tech services company with 51-200 employees

In my experience, the most valuable features of PostgreSQL are streaming replication, rich indexes support, extensibility and NoSQL features such as hstore and JSONB. This features are very mature and stable, we use them in many projects, they're predictable, always work as expected and without problems.

View full review »
it_user315483 - PeerSpot reviewer
Programador - Analista at a program development consultancy with 501-1,000 employees

Common Table Expressions(CTEs). It's powerfull, easy to write and read and very flexible.

View full review »
it_user308454 - PeerSpot reviewer
Sysadmin at a tech services company with 51-200 employees

It is an open source solution and that is a database engine very powerful. Besides it is highly configurable. I prefer PostgreSQL over MySQL or MariaDB because you can create several databases with many schemas and create roles like owners, and not only grants over tables, or procedures. On the other hand its very easy and intuitive to administrate the connections by hosts, databases, and roles.

View full review »
it_user360699 - PeerSpot reviewer
Platform Developer at a tech vendor with 51-200 employees

Overall it is an excellent RDBMS and it is easy to use and administer. In PostgreSQL 9.5 the table inherent Foreign Data Wrappers(FDW) is available. This extension is available for most databases which makes building server federation very possible.

In 9.5 support for FDW was improved which means it is now possible to import a complete foreign schema. Foreign Table inheritance is now supported as well. They have also improved the Foreign Query optimization since v9.4. Lastly, It has low maintenance requirements so not much has to be done as far as DBA tasks go.

View full review »
it_user448368 - PeerSpot reviewer
DBA / ETL Developer / Consultant at a marketing services firm with 1,001-5,000 employees

It has the same features as paid-for databases such as Oracle and SyBase.

View full review »
it_user203334 - PeerSpot reviewer
Technical Lead with 1,001-5,000 employees

PostgreSQL gives you much more flexibility because it's open source.

View full review »
it_user246798 - PeerSpot reviewer
Director of Client Integration at a financial services firm with 51-200 employees

The h-stores are very powerful for handling collections of key-value pairs. The query syntax and functions are well documented and easy to use.

View full review »
NB
Software Architect at AIOPS group

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 »
it_user457314 - PeerSpot reviewer
Sr. Oracle and PostgreSQL DBA at a consumer goods company with 1,001-5,000 employees

Open source products represent no cost to the organization and the basic features are sufficient to fulfill our needs.

View full review »
it_user210627 - PeerSpot reviewer
Computer Science Teacher at a educational organization with 501-1,000 employees
  • Confidentiality
  • Integrity
  • Availability
  • Bug free

I like to work with a piece of software that is bug free and doesn't required to be launched in order that users will find a couple of bugs in the coming weeks and that the company has to fix it.

View full review »
it_user348702 - PeerSpot reviewer
DWH Analyst at a financial services firm with 1,001-5,000 employees

The reason why I started with PostgreSQL database was the (geo)spatial support. GIS software, such as Quantum GIS (QGIS) or PostGIS, is a good example of where you are able to use this feature. Nowadays, the solution is on a competitive level to other commercial software solutions, especially for small companies.

View full review »
it_user234753 - PeerSpot reviewer
Team Lead ETL at a tech services company with 51-200 employees

JSON data support is most valuable to me as it saves design and maintenance time. It is a very safe and stable solution.

View full review »
it_user250818 - PeerSpot reviewer
Owner with 51-200 employees

It can handle complex SQL queries.

View full review »
KopanoRamaphoi - PeerSpot reviewer
Consultant at Rpc Data

The solution has many valuable features such as it easy to use and the interface is intuitive.

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 »
it_user514974 - PeerSpot reviewer
CTO at a tech vendor with 51-200 employees

The new JSON data type that allows to use some NoSQL-like functionality.

This is great because brings some of the most valuable features of NoSQL databases to relational databases. You can have a column with JSON datatype and then query that JSON inside your regular SQL queries. 

So basically, you are mixing together the relational and NoSQL world in just one database, one powerful solution. 

View full review »
it_user495012 - PeerSpot reviewer
Chief Data Architect at a tech company with 51-200 employees
The features we use most often are:
  • PostgreSQL streaming replication
  • PITR-based backups
  • CTE SQL
  • SQL windowing functions
View full review »
it_user212502 - PeerSpot reviewer
Technical Account Manager with 1,001-5,000 employees
  • Stability
  • Performance
  • Ease of administration
View full review »
it_user262230 - PeerSpot reviewer
Front-End Developer at a financial services firm with 501-1,000 employees

PostgreSQL provides a lot of valuable documentation and there's widespread usage of it.

View full review »
it_user268431 - PeerSpot reviewer
Specialist of Information Security at a transportation company with 1,001-5,000 employees

I had many problems on v8.3 when I needed to use SSL client certificate authentication but on version 8.4 my problem was resolved, I’m an information security specialist and my focus is it so all features about security for me is important and the security on PostgreSQL after 8.4 was good.

View full review »
it_user330576 - PeerSpot reviewer
Senior Software Engineer at a tech services company with 1,001-5,000 employees

It allows people to use whatever multiple procedural language they are trained in, such as Java, Python, Pearl, or C and it is not limited to PL/SQL or PGSQL. Also, I love the PostGIS extension and I do not know of any other product like this.

View full review »
it_user280329 - PeerSpot reviewer
CTO at a tech services company with 51-200 employees
  • Updatable views (also over multiple tables)
  • Array and JSON fields
  • Point-in-time backup and recovery (WAL files archiving)
View full review »
it_user389811 - PeerSpot reviewer
Co-Founder, Technical Manager, Consultant at a hospitality company with 51-200 employees
  • Flexible stored procedures and external functions
  • WITH clauses
  • Partitioning
  • Large open-source extensions, modules and software helpers eco-system
View full review »
DR
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 »
it_user219786 - PeerSpot reviewer
Founding Partner at a tech vendor with 1-10 employees

It supports full text search, and windows functions.

View full review »
it_user312354 - PeerSpot reviewer
Software Architect and Senior Technology Consultant at a tech services company with 51-200 employees

PostgreSQL is a stable RDBMS. It's free, and supports standard SQL.

View full review »
it_user209280 - PeerSpot reviewer
Senior Developer at a tech services company with 1,001-5,000 employees
  • Hassle-free, low maintenance operation
  • Free
  • SQL compliance
  • Slot-based streaming replication - live and purposely delayed are available
  • Robustness
  • Performance
  • Low maintenance
  • Decent Windows management GUI
  • Cross-platform
View full review »
it_user373887 - PeerSpot reviewer
Senior Software Engineer at a tech services company with 51-200 employees

HStore is a data type in PostgreSQL database that gives the flexibility for storing sets of key/value pairs which is quite an awesome feature.

View full review »
it_user5931 - PeerSpot reviewer
Developer at a university with 51-200 employees
Before PostgreSQL, I am an avid user of MySQL for a long time. When I began my masters in a renowned school, I was introduced to PostgreSQL and started to like it. Here are the few things I have loved about Postgres: • It is free and compatible in all platforms • It performs very quickly and can outperform Oracle, SQL server and IBM DB2 • It uses SQL windowing functions which are rarely found in other open source database platforms • It uses CREATE EXTENSION which can easily extend without changing the database structure and no code compilation • It has multiple programming languages such as SQL, PL/pgSQL, PL/Perl, PL/Python, PL/Java, and PL/R etc. • The custom type support is very easy to use and very sophisticated which competes Oracle in terms of performance View full review »
it_user439254 - PeerSpot reviewer
Expert Web Developer at a tech vendor with 501-1,000 employees

It works great out-of-the-box and it opens up many opportunities in project development.

I first install the regular version. I only configure complex things when they are needed.

View full review »
it_user494907 - PeerSpot reviewer
Big Data Consultant at a tech services company with 1,001-5,000 employees
I have not used any enterprise PostgreSQL product. I have only used the open-source version of PostgreSQL. I like the following features:
  • Locking: Tables very rarely get locked, while with MySQL, it’s a frequent problem.
  • Easy backup and restore
  • Reporting uses Windows functions / aggregates function
  • Partitioning
View full review »
it_user220542 - PeerSpot reviewer
Database Engineer at a financial services firm with 1,001-5,000 employees

It allows us to have an alternative solution to licensed DB's.

View full review »
it_user145641 - PeerSpot reviewer
Business Analyst at a transportation company with 1,001-5,000 employees
Backend: 64-bit large objects, Cascading streaming replication, Serializable Snapshot Isolation; Performance:GIN Index performance and size improvements; Security: SSPI authentication via GSSAPI; list goes on... View full review »
it_user89940 - PeerSpot reviewer
Database Expert with 201-500 employees
The SQL is very close to the standard, the richness of of procedural languages and the strong attitude to the data reliability. View full review »
it_user1227 - PeerSpot reviewer
Tech Support Staff at a tech company with 51-200 employees
Out of all the open source database applications available, PostgreSQL is among the best DB storage engines with a single unified database server unlike MySQL which supports multiple storage engines for storing the data. PostgreSQL was specifically designed and developed with a focus on features and standards whereas MySQL was designed with a focus on speed. So, if you are looking for a large number of features and support for various standards, then PostgreSQL is the answer. PostgreSQL supports scalability on write intensive tasks. It also supports asynchronous commit, which is generally missing from other similar DB applications. It is fully ACID compliant. View full review »
it_user183585 - PeerSpot reviewer
BI Expert at a consultancy with 501-1,000 employees

GIS function. Geography is a very important function/dimension for our f. Postgres helps analyse that easily.

View full review »
it_user12048 - PeerSpot reviewer
Digital Development Engineer at a comms service provider with 1,001-5,000 employees
  • It's open source product not need to license, so economic
  • It provides a graphical interface (pgAdmin) simple, intuitive and efficient
  • Simple installation 
  • It does not consume a lot of resources
  • Really suitable for business n-tier solutions
  • Rich documentation
  • An interactive community
View full review »
it_user677721 - PeerSpot reviewer
Information Technology Technician at a tech vendor with 51-200 employees
  • Robust backup and recovery integration.
  • Follows ANSI SQL.
  • opensource
  • easy to integrate with applications and high level programming languages such as; python, ruby, java, C, perl, php...
View full review »
it_user10449 - PeerSpot reviewer
Developer Advocate (PaaS Dust Spreader) at a tech vendor with 5,001-10,000 employees

The spatial extension, PostGIS, is amazing and probably the gold standard. I also like the Key-Value column type and the JSON column type. Apart from this, it has all the other features you will need in an RDBMS and then some. It has a vibrant FOSS community with a great license and it has plenty of books and documentation

View full review »
it_user434967 - PeerSpot reviewer
Staff System Admin at a tech company with 5,001-10,000 employees

From our use of it, its stability and performance are the best features. The fact that there's no downtime and that it functions quickly are very important to our workflow and business.

View full review »
it_user417285 - PeerSpot reviewer
Senior Production Support Engineer at a tech company with 501-1,000 employees

It's reliability is key.

View full review »
it_user1077 - PeerSpot reviewer
Developer at a tech company with 51-200 employees
1) Supports large part of SQL standards like Complex queries, stored procedures.2) As source code is free and open, it can be easily distributed, modified and extended according to user requirements.3) PostgreSQL also proves to be a cost-effective solution for organization's as this product is designed and created to have much lower maintenance without compromising on features.4) Excellent GUI tools available for PostgreSQL like pgAdmin III. View full review »
Buyer's Guide
Open Source Databases
March 2024
Find out what your peers are saying about PostgreSQL, Firebird, MariaDB and others in Open Source Databases. Updated: March 2024.
765,386 professionals have used our research since 2012.