PostgreSQL is a Object-Relational DBMS supporting almost all SQL constructs, including subselects, transactions, and user-defined types and more. The name comes from the fact that many of the original developers also worked on Ingres, and so this is the “post-ingres” database. Design for the system began in 1986, with an explicit goal of providing a database that completely supported types with the minimum number of features necessary. By the early 1990s, the database had reached a significant number of users. Around this time, its status as a University of California, Berkeley project ended, but due to the open source license, development continued, as it does to this day.
PostgreSQL is seen as the most popular open source database after MySQL, although it has in many ways more advanced and more mature implementations of key features, particularly those required by heavy-duty OLTP applications.