Write-ahead logging (WAL)

wikipedia:Write-ahead logging

• pg_wal/

• wal_level

Prometheus logs:

ts=2023-02-17T01:00:03.414Z caller=head.go:1011 level=info component=tsdb msg="WAL checkpoint complete" first=1633 last=1634 duration=628.31117ms

Related terms

• PITR
• ACID
• ARIES
• PostgreSQL
• Amazon RDS Read Replicas
• Data warehouse: Change Data Capture (CDC)
• /var/lib/postgresql/13/main/pg_wal/

See also

• pg_dump, pg_dumpall, WAL, PITR, PgBackRest
• PostgreSQL replication, Amazon RDS Read Replicas, WAL, pg_replication_slots, START_REPLICATION, CREATE SUBSCRIPTION
• Databases: Database management, SQL, NoSQL, Wide column, PostgreSQL, MariaDB, MySQL, Derby DB, MongoDB, Cassandra, SQLite, HSQL2, H2, RocksDB, Microsoft SQL Server, DB2, Oracle Database, Memcached, Berkeley DB, Collation, SingleStore, Amazon Aurora, Graph database, Amazon DynamoDB, PrestoDB, Cache hit ratio, ACID, WAL, ARIES, DBMS, OLTP, OLAP, Database Schema, CockroachDB, Tables, Views, Apache Druid, RDMS