X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C2A5ED1B191 for ; Wed, 9 Jun 2004 10:01:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74747-10 for ; Wed, 9 Jun 2004 13:01:15 +0000 (GMT) Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net [63.231.195.115]) by svr1.postgresql.org (Postfix) with SMTP id 2BB0FD1B16B for ; Wed, 9 Jun 2004 10:01:08 -0300 (ADT) Received: (qmail 14760 invoked by uid 0); 9 Jun 2004 13:01:11 -0000 Received: from mpls-pop-12.inet.qwest.net (63.231.195.12) by mpls-qmqp-04.inet.qwest.net with QMQP; 9 Jun 2004 13:01:11 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-12.inet.qwest.net with SMTP; 9 Jun 2004 13:01:11 -0000 Date: Wed, 09 Jun 2004 07:01:51 -0600 Message-Id: <1086786111.23855.4.camel@localhost.localdomain> From: "Scott Marlowe" To: "Mauri Sahlberg" Cc: pgsql-admin@postgresql.org Subject: Re: [Fwd: Re: RHDB just sits and does nothing?] In-Reply-To: <63280.195.197.242.66.1086768991.squirrel@www.claymountain.com> References: <63280.195.197.242.66.1086768991.squirrel@www.claymountain.com> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/106 X-Sequence-Number: 13766 On Wed, 2004-06-09 at 02:16, Mauri Sahlberg wrote: > Hi, > > What an earth I am doing wrong? I am trying to delete about 6500 rows and > I am the only user connected to the database and it just sits there and > does nothing? > > Jun 9 10:02:44 pihsi postgres[31547]: [25] LOG: query: begin; > Jun 9 10:02:44 pihsi postgres[31547]: [26] LOG: duration: 0.000181 sec > Jun 9 10:02:51 pihsi postgres[31547]: [27] LOG: query: set constraints > all deferred; > Jun 9 10:02:51 pihsi postgres[31547]: [28] LOG: duration: 0.000205 sec > Jun 9 10:03:04 pihsi postgres[31547]: [29] LOG: query: delete from > tilikartta > where yritys=18231413; > > and after a long wait... > Jun 9 10:46:16 pihsi postgres[31547]: [30] LOG: duration: 2592.534609 > sec Jun 9 11:00:28 pihsi postgres[31547]: [31] LOG: query: commit; > Jun 9 11:00:28 pihsi postgres[31547]: [32] LOG: duration: 0.002915 sec > > DELETE 6347 > rahaks=# commit; > COMMIT > > It just took about three quarters of a hour to delete 6500 rows! > Something is definitely broken and probably I am the one who broke it. Any > guesses what I have broken and how I could fix this? Do you have any foreign key references that are of mismatched types involved?