Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> writes: > I'd like to measure both the amount of WAL created by a long series of data modifications and the compressed size of the generated WAL files. > I suppose I need to set wal_keep_size high, and pay attention to segment numbers to make sure it was high enough. Then I can look at segments created while the commands were running. > But question: can I simply delete all WAL after a clean shutdown? As a general rule, never do that manually --- the risk/reward ratio is unattractive. A checkpoint will release all safely-releasable WAL. You can checkpoint via a shutdown if you insist, but a plain CHECKPOINT command should be enough. regards, tom lane
