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/

Reply via email to