Postgres Pro
Downloads
Home   >   mailing lists

Re: WARNING: worker took too long to start; cancelled on VACCUM ANALYZE - Mailing list pgsql-general

From Sam Jas
Subject Re: WARNING: worker took too long to start; cancelled on VACCUM ANALYZE
Date
Msg-id 150593.39577.qm@web95013.mail.in2.yahoo.com
Whole thread Raw
In response to WARNING: worker took too long to start; cancelled on VACCUM ANALYZE  (<A.Bhattacharya@sungard.com>)
List pgsql-general
Tree view
May you try to de-install AV & try to take a dump ?

Thanks
Dhaval

--- On Tue, 1/12/09, A.Bhattacharya@sungard.com <A.Bhattacharya@sungard.com> wrote:

From: A.Bhattacharya@sungard.com <A.Bhattacharya@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.

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: WARNING: worker took too long to start; cancelled on VACCUM ANALYZE
Next
From: "Albe Laurenz"
Date:
Subject: Re: what did happen to dblink_ora