Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id D58FD63266D
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 10 Jun 2010 06:01:39 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 62098-10
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 10 Jun 2010 09:01:31 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from exprod7og123.obsmtp.com (exprod7og123.obsmtp.com [64.18.2.24])
	by mail.postgresql.org (Postfix) with SMTP id 83B036322B1
	for <pgsql-performance@postgresql.org>;
	Thu, 10 Jun 2010 06:01:31 -0300 (ADT)
Received: from source ([209.85.219.210]) by exprod7ob123.postini.com
	([64.18.6.12]) with SMTP
	ID DSNKTBCp6SgDiAP3xoUT3dcU9gtlg1h7IWvA@postini.com;
	Thu, 10 Jun 2010 02:01:31 PDT
Received: by ewy2 with SMTP id 2so1580834ewy.16
	for <pgsql-performance@postgresql.org>;
	Thu, 10 Jun 2010 02:01:29 -0700 (PDT)
Received: by 10.213.4.138 with SMTP id 10mr1972464ebr.48.1276160488762;
	Thu, 10 Jun 2010 02:01:28 -0700 (PDT)
Received: from [192.168.1.117] (dsl-hkibrasgw2-ff7ac300-240.dhcp.inet.fi
	[88.195.122.240])
	by mx.google.com with ESMTPS id 14sm4688148ewy.10.2010.06.10.02.01.27
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Thu, 10 Jun 2010 02:01:28 -0700 (PDT)
Message-ID: <4C10A9E5.20206@enterprisedb.com>
Date: Thu, 10 Jun 2010 12:01:25 +0300
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Organization: EnterpriseDB
User-Agent: Mozilla/5.0 (X11; U; Linux i686; fi-FI;
	rv:1.9.1.9) Gecko/20100515 Iceowl/1.0b1 Icedove/3.0.4
MIME-Version: 1.0
To: Ambarish Bhattacharya <b.ambarish@live.in>
CC: pgsql-performance@postgresql.org
Subject: Re: Autovaccum settings while Bulk Loading data
References: <BAY141-W24938315EC2639A872BC0C86D80@phx.gbl>
In-Reply-To: <BAY141-W24938315EC2639A872BC0C86D80@phx.gbl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-4.2 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_MED=-2.3
X-Spam-Level: 
X-Archive-Number: 201006/148
X-Sequence-Number: 39004

On 10/06/10 11:47, Ambarish Bhattacharya wrote:
> It would be helpful if you can suggest me the appropriate Autovacuum settings for handling this large data as my autovacuum setting is hanging the entire process.

What do you mean by "hanging the entire process"?

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com