Re: tie user processes to postmaster was:(Re: [HACKERS] scheduler in core)

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Dave Page <dpage(at)pgadmin(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: tie user processes to postmaster was:(Re: [HACKERS] scheduler in core)
Date: 2010-02-22 18:50:33
Message-ID: 4B82D1F9.2040004@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jaime Casanova wrote:
> > if we can do this, how should it work?
> Simon said:
> """
> Yes, I think so. Rough design...
>
> integrated_user_processes = 'x, y, z'
>
> would run x(), y() and z() in their own processes. These would execute
> after startup, or at consistent point in recovery. The code for these
> would come from preload_libraries etc.
>
> They would not block smart shutdown, though their shudown sequence might
> delay it. User code would be executed last at startup and first thing at
> shutdown.
>
> API would be user_process_startup(), user_process_shutdown().
> """
>
> so it should be a GUC, that is settable only at start time.

A GUC like that was my first thought too. We've already come up with
many uses for it, so whatever the interface is, will need to make sure
it's flexible enough to cater for all the use cases.

> we need those integrated processes at all when in a standby server?

Yes. You might want to run e.g. scheduled reports from a standby
reporting server, launched by a scheduler process. Or backups.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2010-02-22 18:59:43 Re: tie user processes to postmaster was:(Re: [HACKERS] scheduler in core)
Previous Message Joshua D. Drake 2010-02-22 18:49:29 Re: Recent vendor SSL renegotiation patches break PostgreSQL