Re: Autovacuum launcher patch

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Autovacuum launcher patch
Дата
Msg-id 2340.1169874871@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Autovacuum launcher patch  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Autovacuum launcher patch  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-patches
Alvaro Herrera <alvherre@commandprompt.com> writes:
> The launcher is a dummy process; it never connects to any database.
> ...  Eventually this will need to
> be changed so that the launcher tells the worker exactly what table to
> work on.

I detect a certain lack of clarity of thinking here.  Either the
launcher can read databases or it can't.  Do you intend to solve the
problem of all the transaction/catcache infrastructure being designed
on the assumption of being in exactly one database?

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.

            regards, tom lane

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

Предыдущее
От: Jeremy Drake
Дата:
Сообщение: Re: [HACKERS] less privileged pl install
Следующее
От: "Pavan Deolasee"
Дата:
Сообщение: Ctid chain following enhancement