Bugzilla will be upgraded to version 5.0 on a still to be determined date in the near future. The original upgrade date has been delayed.
Bug 524 - vacuum cleaner script
vacuum cleaner script
Product: Red Hat Linux
Classification: Retired
Component: postgresql (Show other bugs)
All Linux
medium Severity medium
: ---
: ---
Assigned To: Cristian Gafton
Depends On:
  Show dependency treegraph
Reported: 1998-12-18 18:20 EST by borgia
Modified: 2008-05-01 11:37 EDT (History)
0 users

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 1998-12-29 23:07:07 EST
Type: ---
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description borgia 1998-12-18 18:20:52 EST
a postgres-vacuum script in /etc/cron.weekly is recommended:


su postgres -c "for database in /var/lib/pgsql/base/* ; do
psql -c "vacuum" -d \${database##/var/lib/pgsql/base/} -q ;
exit 0

[!!!reported for RH 5.0!!!]
Comment 1 David Lawrence 1998-12-23 10:49:59 EST
This is a suggestion for a product improvement.
Comment 2 Cristian Gafton 1998-12-29 23:07:59 EST
Doing a vacuum on the databases is a action that only the DBA
administrator should decide on. We can not set things to arbitrarily
clean the transaction logs from the database. Due to the high risk of
destroying extremely valuable data, we will not change.

Note You need to log in before you can comment on or make changes to this bug.