Write-ahead logging (WAL)

wikipedia:Write-ahead logging

• pg_wal/

• wal_level

2023-06-19 06:32:37.504 UTC [1440100] HINT:  Consider increasing the configuration parameter "max_wal_size".

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/
• could not find WAL segment

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