PostgreSQL
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.
Relations
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...
Edit details Edit relations Attach new author Attach new topic Attach new resource
Resources
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!