Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 92D719F9A59 for ; Fri, 28 Sep 2007 12:28:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 44079-04 for ; Fri, 28 Sep 2007 12:28:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.243]) by postgresql.org (Postfix) with ESMTP id EAA2B9FB37F for ; Fri, 28 Sep 2007 12:28:46 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so408240ana for ; Fri, 28 Sep 2007 08:28:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=zatdcWQNa6u6qSLcBoV1z3GotAv9VC+rsZPmijoygJw=; b=AHWHkdR9s1HXa4QyO3RswZr5pLSnF3Q9JU7y2/omFllJYS/HEWJoV3op1OV/mQX9ECzhWg8OKL4Tf7nnmeNMSjCjDBqDgmcWEPhnq9JbU/s7YDU1f1L//RAtVmI9wDZDa4mRcFXCWenbLJ07JnKH9Ve7+efTF2Cw+NOymxp6Zks= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=S+mJRiVgKJ05W96mlTFvp0PsU9a3S0l4A6ztWz1kWnK+I2Dcl/xtFow+O16qTUHzsWrhzzS153cxrE1W5wLkQGdfw3eLmkpL665/1vP9QLQyQfYykaDIfgWeacDUOgXY62UtZ8+nrQ+2b2gO3AbplhGJvfSNNT5Jcq7OJt8g324= Received: by 10.78.168.1 with SMTP id q1mr3252594hue.1190993319590; Fri, 28 Sep 2007 08:28:39 -0700 (PDT) Received: by 10.142.143.6 with HTTP; Fri, 28 Sep 2007 08:28:39 -0700 (PDT) Message-ID: Date: Fri, 28 Sep 2007 10:28:39 -0500 From: "Scott Marlowe" To: "Radhika S" Subject: Re: Postgres 7.4.2 hanging when vacuum full is run Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/470 X-Sequence-Number: 27015 On top of what Vivek said, you need to update your pg install. 7.4.2 had a few data eating bugs if I remember correctly. 7.4 branch is up to 7.4.18, and those are a lot of bug fixes (2+ years) you're missing. If one of those bugs eats your data, don't expect any sympathy.