Re: database lagging

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: database lagging
Дата
Msg-id CAM+6J94NrTfF5+BL2iJQpF+aefAikeCU3eWxVy7_NX8-rBWaMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: database lagging  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Ответы Re: database lagging  (Pepe TD Vo <pepevo@yahoo.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Pepe TD Vo
Дата:
Сообщение: Re: database lagging
Следующее
От: Pepe TD Vo
Дата:
Сообщение: Re: database lagging