285697 - Add a --optimize flag to checksetup to do DB-optimization work

Status: RESOLVED WONTFIX

(Bugzilla :: Installation & Upgrading, enhancement)

Description

[Max Kanat-Alexander]

Some databases need more important optimizations than others. For example, in
Pg, dropped columns are not removed from the physical database until you do a
dummy update on all the rows and then a VACUUM FULL on the table.

It would be nice to have a --optimize flag on checksetup that would run some
database optimizations.

Alternately, it could be done through the UI by anybody with the "admin" flag.

One way or another, it should be accessible through the command-line, so admins
can cron it.

Comment 1

[Tomas Kopal]

I would say here "don't bother". This should be a job for the DBA, and having a
cron job for vacuuming postgres DB should be standart (actually, with a lot of
distributions, you get the cron job automatically when you install postgres).
It may be nice to provide a means to "cleanup" after upgrade, but as it heavily
depends not only on DB type and DB version used, but also on the pattern of
usage, the actual implementation can be quite difficult.

Comment 2

[Gervase Markham [:gerv]]

I agree with Tomas ;-)

Gerv