是postgresql中的online redo log，是为了保证数据库中数据的一致性和事务的完整性。
### For PostgreSQL 9.6 and below: ```sql SELECT pg_xlog_location_diff(pg_current_xlog_insert_location(), '0/0') / 1024 / 1024 AS wal_generated_mb; ``` Member serprex Jan 31, 2025 • edited we don't support PG 9.6, our minimum supported version was PG12 I thought. ...
未删除WAL段这是一个PostgreSQL的bug，它是fixed。感谢您的报告！
wal_keep_size, and make users specify the WAL size in it instead of the number of WAL files. There was also the idea to rename max_slot_wal_keep_size to max_slot_wal_keep_segments, in the discussion. But we have been moving away from measuring in segments, for example, checkpoin...
including wal_keep_segments.https://www.postgresql.org/docs/9.6/runtime-config-wal.html#GUC-MAX-WAL-SIZE> but I did some testing by bulk inserts then the number of wal files > has grown more than 125. > > and the size of pg_xlog directory also reached to 2.7 GB. > > /data/apps...
postgresql 复制延迟-超过max_slot_wal_keep_size，未删除WAL段这是一个PostgreSQL的bug，它是fixed。