Re: WAL Rate Limiting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WAL Rate Limiting
Дата
Msg-id 27195.1389886520@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WAL Rate Limiting  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: WAL Rate Limiting  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> I don't really see much difficulty in determining what's a utility
> command and what not for the purpose of this? All utility commands which
> create WAL in O(table_size) or worse.

By that definition, INSERT, UPDATE, and DELETE can all be "utility
commands".  So would a full-table-scan SELECT, if it's unfortunate
enough to run into a lot of hint-setting or HOT-pruning work.

I think possibly a more productive approach to this would be to treat
it as a session-level GUC setting, rather than hard-wiring it to affect
certain commands and not others.
        regards, tom lane



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

Предыдущее
От: Christian Kruse
Дата:
Сообщение: Re: Why conf.d should be default, and auto.conf and recovery.conf should be in it
Следующее
От: Andres Freund
Дата:
Сообщение: Re: WAL Rate Limiting