Re: Reduced power consumption in autovacuum launcher process

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reduced power consumption in autovacuum launcher process
Дата
Msg-id 16642.1311003159@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reduced power consumption in autovacuum launcher process  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Reduced power consumption in autovacuum launcher process
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Jul 18, 2011 at 10:35 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> A wakeup once every half hour would surely not be an issue from a power
>> consumption standpoint. �However, I'm not sure I understand here: aren't
>> we trying to remove the timeouts completely?

> Well, in the case of the AV launcher, the issue is that the main loop
> is timed by definition, cf. autovacuum_naptime, and the WaitLatch()
> interface is apparently designed so that we can't sleep longer than 35
> minutes.

Hmm.  Well, it's not too late to rethink the WaitLatch API, if we think
that that might be a significant limitation.  Offhand I don't see that
it is, though.
        regards, tom lane


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

Предыдущее
От: Yeb Havinga
Дата:
Сообщение: Re: [v9.1] sepgsql - userspace access vector cache
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: FOR KEY LOCK foreign keys