X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C4163D1E43E for ; Sat, 28 Feb 2004 12:50:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 15723-08 for ; Sat, 28 Feb 2004 08:49:59 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 4BF2ED1E43F for ; Sat, 28 Feb 2004 08:49:51 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i1SCno1Y096948 for ; Sat, 28 Feb 2004 12:49:51 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i1SCWYYk095103 for pgsql-admin@postgresql.org; Sat, 28 Feb 2004 12:32:34 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.admin Subject: Re: ALTER table taking ages... Date: Sat, 28 Feb 2004 13:32:34 +0100 Organization: PYRENET Midi-pyrenees Provider Lines: 45 Message-ID: References: <403EF608.7040005@trade-india.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en In-Reply-To: <403EF608.7040005@trade-india.com> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/392 X-Sequence-Number: 12565 Rajesh Kumar Mallah wrote: > > Greetings! > > It takes ages to drop a constraint from one of my tables > [ table details at the end ] I cannot insert into it also. > > I know pg_dump is not running and no other query is accessing the table. > Can anyone help me debugging this problem? Can anyone explain the > following entires in pg_locks where relation and database > are both null. > > tradein_clients=# SELECT * from pg_locks where mode='ExclusiveLock' and > granted is true; > +----------+----------+-------------+-------+---------------+---------+ > | relation | database | transaction | pid | mode | granted | > +----------+----------+-------------+-------+---------------+---------+ > | NULL | NULL | 116230313 | 19898 | ExclusiveLock | t | > | NULL | NULL | 116230309 | 24779 | ExclusiveLock | t | > | NULL | NULL | 116230267 | 24780 | ExclusiveLock | t | > | NULL | NULL | 116230303 | 24764 | ExclusiveLock | t | > | NULL | NULL | 116230302 | 24751 | ExclusiveLock | t | > | NULL | NULL | 116230308 | 24767 | ExclusiveLock | t | > | NULL | NULL | 116230274 | 24761 | ExclusiveLock | t | > | NULL | NULL | 116230306 | 24752 | ExclusiveLock | t | > | NULL | NULL | 116230312 | 23222 | ExclusiveLock | t | > | NULL | NULL | 116230290 | 24768 | ExclusiveLock | t | > | NULL | NULL | 116230292 | 24776 | ExclusiveLock | t | > | NULL | NULL | 116230297 | 24753 | ExclusiveLock | t | > | NULL | NULL | 116230295 | 24765 | ExclusiveLock | t | > | NULL | NULL | 116230152 | 24096 | ExclusiveLock | t | > | NULL | NULL | 116230311 | 24769 | ExclusiveLock | t | > | NULL | NULL | 116194826 | 23048 | ExclusiveLock | t | > | NULL | NULL | 116230307 | 24758 | ExclusiveLock | t | > +----------+----------+-------------+-------+---------------+---------+ > (17 rows) May I know how you obtain this kind of output ( biq square around results ) ? Regards Gaetano Mendola