Re: Error on VACCUM ANALYZE

Is there any other processes running over the same system
like antivirus or similar software on the machine?

Have you changed any configuration parameters around the memory size such as
shared_buffers?

--
Thanks
Sam Jas

--- On Thu, 26/11/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] Error on VACCUM ANALYZE
To: pgsql-general(at)postgresql(dot)org
Date: Thursday, 26 November, 2009, 12:34 PM

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 am using
PostgreSQL 8.3.5 on windows 32 bit machine.

Any help
would be highly appreciated.

Many thanks
in advance.

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