After vacuum application runs very slow ? is this common behavior ?

Поиск
Список
Период
Сортировка
От Sri Linux
Тема After vacuum application runs very slow ? is this common behavior ?
Дата
Msg-id CAFcfow-_y3hgHFoe2Lkp4LpGYAv9dLc347a=CMoNyFhU4NYW9g@mail.gmail.com
обсуждение исходный текст
Ответы Re: After vacuum application runs very slow ? is this common behavior ?  (Sri Linux <srilinux09@gmail.com>)
Re: After vacuum application runs very slow ? is this common behavior ?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi All,

Our production database size is about 2TB and we had run into issues and Postgres log did recommend running the vacuum in single-user mode. We have successfully completed running a single user mode vacuum without any options. .. services were online after vacuum. Application load time and response times are very poor and don't load sometimes. Is this common behavior after a vacuum? DO we need to consider any post activities or give some time for the database to settle down?

Did full os restart for the DB server?

Thanks 
Sri.

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

Предыдущее
От: Sri Linux
Дата:
Сообщение: Re: Single user model vaccum
Следующее
От: Sri Linux
Дата:
Сообщение: Re: After vacuum application runs very slow ? is this common behavior ?