May you try to de-install AV & try to take a dump ? Thanks Dhaval
--- On Tue, 1/12/09, a.bhattacha...@sungard.com <a.bhattacha...@sungard.com> wrote: From: a.bhattacha...@sungard.com <a.bhattacha...@sungard.com> Subject: [GENERAL] WARNING: worker took too long to start; cancelled on VACCUM ANALYZE To: pgsql-general@postgresql.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/