+ 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
hing...
>
>
> 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 find the query and its outp
tent 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.5.12 behind PGBouncer and facing some
> weird issue
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