Error on VACCUM ANALYZE
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.
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.Bhattacharya@sungard.com <A.Bhattacharya@sungard.com> wrote:From: A.Bhattacharya@sungard.com <A.Bhattacharya@sungard.com>
Subject: [GENERAL] Error on VACCUM ANALYZE
To: pgsql-general@postgresql.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/