Postgres is an object-relational database management system.
PostgreSQL is to provide support for applications. They need data management, objects, and knowledge management. Therefore, the database supports all modern Unix systems. That is to say neither more nor less than 34 platforms.
To describe the full list of PostgreSQL features, it will take a long time. But let's coupled with the most basic:
o full compliance with the principles of ACID - Atomicity, Consistency, Isolation, Durability.
o Multiversion Concurrency Control (MVCC). To maintain consistency of data in competitive conditions. MVCC means that each transaction sees the database version at the time the transaction starts.
o The presence of Write Ahead Logging (WAL) is a common mechanism for logging all transactions. That allows you to restore the system after possible failures.
o Point in Time Recovery (PITR) - the ability to restore a database (using WAL) at any time in the past.
o Replication also increases the reliability of PostgreSQL.
o Data integrity is the heart of PostgreSQL. PostgreSQL supports data-level consistency at the schema level - foreign keys, constraints.
o The openness of codes means their absolute accessibility for anyone.
- On the other hand, there are a lot of indexes on the use, intelligent query scheduler, thin locking system, memory buffer management and caching system, excellent scalability in competitive work.
o Index Support: standard, partial indices, functional indices (expressional indices)
o The query scheduler provides the user with debugging queries and configuring the system.
o The lock system supports locking at the lower level. That allows you to maintain a high level of competitiveness while protecting the integrity of the data.
o Buffer management and caching.