Re: reducing statistics write overhead

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: reducing statistics write overhead
Дата
Msg-id 20888.1220724752@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: reducing statistics write overhead  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: reducing statistics write overhead
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Some sort of "if stats were requested in the last 500 ms, just tell the
> requester to read the existing file".

> Things that come to mind:

> - autovacuum could use a more frequent stats update in certain cases

BTW, we could implement that by, instead of having a global tunable,
including a field in the request message saying how stale an existing
file is acceptable for this requestor.  500ms might be the standard
value but autovac could use a smaller number.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: reducing statistics write overhead
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Fix an oversight in the 8.2 patch that improved mergejoin