Vacuum freeze

From: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Vacuum freeze
Date: 2014-12-04 17:02:01
Message-ID: CANPAkgvP1dj5ejxH8LEKSbYt5RzdOH5cuiwi-FikxmRCiyk6wQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

check_postgres.pl (--action=autovac_freeze) recently complained that we
needed to run VACUUM FREEZE. Doing so generated a boatload of WAL files -
perhaps on the order of the of the database itself.

Is VACUUM FREEZE something that is normally handled by autovac? If so, how
would we approach finding what caused it not to happen automatically? Or
if it's not, what's the normal approach to scheduling it manually to
prevent this flood of WAL?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2014-12-04 17:26:38 Re: Vacuum freeze
Previous Message Tom Lane 2014-12-04 15:15:39 Re: segmentation fault postgres 9.3.5 core dump perlu related ?