+ pgsql-general
Thanks and Regards,
Ashu Pachauri
-- Forwarded message -
From: Ashu Pachauri
Date: Mon, Aug 13, 2018 at 7:53 PM
Subject: Re: is there any adverse effect on DB if I set autovacuum scale
factor to zero?
To:
The way I see *autovacuum_vacuum_scale_factor* is not
not being blocked by anything...
>
>
> regards,
>
> fabio pardi
>
>
>
> On 31/05/18 14:26, Ashu Pachauri wrote:
> > Thanks Fabio for the reply.
> > The queries are blocked in the sense that I can see them in
> pg_stat_activity.
> >
> > Please fi
> this case, please post the full content of pg_stat_activity)
>
> or
>
> 'blocked' as in 'they are waiting in pgbouncer pool?
>
>
> regards,
>
> fabio pardi
>
>
> On 31/05/18 12:38, Ashu Pachauri wrote:
> > We have been using Postgres 9
We have been using Postgres 9.5.12 behind PGBouncer and facing some weird
issues. Whenever we running long running DDL statements (e.g. 'add index
concurently' or 'Alter table alter column type'), after some time, we start
seeing that almost every query in our application starts getting blocked.
I
