Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 25F3A6336CC for ; Wed, 13 Jan 2010 10:15:06 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65162-08 for ; Wed, 13 Jan 2010 14:14:55 +0000 (UTC) X-Greylist: delayed 00:06:39.628894 by SQLgrey-1.7.6 Received: from outbound-mail-10.bluehost.com (outbound-mail-10.bluehost.com [69.89.17.210]) by mail.postgresql.org (Postfix) with SMTP id 4FE5A6328C8 for ; Wed, 13 Jan 2010 10:14:55 -0400 (AST) Received: (qmail 2351 invoked by uid 0); 13 Jan 2010 14:08:13 -0000 Received: from unknown (HELO host159.hostmonster.com) (74.220.207.159) by outboundproxy1.bluehost.com with SMTP; 13 Jan 2010 14:08:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default; d=timbira.com; h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:CC:Subject:References:In-Reply-To:X-Enigmail-Version:Content-Type:Content-Transfer-Encoding:X-Identified-User; b=eA4R5ERcvEjLSLBbQB7mCaD/3WrvWxSsfNsDk7G7c6IPvIYff63sv+w9JUGIa56jimJH5s4HtBEjEQQb96AHE5rd86IhzoC3StqjgiYzMNUlYiis2u7zY+ekKiPVNpWp; Received: from [189.32.82.61] (helo=[10.3.2.2]) by host159.hostmonster.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1NV3tM-0007kY-Vd; Wed, 13 Jan 2010 07:08:13 -0700 Message-ID: <4B4DD381.6070302@timbira.com> Date: Wed, 13 Jan 2010 12:06:57 -0200 From: Euler Taveira de Oliveira User-Agent: Thunderbird 2.0.0.23 (X11/20090812) MIME-Version: 1.0 To: Eduardo Piombino CC: Greg Smith , Craig James , pgsql-performance@postgresql.org Subject: Re: a heavy duty operation on an "unused" table kills my server References: <4B4D5698.8040808@emolecules.com> <4B4D78B2.30600@2ndquadrant.com> In-Reply-To: X-Enigmail-Version: 0.96.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Identified-User: {1651:host159.hostmonster.com:timbirac:timbira.com} {sentby:smtp auth 189.32.82.61 authed with euler@timbira.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.589 tagged_above=-10 required=5 tests=BAYES_00=-2.599, FH_DATE_PAST_20XX=3.188 X-Spam-Level: X-Archive-Number: 201001/247 X-Sequence-Number: 37127 Eduardo Piombino escreveu: > Maybe it does not get logged at all until the ALTER is completed? > This feature [1] was implemented a few months ago and it will be available only in the next PostgreSQL version (8.5). [1] http://archives.postgresql.org/pgsql-committers/2009-11/msg00018.php -- Euler Taveira de Oliveira http://www.timbira.com/