Re: Performance degrades until dump/restore

Поиск
Список
Период
Сортировка
От Chris
Тема Re: Performance degrades until dump/restore
Дата
Msg-id CAMv1wqcJAj_g0HUZ2__w-e_hc2YXFUkQBOrU+5kLid+A3pREaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance degrades until dump/restore  (Chris Travers <chris.travers@gmail.com>)
Ответы Re: Performance degrades until dump/restore
Список pgsql-general
Дерево обсуждения
Hi Chris,
It is postgres 9.1, with default settings.  The autovacuum settings are all commented out, I have not change dthem. My understanding is that analyze is also run automatically by default.
 
So, I believe the answer to both questions is 'Yes'.

 
On Thu, Apr 19, 2012 at 12:47 AM, Chris Travers <chris.travers@gmail.com> wrote:
Is autovacuum running?

Are tables being analyzed from time to time?

 Best Wishes,
Chris Travers

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

Предыдущее
От: Filip Rembiałkowski
Дата:
Сообщение: DROP and re-CREATE a table, and ERROR: could not open relation with OID xyz
Следующее
От: Yvon Thoraval
Дата:
Сообщение: problem with serial