Re: database lagging

yeah, ignore what I asked. Glad others jumped in before it was deviating.
as others said, it would be the replica is lagging or is not reachable/down
in synchronous replication.
select * from pg_stat_replication/pg_replication_slots would help show the
same.

PostgreSQL: Documentation: 13: 26.2. Log-Shipping Standby Servers
<https://www.postgresql.org/docs/current/warm-standby.html#SYNCHRONOUS-REPLICATION>

On Sat, 24 Jul 2021 at 00:33, Vijaykumar Jain <
vijaykumarjain(dot)github(at)gmail(dot)com> wrote:

>
>
> On Sat, 24 Jul 2021 at 00:29, Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:
>
>> I'm running rh-postgresql12
>> psql version 12.5
>> OS RHEL 7
>> I can run select query but lagging to create role, table,
>>
>
> both in interactive and non interactive mode, it is hanging? all write
> based queries but not read?
> if only writes hang, but not reads, do you see any issues/ slowdown with
> writes on your storage where pg_wal resides?
> is it network storage or local?
>
>
>
>
>
>

--
Thanks,
Vijay
Mumbai, India