On Thu, 2021-02-04 at 10:03 +, Zwettler Markus (OIZ) wrote:
> 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_largeo
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 min