Re: reducing statistics write overhead

Поиск
Список
Период
Сортировка
От Asko Oja
Тема Re: reducing statistics write overhead
Дата
Msg-id ecd779860809061245m1d1d69c5of5104b890d466dda@mail.gmail.com
обсуждение исходный текст
Ответ на Re: reducing statistics write overhead  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Too frequent read protection is already handled in the patch but these comments might lead it into new directions. Current implementation had this same limit that file was written no more than once per 500 ms.

On Sat, Sep 6, 2008 at 9:12 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

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

Предыдущее
От: Abhijit Menon-Sen
Дата:
Сообщение: Re: [PATCH] "\ef " in psql
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Need more reviewers!