Re: database lagging

[Pepe TD Vo <pepevo@xxxxxxxxx>]

I'm running rh-postgresql12 

psql version 12.5

OS RHEL 7

I can run select query but lagging to create role, table,

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)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

On Friday, July 23, 2021, 02:40:39 PM EDT, Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx> wrote:

On Fri, 23 Jul 2021 at 23:59, Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx> wrote:

On Fri, 23 Jul 2021 at 23:37, Alvaro Aguayo <aaguayo@xxxxxxxxxxxxxxx> 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.

I am not so sure this is lock issue? Ctrl C would not complete the command if it were a lock issue?

Pepe can confirm if he sees any locks though ?

Hey Pepe,

Can you let us know

what postgres version?

what psql version?

what OS?

also, is it possible for you to collect stack trace of the hanging process?

Getting a stack trace of a running PostgreSQL backend on Linux/BSD - PostgreSQL wiki

also is it only hanging in interactive mode? 

psql -c 'alter role foobar superuser;'   

does this complete fine ?

also forgot to ask.

does this only hang only alter role commands ?

or any other command /query like 

\du

select 1;

create table t(id int);