Re: Enabling autovacuum per table

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: "rjo_roy(at)yahoo(dot)com" <rjo_roy(at)yahoo(dot)com>, "adrian(dot)klaver(at)aklaver(dot)com" <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Enabling autovacuum per table
Date: 2018-10-16 12:21:54
Message-ID: 18afc5eddb84339504aeaabec36d08ca5c50a665.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rijo Roy wrote:
> Is there a possibility to disable auto analyze if we set autovacuum_analyze_scale_factor
> to 100% and autovacuum_analyze_threshold = 0?

Why would you want that?

You are trying very hard to hurt yourself by disabling autovacuum;
maybe there is a better way to solve your problem.

Can you tell us more about the actual problem?

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scot Kreienkamp 2018-10-16 12:59:10 RE: Pgbouncer discard all
Previous Message Nicola Contu 2018-10-16 12:12:06 Re: Pgbouncer discard all