Difference between revisions of "Write-ahead logging (WAL)"
Jump to navigation
Jump to search
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[wikipedia:Write-ahead logging]] | [[wikipedia:Write-ahead logging]] | ||
| − | * <code>pg_wal/</code> | + | * <code>[[/var/lib/postgresql/]]##/main[[/pg_wal/]]</code> |
| − | |||
* <code>[[wal_level]]</code> | * <code>[[wal_level]]</code> | ||
| − | + | [[Prometheus logs]]: | |
| + | * <code>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</code> | ||
| − | + | == Errors == | |
| − | [[ | + | * <code>[[could not find WAL segment]]</code> |
| − | + | * <code>2023-06-19 06:32:37.504 UTC [1440100] HINT: Consider increasing the configuration parameter "[[max_wal_size]]".</code> | |
== Related terms == | == Related terms == | ||
| − | * [[PITR]] | + | * [[Point-in-time recovery (PITR)]] |
* [[ACID]] | * [[ACID]] | ||
* [[ARIES]] | * [[ARIES]] | ||
| − | |||
* [[Amazon RDS Read Replicas]] | * [[Amazon RDS Read Replicas]] | ||
* [[Data warehouse]]: [[Change Data Capture (CDC)]] | * [[Data warehouse]]: [[Change Data Capture (CDC)]] | ||
| − | * <code>[[ | + | * <code>[[timescaledb-tune --help|timescaledb-tune -wal-disk-size]]</code> |
| − | |||
== See also == | == See also == | ||
Latest revision as of 14:59, 3 July 2023
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
Errors[edit]
could not find WAL segment2023-06-19 06:32:37.504 UTC [1440100] HINT: Consider increasing the configuration parameter "max_wal_size".
Related terms[edit]
- Point-in-time recovery (PITR)
- ACID
- ARIES
- Amazon RDS Read Replicas
- Data warehouse: Change Data Capture (CDC)
timescaledb-tune -wal-disk-size
See also[edit]
Advertising:
