Re: curious vacuum full behavior

2021-02-04 Thread Laurenz Albe
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

curious vacuum full behavior

2021-02-04 Thread Zwettler Markus (OIZ)
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