In general, my experience with postgress is more than satisfactory, it is an engine that works very well, it is stable, it allows me to handle large databases with tables of more than a million data without any problem. It has some syntax different from common sql, but they give great functionality (like data parsing)

Excellent database manager, it has its own program (phAdmin) that gives you a very friendly graphical interface to carry out all kinds of tasks. Postgress is highly scalable and stable, which is why I prefer it over other options

As against, when the database that is handled is relatively small, when comparing response speeds with other engines, it has a small disadvantage, but its great advantage is noted by having a large database.

Overall, we have a very productive experience with PostgreSQL. Whenever we need a backend database for any of the apps we deploy, we use PostgreSQL. It never fails us.

I like how easy it is to set up and deploy a PostgreSQL database. It has a rich ecosystem of tools and a great open-source community behind it.

I don't have anything I dislike about PostgreSQL.

It can operate on platform specifications, including Linux, Windows, Unix. Large storage capacity Good scalability since it is able to adjust to the number of CPU and the amount of available memory optimally, supporting a greater number of simultaneous requests to the database correctly. It supports the types of data, clauses, functions and commands of standard type SQL92 / SQL99 and extended own of PostgreSQL ..

its graphic environment and considerable savings in operating costs: PostgreSQL has been designed to have a maintenance and adjustment lower than the products of commercial suppliers, while retaining all the characteristics, stability and performance. Stability and reliability: There have been no drops in the database

That Compared to MySQL is slower in insertions and updates, since it has intersection headers that do not have MySQL Support online: There are official forums, but there is no mandatory help It consumes more resources than MySQL .

PostgreSQL is one of the most popular choice for Database now and it becomes more popular as many people and companies starting to use it. PostgreSQL has great features and performances, so I'd like to recommend PostgreSQL to those who needs a reliable RDBMS.

One thing that i dislike from PostgreSQL is it's hard to setup and install PostgreSQL at the beginning. Especially the syntax and command that PostgreSQL use.

Postgres is there for you whenever you need to store and retrieve simple tabular data. Whether that's your app user's name, email, and settings, or the projects and project content that they've created. As long as you're not dealing with over 10k transactions per second, it's cheap to use and extremely easy to set up. Oh, and it's also not great but just okay for advanced searching such as full-text search.

- Postgres is just soooo reliable, it's hard to corrupt or lose data unless you go in and manually edit or delete the data. - Battle-tested ACID transactions to make sure you only update the data when it makes sense to have saved me so much time. - The SQL interface is easy to use once you've mastered SQL (which it isn't; it's the simplest of all the languages I've learned). - Newer versions even has support for advanced use cases such as arrays and JSON objects. - The best thing is that 90% of the backend software developers know Postgres (or MySQL which is pretty dang similar) so help is never too far away!

The only real reason to not use Postgres is that it is pretty hard to scale. If your software requires over 10k transactions per second, you're gonna have to put in some serious work make Postgres scale. This is where Postgres becomes a pain to optimize. Postgres provides poor support for identifying the queries that are running really slowly. e.g. you have to install a buggy plugin and then query a funky poorly documented table. Trying to do master-slave replication is also quite difficult as you often run into consistency issues and will have to modify app logic. In these cases, it's better to go with NoSQL obviously.

In general, my experience with Postgre has been very pleasant. The systems that I have developed using this software as a data manager have been stable. When I have had technical problems it has been possible for me to find the solutions within its great community

its compatibility with previous versions makes development very friendly. It is also Open source and free, which allows saving costs in the development of systems. there is a lot of documentation online to find solutions to problems In addition to having a large community

It's official handler is not friendly. Installation for begginners is not easy. configure advanced functions such as replication It is complicated

Best database management system: plenty of plugins (data visualization, backup, performance, etc), easily expandable, incredibly powerful configuration options.

PostgreSQL is the most flexible database management system out there. It has a lot of plugins (data visualization, backup, performance, etc), which make it very expandable too, incredibly powerful configuration options, etc. It has almost any type of column that your system will ever need.

I really don't found any PostgreSQL problem until now, so I would recommend that you use it without any fear.

We use PostgreSQL as database tool for all our healthcare software products

PostgreSQL is eaiser to maintenance and to install than other RDBMS like ORACLE. PostgreSQL is open source so is cheaper than other RDBMS. It takes less learrning time than other RDBMS

We do not have any cons about PostgreSQL

It's a very good database application. I use it as a hobby

one of the most successful database applications I have used, its interface is easy and it is nice to open different pages in tab form. I also loved that it included a dark theme.

Although the code is correct, it says there is an error when the code is run, sometimes I waste time searching for this non-existent error.

It's a very powerful DB for the price, it has all the features and customization that any db admin needs.

Without a db admin, the features may be restricted to the basic ones, unless someone researches how to do things

I can state with confidence that PostgreSQL has exceeded my expectations as a database management system based on my whole experience with it. I strongly rely on PostgreSQL as a data-driven professional to store, retrieve, and analyze massive volumes of data. PostgreSQL's adaptability and scalability have been crucial in meeting our expanding data demands. The knowledge that our important information is safe thanks to the secure data storage capabilities gives us piece of mind. Additionally, we have avoided possible data loss situations thanks to the backup and recovery tools. One of PostgreSQL's unique advantages is its support for several programming languages, which has enabled us to collaborate easily with other development frameworks. The query performance was identified and optimized with the use of the performance analysis tools, resulting in effective data retrieval. The ability to import and export data has also made it simple to move data between platforms. Overall, PostgreSQL has exceeded my expectations, and I heartily endorse it to anybody looking for a solid and dependable database management system.

In my experience with PostgreSQL, its adaptability and dependability as a database management system were its strongest points. I like PostgreSQL's broad range of features and capabilities as a data specialist. In order to satisfy the various data requirements of our firm, it has been essential to be able to manage enormous datasets, conduct sophisticated queries, and support advanced data types. The versatility it offers with its support for several programming languages, which enables us to smoothly incorporate PostgreSQL into our current tech stack, is something I personally enjoy. The performance analysis tools have been crucial in improving query execution and system performance as a whole.

My least favorite aspect about PostgreSQL was the steep learning curve and complexity involved in setting it up and configuring it. I haven't used database management systems for very long, so navigating PostgreSQL's installation and configuration options proved to be a challenge. I had to spend more time and effort learning the many PostgreSQL-specific concepts and settings.

We have never lost data, never paid too much and never looked back. PostgreSQL is at the hear of our organization and our trust has paid off in the long run. Running it on top of a managed stack such as AWS RDS is they way to go as this is the hardest part of using PostgreSQL and you don't want to waste time re-learning what has already been learned. It's worth the cost to use these services in the long run. Rapid prototyping can be done locally and is free so your price to start is always zero!

PostgreSQL is and always has been one of the most feature rich and solid databases available. Its price / performance / feature set is simply unmatched in the industry today.

There is a lot of old information on the internet that is no longer relevant to current versions and you must sift through this in some cases to find the modern and elegant solutions. It was touted as "slow" compared to MySQL in the early 2000's and much of that information is wrong due to lack of user experience with the product or no longer the case today.

We use PostgreSQL as our system database for the software we develop, we find it reliable, robust and with great performance, we use both PHP and C++ to access the dataabse.

PostgreSQL is a full featured SQL server solution. it is free and open-source, PostgreSQL can be installed on many different platform like Linux, Windows, macOS and other. being open-source if has lots of contribute tools from the open-source community providing wide range solutions, PostgreSQL is also available in the cloud from all the major providers.

Management is less comfortable and some settings needs to be done in PostgreSQL configuration files, also database schema management tool is not so comfortable, but you can use 3rd party tools for that also

I needed a very efficient database that could handle a huge amount of records, views and access for a data-scraping and analysis project. I was able to very easily do this with a combination of python for data processing, tableau for visualization and postgre-sql for the database. It has been running for a few years without any hiccups and with great efficiency.

User management is very flexible and the query language support many things that MySQL does not out-of-the-box, more inline with oracle database.

Not as ubiquitous as MySQL so initial setup and admin is slightly more complicated.

One of the best open source relational database in the market. Large support of data types make it powerful and lots of storage of less schema data. ACID compliant and lock management support.

PostgreSQL has a wide support of server operating system e.g. windows, UNIX, Solaris, Linux, FreeBSD, Open BSD and OS X. Large support of APIs like ADO.NET, JDBC, ODBC and native C library which makes it easy to connect with any module. Good support of programming languages as well i.e. C, C++, JAVA, .NET, PHP and Python.

Wide support from community but some times its difficult to track any issue and get support. Reading speed is bit low as compared to other DBMS. Documentation is only available in English.

Using PostgreSQL is hard and sometimes frustrating but once set up it gives sys admins a great peace of mind.

I've been using PostgreSQL since 2002. It is not easy to install, deploy and manage compared to other relational database of its class. It is though rock solid, incredibly fast and there are a lot of great features.

A modern management system would be very welcome. There have been several attempt to make it more user friendly by honestly none has been successful so far.

I am a web developer and geospatial analyst. I am using PostgreSQL daily to store spatial datasets using PostGIS, its powerful spatial extension

PostgreSQL has been on my tech stack since 2006. It is an impressive open source software, really reliable. I love its PostGIS spatial module, which enables powerful geospatial functions.

I like everything and I can't think of something which I don't like. This is by far the best open source RDBMS

Postgres provides everything I need in a Relational Database System, I have been using it for a while and I swear by it.

- Completely and absolutely free - Open-source, so you can look at the code - Every feature you might want in a database is there - Convenient PostgreSQL admin for the management of DB servers

- Making replication across several distributed regions can be quite challenging if you haven't done it before.

PostgreSQL can process complex queries in relatively less time, and data can be accessed seemingly faster with non-key attributes. Since we deployed PostgreSQL at work we are delighted to see its flexibility and the better performance for our most common use cases.

Implementing the database in PostgreSQL is quick and efficient. PostgreSQL is much quicker with use-cases. Setting prototypes for development is relatively easier with PostgreSQL. It is a simply a relational database, and stores the data in tables, and supports complex transactions. Accessing data and attribute is faster in PostgreSQL especially when searching for an attribute that is not indexed. So it is great for sorting data in a relatively short period of time.

PostgreSQL is not flexible to JSON objects, even the nested documents or arrays are not handled with Postgres. It is slow when it comes to processing queries that use nested references, so we had to deal with more complexities at work.

Much better performance and consistency vs other RDBMS, eg MySQL. It doesn't hide the complexity beyond being a DBA, which is kind of a double edged sword.

Manual intervention needed for version upgrades, but nothing terrible.

PostgreSQL is one of the best from the range of DBMS i used in my career. Features like Stored Procedures is one of the reason i prefer this tool. It helps me take off a huge amount of workload from the API server as same data need to format differently for different APIs. Along with it the availability of builtin functions like JSON functions, Regex Functions etc helps a lot in the data processing field. Connectors support for various languages is one of the main reason for using this tool. Connection Pooling helps me execute multiple queries without slowing the system and losing any data.

It is not suitable for beginners. Designing a efficient and effective Database workflow need a skilled DB Admin so a beginner need some time to get to familiar with the system. Another drawback is its management tool pgAdmin 4. Its a disaster compare to pgAdmin 3. It is a web App and lags a lot. I face problems in multitasking in version 4 that is not the case with version 3. I Hope someday somebody provide backward compatibility of PostgreSQL 10+ with pgAdmin 3.

Flexible, robust with advanced features. Complex DB dashboard.

The ease of use sets it apart from other tools

The DB performance , lack of in depth documentation and lack of dedicated customer support to get quick help on critical production loads.

We have deployed 100 of PostgreSQL instances as the back-end for state owned LMS. Databases are well performing and never receive any complaints regarding performance after the GO-LIVE. We have deploy PostgreSQL for simple web application to the enterprise grade internet banking app.

+ Install is very easy + Support almost all platform + Data aggregation is fast + Good documentation from vendor and community + Highly stable + Secured

+ Working with JSON etc. is not easy comparable to other products + Poor data compression mechanisms + Bit resource hungry

I have used this several times while I was studying and in my company also. t supports ACID properties and it can handle high traffic. I can use database indexing, different data types. functions, aggregates and complex queries. There's a huge community support and I asked for assistance twice from them.

I doubt the performance of this when I handle complex queries.

PostgreSQL is my favorite database management system by a long shot. I've professionally used MySQL, Maria DB, MS SQL Server, SQLite, MS Access, and several NoSQL options and Postgres is the best by far. It has a great community around a great product. The official docs are very approachable and I learn new things every time I use it. They built a strong core around consistency and reliability and ever since 9.0 they've made the system really really fast. I can't recommend this software enough!

Very strong consistency and reliability Feature set is growing rapidly Very fast and efficient Very developer friendly Very extensible

There are lots and lots of configuration options and the defaults aren't right for modern hardware