Re: maintenance memory vs autovac

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: maintenance memory vs autovac
Дата
Msg-id 26625.1228266015@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: maintenance memory vs autovac  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: maintenance memory vs autovac  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Re: maintenance memory vs autovac  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
> Greg Stark wrote:
>> One concern I have about this is people asking "how come when I
>> runvacuum manually it takes x minutes but when autovacuum runs it it
>> tale 5x minutes?"

> As long as the default is the same, people would get at least an initial
> clue that it might have something to do with them changing a
> configuration parameter...

It seems like mostly a confusion-generator to me.  Is there any actual
evidence that autovac should use a different maintenance_work_mem than
other processes?
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_stat_all_tables vs NULLs
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUG] lo_open() makes a warning/falls to an assertion