Re: [PERFORM] Autovaccum settings while Bulk Loading data

2010-06-10 Thread Heikki Linnakangas
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 han

Re: [PERFORM] Autovaccum settings while Bulk Loading data

2010-06-10 Thread Heikki Linnakangas
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 Enter

[PERFORM] Autovaccum settings while Bulk Loading data

2010-06-10 Thread Ambarish Bhattacharya
Dear Experts, I have data about half milllion to 1 million which is populated into the Postgres db using a batch job (A sql script consists of pl/pgsql functions and views) . I am using PostgreSQL 8.3.5 on windows 2003 64-Bit machine. It would be helpful if you can suggest me the app