From: | Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | vacuum full |
Date: | 2021-08-30 17:42:41 |
Message-ID: | CAM+6J976si2WFrwfxT9JNrOmmmBjmgSc2aEVjSv1Fu6n7PLWOA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Just keeping it in a separate email, incase this is thrashed down.
vacuum full has a lot of problem stories, not just because the db gets
locked, but also because it is mostly (mis)used when there are space issues.
of course, there are strong warnings in docs and wiki about using a vacuum
full,
but i was just thinking
vacuumdb and vacuumlo can make use of options like --dry-run, like
pg_repack allows,
but also just abort incase there is no disk space available.
i mean, i have seen confident replies from earlier mailing threads, where
assume 2x disk required per object that is full vacuumed at least.
can this be converted into an estimate of sorts on objects that would be
vacuumed and free disk that would be required before any operation starts.
maybe this is wishful thinking, but just asking.
--
Thanks,
Vijay
Mumbai, India
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2021-08-30 17:57:27 | Re: Idempotent DDL Updates |
Previous Message | Mladen Gogala | 2021-08-30 17:38:14 | Re: vacuumlo |