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.
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)
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?
From:
David Steele Date: Subject:
Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?