Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 147039FB513 for ; Thu, 3 May 2007 10:32:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 23548-07 for ; Thu, 3 May 2007 10:32:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from p15105778.pureserver.info (p15105778.pureserver.info [217.160.133.184]) by postgresql.org (Postfix) with ESMTP id 8EB039FB4F5 for ; Thu, 3 May 2007 10:32:14 -0300 (ADT) Received: by p15105778.pureserver.info (Postfix, from userid 65534) id 683EA440D5; Thu, 3 May 2007 15:32:47 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by server1.proventis.net (Postfix) with ESMTP id 15B42C44290 for ; Thu, 3 May 2007 15:32:12 +0200 (CEST) Received: from server1.proventis.net ([127.0.0.1]) by localhost (server1.proventis.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17940-06 for ; Thu, 3 May 2007 15:32:11 +0200 (CEST) Received: from [192.168.22.130] (tmarkus.proventis.net [192.168.22.130]) by server1.proventis.net (Postfix) with ESMTP id ADA9CC4428F for ; Thu, 3 May 2007 15:32:11 +0200 (CEST) Message-ID: <4639E45B.3030500@proventis.net> Date: Thu, 03 May 2007 15:32:11 +0200 From: Thomas Markus Organization: proventis GmbH User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: infinite blocking statements in 8.2.3 References: <46384CEA.9080906@proventis.net> <4639742C.7070902@proventis.net> <20070503131125.GB4218@alvh.no-ip.org> In-Reply-To: <20070503131125.GB4218@alvh.no-ip.org> Content-Type: multipart/mixed; boundary="------------040303070600050408030505" X-Virus-Scanned: by amavisd-new at proventis.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/35 X-Sequence-Number: 25355 This is a multi-part message in MIME format. --------------040303070600050408030505 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit the problem was not the long running statement. that statement has blocked other connections and i was unable to drop that connection. at the end all connections where blocked (output in ps: UPDATE waiting ..). the only solution was to restart the server. After my understanding I can terminate a connection (produces rollback) always however this special connection could not not be terminated. Normally I could do this. I will observe whether the behavior again arise. Alvaro Herrera schrieb: > Thomas Markus wrote: > >> thanks for your awnsers >> >> i cant repeat the problem after increasing autovacuum_naptime to 5min. a >> vacuumdb -f -a runs over night (and finished :) ) and now that blocking >> statement finished after some seconds. it seems autovacuum = on is not >> enough. >> > > Enough for what? You still haven't said what the problem was. I am > unsure if I should be concerned. It now sounds like ordinary slowness > caused by table bloat. > --------------040303070600050408030505 Content-Type: text/x-vcard; charset=utf-8; name="t.markus.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="t.markus.vcf" begin:vcard fn:Thomas Markus n:Markus;Thomas org:proventis GmbH adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany email;internet:t.markus@proventis.net tel;work:+49 30 29 36 399 22 x-mozilla-html:FALSE url:http://www.proventis.net version:2.1 end:vcard --------------040303070600050408030505--