Linked data from upgrade after VACUUM FULL not deleted.

From: Josef Šimánek <josef(dot)simanek(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Linked data from upgrade after VACUUM FULL not deleted.
Date: 2019-05-11 17:04:32
Message-ID: CAFp7Qwq66a7nuMGQ6B_1_g+oXAQP0=UWQ7Du-C2WB_MfMP+n1g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

Few months ago we did successful pg_upgrade --link from 9.6 to 10. I did a
VACUUM FULL of all database this weekend and data from 9.6 directory were
not released.

I have tablespace with only one database.

PostgreSQL 10 folder has similar size to actual database size (by
https://wiki.postgresql.org/wiki/Disk_Usage it is 660GB):
681G ./postgres_raid_tablespace/PG_10_201707211

PostgreSQL 9.6 folder still has a lot of data in there:
547G ./postgres_raid_tablespace/PG_9.6_201608131

I did a really naive check if any links are still present:

ls -la . | grep "\->"

And nothing was found.

I have checked also which files are waiting to be deleted via lsof -u
postgres, but nothing was found in those directories.

I'm wondering if I understand this well and this is expected state where
old folder is not touched anymore and that's the reason why VACUUM FULL is
not releasing space in there.

Is there any way how to check if anything in that folder is really not used
anymore and consider that safe to delete?

I'll appreciate any suggestions.

Josef

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2019-05-11 17:19:08 Re: Hot Standby Conflict on pg_attribute
Previous Message Jeremy Schneider 2019-05-11 16:15:07 Re: Hot Standby Conflict on pg_attribute