PostgreSQL
The open source relational database that does a bit of everything: strict SQL, JSON, full-text search and a huge extension ecosystem. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- PostgreSQL Global Development Group
- Created by
- Michael Stonebraker
- First release
- 1996
- License
- PostgreSQL License
- Open source
- Yes
- Pricing
- Free
- Website
- https://www.postgresql.org
- Written in
- C
- Data model
- Relational, Document
- Storage layout
- Row-oriented
- Workload
- Transactions (OLTP)
- Analytics architecture
- Not an analytics platform
- Query language
- SQL
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Server, Managed cloud
- Scaling
- Replication
- Create, read, update, delete
- Create: fast (Fast single and bulk inserts, COPY for loads); Read: fast (Rich indexes and a mature planner); Update: moderate (MVCC writes a new row version, vacuum cleans up); Delete: moderate (Rows are marked dead until vacuum reclaims them)