May you try to de-install AV & try to take a dump ?
Thanks
Dhaval
--- On Tue, 1/12/09, A.Bhattacharya@xxxxxxxxxxx <A.Bhattacharya@xxxxxxxxxxx> wrote:
From: A.Bhattacharya@xxxxxxxxxxx <A.Bhattacharya@xxxxxxxxxxx>
Subject: WARNING: worker took too long to start; cancelled on VACCUM ANALYZE
To: pgsql-general@xxxxxxxxxxxxxx
Date: Tuesday, 1 December, 2009, 10:00 AM
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.
|
The INTERNET now has a personality. YOURS!
See your Yahoo! Homepage.
