PostgreSQL Glossary

Important definitions and terminologies used in PostgreSQL

A B C D E F G H I J K L M N O P Q R S T U V W

A

ACID in PostgreSQL

Administration in PostgreSQL

Aggregate function in PostgreSQL

Aggregate Functions in PostgreSQL

Alerting in PostgreSQL

Analytic function in PostgreSQL

ANALYZE in PostgreSQL

Archive Recovery Mode in PostgreSQL

Archiving in PostgreSQL

ARRAY in PostgreSQL

Asynchronous Replication in PostgreSQL

Atomic in PostgreSQL

Atomicity in PostgreSQL

Attribute in PostgreSQL

autovacuum in PostgreSQL

Auxiliary process in PostgreSQL

Go to Top

B

Backend in PostgreSQL

Background worker in PostgreSQL

Background writer in PostgreSQL

Backup in PostgreSQL

Backup Tool in PostgreSQL

Base Backup in PostgreSQL

Bloat in PostgreSQL

BOOLEAN in PostgreSQL

B-tree in PostgreSQL

Go to Top

C

CAST in PostgreSQL

Catalog in PostgreSQL

CHECK in PostgreSQL

Check constraint in PostgreSQL

Checkpoint in PostgreSQL

Checkpointer in PostgreSQL

Class in PostgreSQL

Client in PostgreSQL

Cluster in PostgreSQL

Cluster (or ‘Database Cluster’) in PostgreSQL

Cluster of Nodes in PostgreSQL

Cold Backup in PostgreSQL

Column in PostgreSQL

Commit in PostgreSQL

Concurrency in PostgreSQL

Connection in PostgreSQL

Connection Pooling in PostgreSQL

Consistency in PostgreSQL

Constraint in PostgreSQL

CREATE in PostgreSQL

CREATE DATABASE in PostgreSQL

createdb in PostgreSQL

CREATEDB role in PostgreSQL

CREATEROLE role in PostgreSQL

Cumulative Statistics System in PostgreSQL

Go to Top

D

Dashboards in PostgreSQL

Data area in PostgreSQL

Data directory in PostgreSQL

Data page in PostgreSQL

Data Type in PostgreSQL

Data Types in PostgreSQL

Database in PostgreSQL

Database cluster in PostgreSQL

Database Health in PostgreSQL

Database server in PostgreSQL

DATE in PostgreSQL

Datum in PostgreSQL

Delete in PostgreSQL

Directory Structure in PostgreSQL

‘Dirty’ Page in PostgreSQL

Domain in PostgreSQL

Durability in PostgreSQL

Go to Top

E

Epoch in PostgreSQL

Extension in PostgreSQL

Go to Top

F

Failover in PostgreSQL

File segment in PostgreSQL

Foreign data wrapper in PostgreSQL

Foreign Key in PostgreSQL

Foreign server in PostgreSQL

Foreign table in PostgreSQL

Fork in PostgreSQL

Free space map in PostgreSQL

FULL OUTER JOIN in PostgreSQL

Function in PostgreSQL

Go to Top

G

Grant in PostgreSQL

GROUP role in PostgreSQL

GUI in PostgreSQL

Go to Top

H

Heap in PostgreSQL

Host in PostgreSQL

Hot Continuous Archiving in PostgreSQL

Hot Logical Backup in PostgreSQL

Hot Standby Server in PostgreSQL

Go to Top

I

Index in PostgreSQL

initdb in PostgreSQL

INNER JOIN in PostgreSQL

INSERT in PostgreSQL

Instance in PostgreSQL

Instance (or ‘Database Server Instance’ or ‘Database Server’ or ‘Backend’) in PostgreSQL

INTEGER in PostgreSQL

Isolation in PostgreSQL

Go to Top

J

JDBC in PostgreSQL

Join in PostgreSQL

Go to Top

K

Key in PostgreSQL

Go to Top

L

LEFT JOIN in PostgreSQL

LIMIT in PostgreSQL

listen_addresses in PostgreSQL

Load Balancing in PostgreSQL

Lock in PostgreSQL

Log in PostgreSQL

Log Analysis in PostgreSQL

Log file in PostgreSQL

Log record in PostgreSQL

log_destination in PostgreSQL

log_directory in PostgreSQL

log_filename in PostgreSQL

log_line_prefix in PostgreSQL

log_min_messages in PostgreSQL

log_rotation_age in PostgreSQL

log_rotation_size in PostgreSQL

Logfile in PostgreSQL

Logged in PostgreSQL

Logger in PostgreSQL

LOGIN role in PostgreSQL

Log-Shipping Replication in PostgreSQL

Go to Top

M

Many-to-Many in PostgreSQL

Master in PostgreSQL

Master Server in PostgreSQL

Materialized in PostgreSQL

Materialized view in PostgreSQL

Mathematical Operators in PostgreSQL

max_connections in PostgreSQL

md5 authentication in PostgreSQL

Metrics in PostgreSQL

Monitoring in PostgreSQL

Monitoring Tools in PostgreSQL

Multi-version concurrency control (MVCC) in PostgreSQL

MVCC in PostgreSQL

Go to Top

N

Normalization in PostgreSQL

NOT NULL in PostgreSQL

Null in PostgreSQL

Numeric Data Types in PostgreSQL

Go to Top

O

ODBC in PostgreSQL

ON in PostgreSQL

One-to-Many in PostgreSQL

One-to-One in PostgreSQL

Optimizer in PostgreSQL

ORDER BY in PostgreSQL

Go to Top

P

Parallel query in PostgreSQL

Partition in PostgreSQL

Partitioned table in PostgreSQL

password authentication in PostgreSQL

Performance Tuning in PostgreSQL

pg_basebackup in PostgreSQL

pg_dump in PostgreSQL

pg_dumpall in PostgreSQL

pg_hba.conf in PostgreSQL

pg_stat_activity in PostgreSQL

pg_stat_database in PostgreSQL

pgAdmin in PostgreSQL

PITR in PostgreSQL

PITR (Point-In-Time Recovery) in PostgreSQL

PostgreSQL in PostgreSQL

PostgreSQL Backup and Recovery in PostgreSQL

PostgreSQL Client Authentication in PostgreSQL

PostgreSQL Database Monitoring in PostgreSQL

PostgreSQL Database Roles in PostgreSQL

PostgreSQL Logging in PostgreSQL

PostgreSQL Server Configuration in PostgreSQL

PostgreSQL Vacuuming in PostgreSQL

postgresql.conf in PostgreSQL

Postmaster in PostgreSQL

Primary in PostgreSQL

Primary Key in PostgreSQL

Procedure in PostgreSQL

psql in PostgreSQL

Go to Top

Q

Query in PostgreSQL

Query Optimization in PostgreSQL

Query planner in PostgreSQL

Query Tool in PostgreSQL

Go to Top

R

Record in PostgreSQL

Recovering in PostgreSQL

recovery_target_time in PostgreSQL

Recycling in PostgreSQL

Referential Integrity in PostgreSQL

Relation in PostgreSQL

Relationship in PostgreSQL

Replica in PostgreSQL

Replication in PostgreSQL

Restartpoint in PostgreSQL

restore_command in PostgreSQL

Result set in PostgreSQL

Revoke in PostgreSQL

RIGHT JOIN in PostgreSQL

Role in PostgreSQL

Rollback in PostgreSQL

ROUND in PostgreSQL

Routine in PostgreSQL

Row in PostgreSQL

Go to Top

S

Savepoint in PostgreSQL

Schema in PostgreSQL

Search Path (or ‘Schema Search Path’) in PostgreSQL

Segment in PostgreSQL

SELECT in PostgreSQL

Sequence in PostgreSQL

Server in PostgreSQL

Server Database in PostgreSQL

Session in PostgreSQL

Shared Buffers in PostgreSQL

Shared memory in PostgreSQL

shared_buffers in PostgreSQL

SQL in PostgreSQL

SQL object in PostgreSQL

SQL standard in PostgreSQL

Standby in PostgreSQL

Standby Server in PostgreSQL

Startup process in PostgreSQL

Stored Procedure in PostgreSQL

Streaming Replication in PostgreSQL

SUPERUSER role in PostgreSQL

Synchronous Replication in PostgreSQL

System catalog in PostgreSQL

Go to Top

T

Table in PostgreSQL

Tablespace in PostgreSQL

Temporary table in PostgreSQL

TEXT in PostgreSQL

Timeline in PostgreSQL

TIMESTAMP in PostgreSQL

TOAST in PostgreSQL

Transaction in PostgreSQL

Transaction ID in PostgreSQL

Transactions per second (TPS) in PostgreSQL

Trigger in PostgreSQL

trust authentication in PostgreSQL

Tuple in PostgreSQL

Go to Top

U

UNIQUE in PostgreSQL

Unique constraint in PostgreSQL

Unlogged in PostgreSQL

Update in PostgreSQL

User in PostgreSQL

User mapping in PostgreSQL

USING in PostgreSQL

Go to Top

V

Vacuum in PostgreSQL

vacuum_cost_limit in PostgreSQL

vacuum_cost_page_hit in PostgreSQL

vacuum_cost_page_miss in PostgreSQL

View in PostgreSQL

Visibility map in PostgreSQL

Go to Top

W

WAL in PostgreSQL

WAL archiver in PostgreSQL

WAL file in PostgreSQL

WAL receiver in PostgreSQL

WAL record in PostgreSQL

WAL segment in PostgreSQL

WAL sender in PostgreSQL

WAL writer in PostgreSQL

wal_buffers in PostgreSQL

Warm Standby Server in PostgreSQL

WHERE in PostgreSQL

Window function in PostgreSQL

work_mem in PostgreSQL

Write-ahead log in PostgreSQL