Skip site navigation (1) Skip section navigation (2)

Re: bgwriter never dies

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: josh(at)agliodbs(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: bgwriter never dies
Date: 2004-02-26 19:00:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Josh Berkus <josh(at)agliodbs(dot)com> writes:
> Well, my opinion is based on the question, can we restart the
> postmaster if it dies and the other backends are still running?

You can't start a fresh postmaster until the last of the old backends is
gone (and yes, there's an interlock to prevent you from making this
mistake, though people have been known to override the interlock :-().

This means there's a tradeoff between allowing new sessions to start
soon and letting old ones finish their work.  It seems to me that
either of these goals might have priority in particular situations,
and that it would not be wise for us to design in a forced choice.
With the current setup, the DBA can manually SIGINT or SIGTERM
individual backends when he deems them unworthy of allowing to finish.
If we put in a forced quit as Jan is suggesting, we take away that

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Jeroen T. VermeulenDate: 2004-02-26 19:00:43
Subject: Re: [HACKERS] Collaboration Tool Proposal
Previous:From: Josh BerkusDate: 2004-02-26 18:49:46
Subject: Re: [HACKERS] Collaboration Tool Proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group