On 1 Dec 2009, at 11:00, <a.bhattacha...@sungard.com> 
<a.bhattacha...@sungard.com> wrote:

> 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


If I recall correctly Windows doesn't have sockets so the connection is made 
using the loopback device. Maybe the worker process isn't allowed to connect 
and after a while it times out trying?

If it's not that, there is a good chance that your AV software installed all 
kinds of hooks that can subtly change the behaviour of system functions. If 
that's the case disabling it is not enough, you should try to uninstall it and 
hope it removes all the hooks.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4b14f01211735785317057!



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to