Re: too low NAPTIME_PER_CYCLE /too many wakeups in walreceiver.c

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: too low NAPTIME_PER_CYCLE /too many wakeups in walreceiver.c
Дата
Msg-id CAHGQGwH9QJmffoTYc7QBRjaQe3c_5aRML2MRU7aK+SM9o9iQDw@mail.gmail.com
обсуждение исходный текст
Ответ на too low NAPTIME_PER_CYCLE /too many wakeups in walreceiver.c  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
On Wed, May 30, 2012 at 9:57 PM, Andres Freund <andres@2ndquadrant.com> wrote:
> Hi,
>
> Currently the walreceiver wakeups NAPTIME_PER_CYCLE=100 miliseconds in idle
> state. This is rather frequent. I don't really see any reason to do so.
> A nice fix would be to latchify that with WaitLatchOrSocket + a SetLatch in
> the signal handler for shutdown but that seems to be too invasive at that
> point. So I suggest simply increasing NAPTIME_PER_CYCLE to 500 or 1000ms?

Or calculate the sleep time from wal_receiver_status_interval in each
cycle and use it?

Regards,

-- 
Fujii Masao


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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: 9.2beta1, parallel queries, ReleasePredicateLocks, CheckForSerializableConflictIn in the oprofile
Следующее
От: Ants Aasma
Дата:
Сообщение: Re: slow dropping of tables, DropRelFileNodeBuffers, tas