PostgreSQL Features

in general is a good database manager like MySQL you have many functions and one, in particular, the notifications, you can send a notify and it's like a broadcast message, useful for interaction with the backend

the way how to backup and restore is sometimes complicated, we tried to automatized and sometimes works others not, the same script! and because of that, you can have an empty DB

PostgreSQL is a powerful open-source relational database management system that I have used extensively for several projects. I must say that it is one of the best relational database systems available in the market.What I liked most about using PostgreSQL is its reliability and robustness. PostgreSQL is a rock-solid database system that is known for its stability and scalability. It offers a wide...

Read more

What I liked least about using PostgreSQL is that it can be complex to set up and manage. The database system has many advanced features, which may be overwhelming for beginners. However, PostgreSQL offers extensive documentation and a large community of developers, making it easy to find solutions to any issues that may arise.

- 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.

Highly recommended. It's the most powerful database engine I ever worked with. It has a lot of features that I used and worked very well: postgis for spatial searches, full-text search, partitions, etc.

At some point, we start having problems with very slow queries, and after some debugging we discover postgres decided to use the wrong index to perform the query plan. Probably because of bad stats but from time to time the problem happens again.

PostgreSQL has several advantages. It is lightweight and reliable. Search filters are very easy to understand. People who know the basics of the SQL language can do several queries, since PostgreSQL assembles selects. I can change it within the table itself, so I don't need to do the update command. On top of that, it's free and open source!

Sometimes the connection to the database drops (internal server error 500), and it is necessary to connect again. When the query has many records, the data return is slow. They are the only negative points of this tool.

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

What I like most about this database engine is its security, scalability and high performance for the development of platforms and web applications, easy to maintain and manage

That I did not like the product, its difficult or complex syntax, sometimes the very tedious query error

This is very easy to use and manages. Easy to handle JSON data type and having lots of data type available. Table partitions available for increasing performance.

Creating store procedure are still very complex and not good as compare to sql server.

Postgresql is the best database system to store data.

The most usaged features is an extensions. I think that this features should include to standard postgresql distribution.

It's been reliable beyond all expectations. Put your data in Postgres, you know you'll find them when you need them.

VACUUMs are a big performance penalty, and the default auto-vacuum settings aren't always optimal for all use cases.

PostgreSQL is a powerful and flexible open-source relational database management system. It offers high performance, rich SQL support, and advanced data types, such as arrays, hstore, and JSON. It can be used for a wide range of use cases, from small web applications to large enterprise systems. The active community provides a wealth of resources, tutorials, and support, which helps to easily create...

Read more

PostgreSQL is a powerful and versatile open-source database system that offers many advanced features for data management and analysis. Its robust SQL engine and built-in support for advanced data types make it a great choice for a wide range of applications. While the software can be a bit complex to set up and manage for beginners, the comprehensive documentation and active community make it easy to get started. Overall, I highly recommend PostgreSQL for anyone looking for a reliable and feature-rich database solution.

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.

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

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.

PostgreSQL or simply Postgres implements the SQL and advanced SQL standard very well. It can handle workloads ranging from small web applications to large data warehousing with many parallel users. Postgres provides a easy to use tool called pgAdmin to interact with and manipulate database. It provides support for complex data types like (multi-dimensional) Array, Json, user-defined types. PostgreSQL provides higher number of connections at cheap price. It support all types of indexing for faster retrieval of data. In my company we replaced our database server from MySQL to PostgreSQL because of PostgreSQL higher db connections connections in cheaper price as compared to MYSQL. It is also available free of cost till 10,000 rows on Heroku.

PostgreSQL query syntax for some complex queries like array, json, string functions and case operator are bit complicated to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as compared to MySQL and it is bit harder to search for help regarding some complex queries and database functions on google. Replication is not yet as well implemented as in MySQL.

It allows me to implement a robust database in a very short time, using a structure very similar to Oracle, in addition to having many tools that allow us to manage the data in the best way.

There are functionalities that with third-party products can obtain better results.

I like PostgreSQL for different reasons: - It has flexible implementation options. - Large volume databases can be stored. - It is possible to have multiple databases on a single server and have different configurations for them. - PostgreSQL is completely free. - Its base language is SQL, making it very easy to manipulate. - It has excellent administration toolkits.

I dislike PostgreSQL for different reasons: - I don't like that the more detailed documentation is only available in English. - It has a high CPU consumption.

Open source. Offers a rich set of features and extensions. Available as fully managed database on most cloud platforms.

Some cases, often involving large sets of data, might require some advanced knowledge in order to run properly/performant.

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.

PostgreSQL is a feature-rich and powerful relational database system that is suitable for a wide range of applications. It is an open-source software, which means that it is free to use and modify. It has a strong reputation for reliability and performance, and it is used by many large companies and organizations.

No database can cover all types of workloads and PostgreSQL is no exception. For example, it may not be the best choice for real-time analytics or high-speed transactions.

Free to use Robust technology Reliable Full compatibility with most integrations of AWS , Azure , Google , IBM Gasto , secure Not so hard learning curve Great community Constant upgrades

It feels a little bit overwhelming at the beginning Sometimes can be difficult to enable ok servers for the PDO driver

PostgreSQL provides the complex functions in its stored procedures and triggers. PostgreSQL also works well in the JSON file, it allows us to store, search and index by JSON content data. It provides privileges at the object level to User and Role to make data more secure. It has many advance SQL command like Table joins, Subquery and Views, the performance of PostgresSQL is greate when we need to execute complex SQL command

It does not cache the Query execution plans so sometimes cause a delay when we need to run SQL repeatedly. Its UI tool, PgAdmin's is not good compared with other tools that lack some function of the search or Scrolling.

does the basics like a pro while offering infinite flexibility. From JSON columns to full-text search, there's a plugin for every need. Plus, it plays nicely with every ORM known to man. Postgres has mastered the art of doing the basics exceptionally well. It's reliable, performant, and stands strong as a relational database. But what sets it apart is the remarkable flexibility it offers. Need to store and query JSON data? No problem. Looking for full-text search capabilities? Postgres has your back with plugins that can handle it all. This database truly adapts to your evolving needs, making it a versatile choice for any project.

No Issues at All, Just Vendor Restrictions. Now, I have to dig deep to find something negative about Postgres. The truth is, I haven't encountered any issues with Postgres itself. Its robustness and stability have been flawless in my experience. If I had to point a finger, it would be at the vendors (like Heroku) who occasionally restrict certain plugins. But hey, that's not Postgres's fault—it's still a champ in its own right.

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.