Re: database lagging

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux