| From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
|---|---|
| To: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Vacuum freeze |
| Date: | 2014-12-04 18:48:54 |
| Message-ID: | CAK3UJRGkOqfkMyfGiWZtDNnMua9K0wuWKSu=Hj42RccB7OuvJw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Dec 4, 2014 at 12:02 PM, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> wrote:
> 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?
It is (supposed to be) handled by autovacuum: you can tune
autovacuum_freeze_max_age:
http://www.postgresql.org/docs/current/static/runtime-config-autovacuum.html
And there are similar knobs for manual VACUUMs as well.
Josh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2014-12-04 19:10:54 | Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform |
| Previous Message | Vick Khera | 2014-12-04 17:26:38 | Re: Vacuum freeze |