From: Tom Lane <tgl@sss.pgh.pa.us>
To: balazs@obiserver.hu
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17679: REFRESH MATERIALIZED VIEW CONCURRENTLY leaves temporary files?
Date: Mon, 07 Nov 2022 11:41:35 -0500
Message-ID: <3307283.1667839295@sss.pgh.pa.us> (raw)
In-Reply-To: <17679-1095d04450cf6a6e@postgresql.org>
References: <17679-1095d04450cf6a6e@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> After we upgraded from 14 to 15, the occupied space keeps decreasing.
> The following files can be found in the subdirectory of the database: (
> /var/lib/postgresql/15/main/base/16457 )
> ...
> -rw-------. 1 postgres postgres 210903040 Nov 6 10:37 t8_4372109.1
> -rw-------. 1 postgres postgres 1073741824 Nov 6 14:43 t8_4375122.1
> -rw-------. 1 postgres postgres 1073741824 Nov 6 14:43 t8_4375122.2
> -rw-------. 1 postgres postgres 434585600 Nov 6 14:43 t8_4375122.3
Thanks for the report! Actually it's even worse: v15 will leak non-first
segments of any temporary tables, not just those made during REFRESH
MATERIALIZED VIEW CONCURRENTLY. I've pushed a fix that will appear in
15.1. In the meantime, you should manually delete any files named
according to the tNN_NNNN.N pattern that are clearly too old to belong
to any live session.
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, balazs@obiserver.hu, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17679: REFRESH MATERIALIZED VIEW CONCURRENTLY leaves temporary files?
In-Reply-To: <3307283.1667839295@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