From: Tom Lane <tgl@sss.pgh.pa.us>
To: Zbigniew Kostrzewa <zkostrzewa@gmail.com>
Cc: Ninad Shah <nshah.postgres@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: WAL files keep piling up
Date: Wed, 22 Dec 2021 13:18:11 -0500
Message-ID: <287032.1640197091@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+VG59Ga1rMooMhUh=1hGp_cC+foJEr73FPe8sMqkQHL9PK1Tw@mail.gmail.com>
References: <CA+VG59En-5bJPDwisAMOCZEmcSkPjEq0EAYo3BEV6qFKpt1Dbw@mail.gmail.com>
<CAOFEiBc1e3_u7yj_p2xKn9T4TnC5QDBxZ=ZGhyALCMmUsLcQ1g@mail.gmail.com>
<CA+VG59Ga1rMooMhUh=1hGp_cC+foJEr73FPe8sMqkQHL9PK1Tw@mail.gmail.com>
Zbigniew Kostrzewa <zkostrzewa@gmail.com> writes:
> Thanks for responding. On current master it looks like so:
> ls pg_xlog/archive_status/ | grep ready | wc -l
> 0
> ls pg_xlog/archive_status/ | grep done | wc -l
> 501
Hmm, if you've got archiving turned off, I wonder why you have
any .done files at all. Perhaps they are leftover from a time
when you did have archiving on, and for some reason they are
confusing the non-archive-mode cleanup logic.
Anyway, you could certainly manually remove the .done files and
the corresponding WAL segment files, and then see what happens.
BTW, I'm sure you realize that 9.6.15 is not exactly current.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, zkostrzewa@gmail.com, nshah.postgres@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: WAL files keep piling up
In-Reply-To: <287032.1640197091@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox