Search tools, AI agents, MCP servers
Submit a tool

Search iThub

Search tools, categories and collections. Type at least two characters.

Explore all tools
↑ ↓ to explore resultsEnter to open · Esc to close

PostgreSQL

Open source object-relational database with extensions

DatabasesOpen source18.6

PostgreSQL at a glance

Pricing
Open source
Deployment
Self-hosted
License
Open source
Version
18.6Checked November 3, 2026
Platforms
WindowsmacOSLinux
Language
C
Maker
postgres
Founded
1996
HQ
Open Source Project
Last push
November 6, 2026
API
Available

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

No reviews yet

Be the first to share your experience with PostgreSQL.

Loading review form…

Found PostgreSQL useful? Upvote it todayYour vote helps other IT teams find it in the daily ranking.

Related guides

All guides

Similar to PostgreSQL

Compare:PostgreSQL vs MySQLPostgreSQL vs MongoDBPostgreSQL vs DuckDB

  1. DuckDBIn-process analytical SQL database with no server to manageDatabases30 views
  2. ClickHouseOpen-source column-oriented SQL database for real-time analytics, self-managed or as ClickHouse CloudDatabases23 views
  3. RedisIn-memory data store for caching, sessions, and searchDatabases17 views
  4. OracleDatabases on premises and in Oracle CloudDatabases13 views
  5. SingleStoreDistributed SQL database for transactions and analyticsDatabases12 views
  6. CassandraMasterless, wide-column NoSQL database built for multi-datacenter availabilityDatabases11 views
  7. InfluxDBOpen source time series database for real-time dataDatabases11 views
  8. MySQLWidely used open-source relational database, now developed by OracleDatabases11 views