On Fri, 2021-01-29 at 15:44 +0000, Zwettler Markus (OIZ) wrote:
> I run "vacuumlo" in batches (-l) which worked well.
>
> I found table "pg_catalog.pg_largeobjects" to be massively bloated afterwards.
Sure, that deletes entries from that table.
> I tried "vacuum full pg_catalog.pg_largeobjects" but run out of diskspace (although having 250G diskspace free;
databasesize = 400G).
>
> Question:
> Will "vacuum full pg_catalog.pg_largeobjects" need less diskspace when "maintenance_work_mem" is increased?
No, it won't. It will just be faster.
That sounds like your database consists almost exclusively of large objects...
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com