From: | Christopher Browne <cbbrowne(at)gmail(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | MauMau <maumau307(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: backend hangs at immediate shutdown (Re: Back-branch update releases coming in a couple weeks) |
Date: | 2013-06-21 21:03:18 |
Message-ID: | CAFNqd5UYX5VeD__v8xbEcRD0Y_fpwAQv2=Gg9GCqaP9MR=qLvQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
The case where I wanted "routine" shutdown immediate (and I'm not sure I
ever actually got it) was when we were using IBM HA/CMP, where I wanted a
"terminate with a fair bit of prejudice".
If we know we want to "switch right away now", immediate seemed pretty much
right. I was fine with interrupting user sessions, and there wasn't as
much going on in the way of system background stuff back then.
I wasn't keen on waiting on much of anything. The background writer ought
to be keeping things from being too desperately out of date.
If there's stuff worth waiting a few seconds for, I'm all ears.
But if I have to wait arbitrarily long, colour me unhappy.
If I have to distinguish, myself, between a checkpoint nearly done flushing
and a backend that's stuck waiting forlornly for filesystem access, I'm
inclined to "kill -9" and hope recovery doesn't take *too* long on the next
node...
If shutting a server down in an emergency situation requires a DBA to look
in, as opposed to init.d doing its thing, I think that's pretty much the
same problem too.
From | Date | Subject | |
---|---|---|---|
Next Message | desmodemone | 2013-06-21 21:33:23 | Fixed Cardinality estimation with equality predicates between column of the same table |
Previous Message | Alvaro Herrera | 2013-06-21 20:56:57 | Re: backend hangs at immediate shutdown (Re: Back-branch update releases coming in a couple weeks) |