Topic | v3 | updated by jjones |

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres. PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server, and is also available for Linux, FreeBSD, OpenBSD, and Windows.


subtopic of Computer science

Computer science is the study of computation and information. Computer science deals with theory of c...

parent of PostgreSQL identity column

PostgreSQL version 10 introduced a new feature called GENERATED AS IDENTITY constraint that allows yo...

is SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming an...

is Database

A database is an organized collection of data, generally stored and accessed electronically from a co...

Edit details Edit relations Attach new author Attach new topic Attach new resource

has official PostgreSQL Documentation

8.0 rating 5.0 level 8.0 clarity 3.0 background – 1 rating

Latest PostgreSQL Documentation

treated in Postgres scaling advice for 2021 - CYBERTEC | PostgreSQL

This article covers scaling advices for PostgreSQL and explains, why it may be a good idea to keep it...

treated in Safe Operations For High Volume PostgreSQL

Safe PostgreSQL operations for a high volume deploys without downtime.

treated in Choice of Table Column Types and Order When Migrating to PostgreSQL

An underappreciated element of PostgreSQL performance can be the data types chosen and their organiza...

treated in Working with PostgreSQL - Zerodha Tech Blog

Our experience running large multi-terabyte PostgreSQL DBs in production with hundreds of billions of...

compared in Do You Need Redis? PostgreSQL Does Queuing, Locking, & Pub/Sub

It's a common architecture to have PostgreSQL and Redis serve as the backbone of your app, but Postgr...

treated in Lesser Known PostgreSQL Features

Features you already have but may not know about!