pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: balazs@obiserver.hu
Subject: BUG #17679: REFRESH MATERIALIZED VIEW CONCURRENTLY leaves temporary files?
Date: Sun, 06 Nov 2022 23:09:56 +0000
Message-ID: <17679-1095d04450cf6a6e@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      17679
Logged by:          Balazs Szilfai
Email address:      balazs@obiserver.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



view thread (2+ messages)  latest in thread

Message-ID: <17679-1095d04450cf6a6e@postgresql.org>
Permalink:  ../17679-1095d04450cf6a6e@postgresql.org/
Also on:    postgresql.org/message-id/17679-1095d04450cf6a6e@postgresql.org

 · 

reply
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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, balazs@obiserver.hu
  Subject: Re: BUG #17679: REFRESH MATERIALIZED VIEW CONCURRENTLY leaves temporary files?
  In-Reply-To: <17679-1095d04450cf6a6e@postgresql.org>

* 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