WARNING: worker took too long to start; cancelled on VACCUM ANALYZE

Поиск
Список
Период
Сортировка
От
Тема WARNING: worker took too long to start; cancelled on VACCUM ANALYZE
Дата
Msg-id 4AD2336877609F41A2B0D53BAD09FC57B2943B@VOO-EXCHANGE07.internal.sungard.corp
обсуждение исходный текст
Ответы Re: WARNING: worker took too long to start; cancelled on VACCUM ANALYZE  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Re: WARNING: worker took too long to start; cancelled on VACCUM ANALYZE  (Sam Jas <samjas33@yahoo.com>)
Список pgsql-general
Дерево обсуждения

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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: limiting resources to users
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: WARNING: worker took too long to start; cancelled on VACCUM ANALYZE