Difference between revisions of "Write-ahead logging (WAL)"
Jump to navigation
Jump to search
| (4 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
* <code>[[/var/lib/postgresql/]]##/main[[/pg_wal/]]</code> | * <code>[[/var/lib/postgresql/]]##/main[[/pg_wal/]]</code> | ||
| − | |||
* <code>[[wal_level]]</code> | * <code>[[wal_level]]</code> | ||
| − | |||
| − | |||
| − | |||
[[Prometheus logs]]: | [[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 == | == Errors == | ||
* <code>[[could not find WAL segment]]</code> | * <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>[[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:
