Re: [pgsql-patches] Autovacuum launcher patch

Поиск
Список
Период
Сортировка
От Markus Schiltknecht
Тема Re: [pgsql-patches] Autovacuum launcher patch
Дата
Msg-id 45BE4AC8.2000800@bluegap.ch
обсуждение исходный текст
Ответы Re: [pgsql-patches] Autovacuum launcher patch  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera wrote:
>> I'd suggest sticking to something closer to the current two-phase design
>> where you make some preliminary decision which database to send a worker
>> to, and then the worker determines exactly what to do once it can look
>> around inside the DB.  Possibly we need some back-signaling mechanism
>> whereby a worker can tell the launcher "hey boss, send help" if it sees
>> that there are enough tables that need work, but I'm unenthused about
>> having the launcher figure that out itself.
> 
> Hmm, yeah, we'll probably need some communication channel eventually.

Maybe my IMessages code could be of use?

It's still awfully slow compared with UNIX pipes or even System V IPC 
message queues, since it uses LWLocks for sending and retrieving 
messages. That could certainly be optimized, maybe even towards a 
lock-free implementation, which could theoretically be as fast as System 
V IPC messages. OTOH, such stuff is hard to get right.

Regards

Markus


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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: weird buildfarm failures on arm/mipsel and --with-tcl
Следующее
От:
Дата:
Сообщение: Re: shared_preload_libraries support on Win32?