Re: database lagging

Поиск
Список
Период
Сортировка
От Pepe TD Vo
Тема Re: database lagging
Дата
Msg-id 678607417.590943.1627064821704@mail.yahoo.com
обсуждение исходный текст
Ответ на RE: database lagging  (Alvaro Aguayo <aaguayo@opensysperu.com>)
Список pgsql-admin
Дерево обсуждения
nothing is running. Only psql and background writer, checkpointermain, walwritermain, autovacuummain, logicalLauncherMain from pg_stat_activity (6 rows) nothing else is running

no row select on "select relation::regclass, * from pg_locks where not granted;

select on "select relation::regclass, * from pg_locks;
2 rows for pg_locks relation for AccessShareLock and virtualxid for ExclusiveLock.

What else can I check and correct ?





Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more.EmojiEmojiEmoji
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success




On Friday, July 23, 2021, 02:07:15 PM EDT, Alvaro Aguayo <aaguayo@opensysperu.com> wrote:


Is there any other thing running with that database? If so, I would consider a locking problem. CREATE/ALTER ROLE should never take too much time, unless there is some kind of lock in a global catalog.

 

Regards,

 

Alvaro Aguayo

Operations Manager

Open Comb Systems E.I.R.L.

 

From: Pepe TD Vo <pepevo@yahoo.com>
Sent: 23 July 2021 12:52
To: pgsql-admin@lists.postgresql.org
Subject: database lagging

 

I am doing CIS Benchmart on Postgreql 12.  After alter parameters and when I tried to create a new role.  It's lagging and didn't prompt out the result, until I hit the ctl C key.  Even alter role.  All I needed to hit ctl C key if not, it hung there for ever.  Is there a way to fix it?

 

postgres=# create role appuser;

^CCancel request sent

CREATE ROLE

 

postgres=# ALTER ROLE appuser NOSUPERUSER;

^CCancel request sent

ALTER ROLE

 

 

postgres=# ALTER ROLE appuser NOREPLICATION;

^CCancel request sent

ALTER ROLE

 

postgres=# ALTER ROLE appuser NOCREATEROLE;

^CCancel request sent

ALTER ROLE

 

postgres=# ALTER ROLE appuser NOHERIT;

^CCancel request sent

ALTER ROLE

 

 

 

В списке pgsql-admin по дате отправления:

Предыдущее
От: David Steele
Дата:
Сообщение: Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: database lagging