Re: WARNING: worker took too long to start; cancelled on VACCUM ANALYZE

May you try to de-install AV & try to take a dump ?

Thanks
Dhaval

--- On Tue, 1/12/09, A(dot)Bhattacharya(at)sungard(dot)com <A(dot)Bhattacharya(at)sungard(dot)com> wrote:

From: A(dot)Bhattacharya(at)sungard(dot)com <A(dot)Bhattacharya(at)sungard(dot)com>
Subject: [GENERAL] WARNING: worker took too long to start; cancelled on VACCUM ANALYZE
To: pgsql-general(at)postgresql(dot)org
Date: Tuesday, 1 December, 2009, 10:00 AM

Hi All, 

I am facing the below error when
executing “VACCUM ANALYZE” on the several tables and also the
entire PostgreSQL database hanging up and not responding.

WARNING: 
worker took too long to start; cancelled

 I have disabled my AV and
I have the modified the below parameters in my postgresql.conf file

shared_buffer = 1024MB
max_fsm_pages = 409600
max_fsm_relations = 5000            

I am using PostgreSQL 8.3.5 on
windows 32 bit machine.

Any help would be highly
appreciated as this is kind of show stopper for me.

The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/