Re: bg worker: patch 1 of 6 - permanent process
Itagaki Takahiro <itagaki.takahiro@gmail.com>
From: Itagaki Takahiro <itagaki.takahiro@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Markus Wanner <markus@bluegap.ch>, PostgreSQL-development Hackers <pgsql-hackers@postgresql.org>
Date: 2010-08-26T03:01:00Z
Lists: pgsql-hackers
On Thu, Aug 26, 2010 at 11:39 AM, Robert Haas <robertmhaas@gmail.com> wrote: >> On Tue, Jul 13, 2010 at 11:31 PM, Markus Wanner <markus@bluegap.ch> wrote: >>> This patch turns the existing autovacuum launcher into an always running >>> process, partly called the coordinator. > > It's not clear to me whether it's better to have a single coordinator > process that handles both autovacuum and other things, or whether it's > better to have two separate processes. Ah, we can separate the proposal to two topics: A. Support to run non-vacuum jobs from autovacuum launcher B. Support "user defined background processes" A was proposed in the original "1 of 6" patch, but B might be more general. If we have a separated coordinator, B will be required. Markus, do you need B? Or A + standard backend processes are enough? If you need B eventually, starting with B might be better. -- Itagaki Takahiro