Re: database lagging

[Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx>]

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

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

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