From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Ambarish Bhattacharya <b.ambarish@live.in>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Autovaccum settings while Bulk Loading data
Date: Thu, 10 Jun 2010 18:27:16 +0300
Message-ID: <4C110454.4080104@enterprisedb.com> (raw)
In-Reply-To: <BAY141-W740444F713B91B32640D286D80@phx.gbl>
References: <BAY141-W24938315EC2639A872BC0C86D80@phx.gbl>
<4C10A9E5.20206@enterprisedb.com>
<BAY141-W740444F713B91B32640D286D80@phx.gbl>
Please keep the mailing list CC'd, so that others can help.
On 10/06/10 15:30, Ambarish Bhattacharya wrote:
>> 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"?
>
> Hanging the entire process means...the autovacuum and auto analyzes starts and after that there is no acitivity i could see in the postgres log related to the bulk loading and when checked the postgres processes from the task manager i could see few of the postgres porcess are still running and had to be killed from there..normal shut down in not happening in this case...
You'll have to provide a lot more details if you want people to help
you. How do you bulk load the data? What kind of log messages do you
normally get in the PostgreSQL log related to bulk loading?
Autovacuum or autoanalyze should not interfere with loading data, even
if it runs simultaneously.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: heikki.linnakangas@enterprisedb.com, b.ambarish@live.in
Subject: Re: Autovaccum settings while Bulk Loading data
In-Reply-To: <4C110454.4080104@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox