autovacuum: vacuum analyze vs autovacuum: vacuum

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: autovacuum: vacuum analyze vs autovacuum: vacuum
Date: 2018-03-27 09:04:42
Message-ID: CANYYVqL0M=-mVZH6T85jpO648pM5dVNu39n7i93M39JZmT=atQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vlad Alexeenkov 2018-03-27 09:40:02 Strange behavior of the timezone
Previous Message Ahmed, Nawaz 2018-03-27 02:54:55 RE: Backup Tool