BUG #17679: REFRESH MATERIALIZED VIEW CONCURRENTLY leaves temporary files?

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: balazs(at)obiserver(dot)hu
Subject: BUG #17679: REFRESH MATERIALIZED VIEW CONCURRENTLY leaves temporary files?
Date: 2022-11-06 23:09:56
Message-ID: 17679-1095d04450cf6a6e@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17679
Logged by: Balazs Szilfai
Email address: balazs(at)obiserver(dot)hu
PostgreSQL version: 15.0
Operating system: Debian Linux
Description:

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
-rw-------. 1 postgres postgres 210919424 Nov 6 14:44 t8_4375147.1
-rw-------. 1 postgres postgres 210919424 Nov 6 15:22 t8_4375598.1
-rw-------. 1 postgres postgres 1073741824 Nov 6 15:22 t8_4375627.1
-rw-------. 1 postgres postgres 1073741824 Nov 6 15:22 t8_4375627.2
-rw-------. 1 postgres postgres 434585600 Nov 6 15:22 t8_4375627.3
-rw-------. 1 postgres postgres 210960384 Nov 6 18:58 t8_4388673.1
-rw-------. 1 postgres postgres 210960384 Nov 6 18:59 t8_4388712.1
-rw-------. 1 postgres postgres 210960384 Nov 6 19:00 t8_4392884.1
-rw-------. 1 postgres postgres 210968576 Nov 6 20:18 t8_4400972.1
-rw-------. 1 postgres postgres 210976768 Nov 6 23:15 t8_4415109.1
-rw-------. 1 postgres postgres 1073741824 Nov 6 23:16 t8_4415139.1
-rw-------. 1 postgres postgres 1073741824 Nov 6 23:16 t8_4415139.2
-rw-------. 1 postgres postgres 434634752 Nov 6 23:16 t8_4415139.3
-rw-------. 1 postgres postgres 210878464 Nov 6 09:08 t9_4370351.1
-rw-------. 1 postgres postgres 1073741824 Nov 6 09:09 t9_4370380.1
...

200 GB of free storage space disappeared in 24 hours!

Regards,
Balazs

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2022-11-07 07:29:09 BUG #17680: execute alter composite type and select composite type concurrently, may cause pg coredump
Previous Message Tom Lane 2022-11-06 17:54:17 Re: BUG #17434: CREATE/DROP DATABASE can be executed in the same transaction with other commands