I have a Postgresql cluster with few databases. In one of the databases, if I try to create a new table, the command is never complete until I kill the linux process. I've checked pg_lock and found that pg_class and indexex on pg_class are locked, locktpe is the relationship and the mode is RowExclusiveLock.
I can add a column to a table but I can not create an index on a table.
If I create a table in another database, there is no lock on pg_class.
Each clue can help.