From: Tom Lane <tgl@sss.pgh.pa.us>
To: Marco Boeringa <marco@boeringa.demon.nl>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4?
Date: Sat, 23 Jul 2022 11:33:55 -0400
Message-ID: <883945.1658590435@sss.pgh.pa.us> (raw)
In-Reply-To: <6c9bf4fd-f22b-4894-d7c9-30bf68ffcf6d@boeringa.demon.nl>
References: <85acb61d-4cbf-7544-c734-429993257547@boeringa.demon.nl>
<791d1850-f337-8914-1ba0-512f4e0fef26@boeringa.demon.nl>
<Ytr1cTgWLHhk40DB@momjian.us>
<2d7ff154-d0db-502d-aca8-a605fafcf395@boeringa.demon.nl>
<6c9bf4fd-f22b-4894-d7c9-30bf68ffcf6d@boeringa.demon.nl>
Marco Boeringa <marco@boeringa.demon.nl> writes:
> Ok, I found it out using 'sudo baobab'. It is the:
> 'var/lib/postgresql/14/main/pg_wal'
> folder that is filled up with 890 GB of data... causing the file system
> root to run out of space and Ubuntu opening the disk usage analyzer and
> a warning as a consequence.
The most likely explanations for this are
(a) misconfiguration of WAL archiving, so that the server thinks
it should keep WAL files till they've been archived, only that
never happens.
(b) inability to complete checkpoints for some reason, preventing
WAL files from being recycled.
It doesn't look like you have wal_archiving on, so (a) *should*
be ruled out, but you never know. If there are a ton of "nnn.ready"
files underneath pg_wal then trouble here would be indicated.
As for (b), you might try enabling log_checkpoints and seeing if
the log messages give any clue.
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-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, marco@boeringa.demon.nl, bruce@momjian.us, pgsql-bugs@lists.postgresql.org
Subject: Re: Fwd: "SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3/4?
In-Reply-To: <883945.1658590435@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