DevOps Dictionary

DevOps Terms: P

8 DevOps terms that start with P, each explained in one paragraph with a diagram.

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

PostgreSQL

Data Management

PostgreSQL is an open source relational database that stores data in tables and answers questions written in SQL (Structured Query Language). It groups changes into transactions that either complete fully or leave no trace (for example, moving money between 2 accounts), so data stays correct when many users write at once or a server crashes. Indexes and a query planner keep reads fast, and it can also store JSON.

Patent-style sketch of PostgreSQL: an SQL query slip enters a query planner machine that reads and writes tables, with every change recorded on a transaction log roll.

See also Publish-Subscribe (Pub/Sub), MongoDB, OpenSearch.