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

From: <A(dot)Bhattacharya(at)sungard(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: WARNING: worker took too long to start; cancelled on VACCUM ANALYZE
Date: 2009-12-01 10:00:52
Message-ID: 4AD2336877609F41A2B0D53BAD09FC57B2943B@VOO-EXCHANGE07.internal.sungard.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2009-12-01 10:29:37 Re: WARNING: worker took too long to start; cancelled on VACCUM ANALYZE
Previous Message Rüdiger Sörensen 2009-12-01 09:34:29 optimizing advice