16 Facts About PostgreSQL

PostgreSQL, known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

PostgreSQL evolved from the Ingres project at the University of California, Berkeley.

PostgreSQL returned to Berkeley in 1985, and began a post-Ingres project to address the problems with contemporary database systems that had become increasingly clear during the early 1980s.

PostgreSQL won the Turing Award in 2014 for these and other projects, and techniques pioneered in them.

PostgreSQL manages concurrency through multiversion concurrency control, which gives each transaction a "snapshot" of the database, allowing changes to be made without affecting other transactions.

Related searches

PostgreSQL offers three levels of transaction isolation: Read Committed, Repeatable Read and Serializable.

PostgreSQL includes built-in binary replication based on shipping the changes to replica nodes asynchronously, with the ability to run read-only queries against these replicated nodes.

PostgreSQL includes built-in synchronous replication that ensures that, for each write transaction, the master waits until at least one replica node has written the data to its transaction log.

Postgres-XC which is based on PostgreSQL provides scalable synchronous multi-master replication.

PostgreSQL includes built-in support for regular B-tree and hash table indexes, and four index access methods: generalized search trees, generalized inverted indexes, Space-Partitioned GiST and Block Range Indexes .

PostgreSQL provides an asynchronous messaging system that is accessed through the NOTIFY, LISTEN and UNLISTEN commands.

PostgreSQL server is process-based, and uses one operating system process per database session.

In PostgreSQL they are folded, internally, to lower case characters whereas the standard says that unquoted identifiers should be folded to upper case.

Default configuration of PostgreSQL uses only a small amount of dedicated memory for performance-critical purposes such as caching database blocks and sorting.

Insertion and data uploads in PostgreSQL were better, although general searching ability of both databases was almost equivalent.

PostgreSQL is available for the following operating systems: Linux, 64-bit x86 installers available and tested for macOS version 10.