Re: Autovacuum launcher patch - Mailing list pgsql-patches

From Tom Lane
Subject Re: Autovacuum launcher patch
Date
Msg-id 2340.1169874871@sss.pgh.pa.us
Whole thread Raw
In response to Autovacuum launcher patch  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Autovacuum launcher patch  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Jeremy Drake
Date:
Subject: Re: [HACKERS] less privileged pl install
Next
From: "Pavan Deolasee"
Date:
Subject: Ctid chain following enhancement