Ok, thanks for the clarification.
вт, 27 бер. 2018, 18:48 користувач Keith <keith@xxxxxxxxxxx> пише:
On Tue, Mar 27, 2018 at 5:04 AM, Artem Tomyuk <admin@xxxxxxxxxxxxxx> 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 tablebutwhen the autovacuum: vacuum will be triggered it will only mark for deletion dead tubles.Is it valid explanation for postgres 9.4?ThanksI 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
