What is PostgreSQL?
PostgreSQL is an open source object-relational database system that uses and extends the SQL language. Its origins date back to 1986 and the POSTGRES project at the University of California at Berkeley, and it has nearly 40 years of active development on the core platform. It is free and open source, and it runs on all major operating systems.
PostgreSQL has been ACID-compliant since 2001. Its feature list includes multi-version concurrency control (MVCC), table partitioning and every transaction isolation level defined in the SQL standard, including Serializable. Indexing options go beyond B-tree to GiST, SP-GiST, GIN, BRIN, covering indexes and Bloom filters.
The database is extensible: users can define their own data types and build custom functions. Document data is supported through JSON/JSONB, XML and key-value (Hstore) types. The project publishes its own downloads, documentation and community pages, and support comes from the community, a managed-service provider or a paid support vendor of your choice.
Key capabilities
- An object-relational engine that extends SQL
- ACID compliance and multi-version concurrency control
- JSON/JSONB, XML and key-value (Hstore) data types
- Index types including GiST, SP-GiST, GIN, BRIN and Bloom filters
- Table partitioning
- User-defined data types and functions
- Free, open source software that runs on all major operating systems
Where PostgreSQL fits
- Relational data with transactional integrity
- Document data alongside relational tables
- Advanced indexing for varied query types
- Table partitioning for large datasets
- Custom data types and functions
Reviews of PostgreSQL
Be the first to share your experience with PostgreSQL.
Write a review
Loading review form…
Found PostgreSQL useful? Upvote it todayYour vote helps other IT teams find it in the daily ranking.

