curious vacuum full behavior

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: curious vacuum full behavior
Date: 2021-02-04 10:03:53
Message-ID: d9e34b260bfe45b280005f6cdc2814f7@zuerich.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have 2 identical systems A + B.
B being a clone of A.

The table pg_catalog.pg_largeobject was identical on both systems: 300GB in total size; 100GB bloated.

I did following on A:

? vacuum full pg_catalog.pg_largeobject;
(using the default maintenance_work_mem of 64MB)
It took around 45 minutes and increased the diskspace by around 125% until the vacuum had been finished.

I did following on B:

? set maintenance_work_mem = '256MB';

? vacuum full pg_catalog.pg_largeobject;
This took around 5 minutes. I don't know if the diskspace ever increased.

I was really surprised.
Is there any explanation on this behavior?
Is vacuum full heavily using on-disk sort areas if maintenance_work_mem is too low?

Postgres Version 9.6

Thanks, Markus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Atul Kumar 2021-02-04 11:26:26 vacuumdb not letting me connect to db
Previous Message Adith Suresh 2021-02-04 09:46:02 PgAdmin 4 GUI not responding