Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum: vacuum analyze vs autovacuum: vacuum - Mailing list pgsql-admin

From Keith
Subject Re: autovacuum: vacuum analyze vs autovacuum: vacuum
Date
Msg-id CAHw75vugH4auJsrX-1YSfYJD0bxX4gpJhSRm4BvXaaTvNYQqOg@mail.gmail.com
Whole thread Raw
In response to autovacuum: vacuum analyze vs autovacuum: vacuum  (Artem Tomyuk <admin@leboutique.com>)
Responses Re: autovacuum: vacuum analyze vs autovacuum: vacuum  (Artem Tomyuk <admin@leboutique.com>)
List pgsql-admin
Tree view


On Tue, Mar 27, 2018 at 5:04 AM, Artem Tomyuk <admin@leboutique.com> wrote:
Hi, Gurus!


As i understand from documentation:

when the autovacuum: vacuum analyze will be triggered, it will delete dead tuples and than will analyze table
but
when the autovacuum: vacuum will be triggered it will only mark for deletion dead tubles.

Is it valid explanation for postgres 9.4?

Thanks


I believe that when the ANALYZE portion of autovacuum kicks in, it only does the analyze. Which is why it's frequently tuned to run more often than the VACUUM portion of autovacuum since it's less of a load.

Keith

pgsql-admin by date:

Previous
From: bala jayaram
Date:
Subject: AWS Database Migration Errors Post migration
Next
From: Artem Tomyuk
Date:
Subject: Re: autovacuum: vacuum analyze vs autovacuum: vacuum