V
V
Vladimir2020-09-23 14:24:06
PostgreSQL
Vladimir, 2020-09-23 14:24:06

Why does the postgresql wal directory swell?

The server falls under load from one of the databases. A data heap is inserted and a data heap is selected, after which more wal files are generated.

They are sent to the slave (there is monitoring of delays between the master and the slave) where they are successfully played.
They are archived, and there are no archiving errors (and there are no run-ups either, I monitor the number of wal not sent to the storage)

wal sooner or later overflows the disk and the server crashes, after which it reboots and the next checkpoint cuts all thousands of wal files without problems.
So far I think only in the direction of IO, because it is quite high. but I can't figure out why the wal is not being deleted, although it should be.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question