Home > mailing lists

Re: database lagging - Mailing list pgsql-admin

From	Vijaykumar Jain
Subject	Re: database lagging
Date	July 23, 2021 22:03:49
Msg-id	CAM+6J971dBrN0Qxdgp75xWaZEdMhScVeF_hmFajKnV3OMcBNSQ@mail.gmail.com Whole thread Raw
In response to	Re: database lagging (Pepe TD Vo <pepevo@yahoo.com>)
Responses	Re: database lagging (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
List	pgsql-admin

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?

From: Pepe TD Vo
Date: 23 July 2021, 21:58:21
Subject: Re: database lagging

From: Rui DeSousa
Date: 23 July 2021, 22:08:55
Subject: Re: database lagging