Re: database lagging

From: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
To: Pepe TD Vo <pepevo(at)yahoo(dot)com>
Cc: Alvaro Aguayo <aaguayo(at)opensysperu(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: database lagging
Date: 2021-07-23 19:03:49
Message-ID: CAM+6J971dBrN0Qxdgp75xWaZEdMhScVeF_hmFajKnV3OMcBNSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2021-07-23 19:08:55 Re: database lagging
Previous Message Pepe TD Vo 2021-07-23 18:58:21 Re: database lagging