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 prob
Thanks Adrian for sharing the facts and docs..
Is there a possibility to disable auto analyze if we set
autovacuum_analyze_scale_factor to 100% and autovacuum_analyze_threshold = 0?
Thanks, Rijo Roy
Sent from Yahoo Mail on Android
On Mon, 15 Oct 2018 at 6:48 pm, Adrian Klaver
wrote: On
On 10/15/18 1:01 AM, Rijo Roy wrote:
Hello Experts,
Is there any possibility for autovacuum to work on a user table if we set
Alter table sometable set (autovacuum_enabled = true) ; even if the
parameter autovacuum = off in Postgresql.conf
I am using Postgresql 10 on Linux 6.9.
According to
Yeah when age(relfrozenxid) goes beyond the limit Postgresql will invoke the
autovacuum session to avoid a wraparound issue.. But here that's not the case..
Sent from Yahoo Mail on Android
On Mon, 15 Oct 2018 at 2:58 pm, Arthur Zakirov
wrote: On 10/15/18 11:01 AM, Rijo Roy wrote:
> Hello
On 10/15/18 11:01 AM, Rijo Roy wrote:
Hello Experts,
Is there any possibility for autovacuum to work on a user table if we set
Alter table sometable set (autovacuum_enabled = true) ; even if the
parameter autovacuum = off in Postgresql.conf
I am using Postgresql 10 on Linux 6.9.
According to
