Postgres Pro
Downloads
Home   >   mailing lists

Re: database lagging - Mailing list pgsql-admin

From Vijaykumar Jain
Subject Re: database lagging
Date
Msg-id CAM+6J94NrTfF5+BL2iJQpF+aefAikeCU3eWxVy7_NX8-rBWaMg@mail.gmail.com
Whole thread Raw
In response to Re: database lagging  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Responses Re: database lagging
List pgsql-admin
Tree view
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.



On Sat, 24 Jul 2021 at 00:33, Vijaykumar Jain <vijaykumarjain.github@gmail.com> wrote:


On Sat, 24 Jul 2021 at 00:29, Pepe TD Vo <pepevo@yahoo.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

pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: Re: database lagging
Next
From: Pepe TD Vo
Date:
Subject: Re: database lagging