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.
