Re: Proposal to add a QNX 6.5 port to PostgreSQL - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Proposal to add a QNX 6.5 port to PostgreSQL
Date
Msg-id 1407768010.57571.YahooMailNeo@web122304.mail.ne1.yahoo.com
Whole thread Raw
In response to Re: Proposal to add a QNX 6.5 port to PostgreSQL  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Stephen Frost <sfrost@snowman.net> wrote:

>> Our grace period for active backends after unclean exit of one
>> of their peers is low, milliseconds to seconds.  Our grace
>> period for active backends after unclean exit of the postmaster
>> is unconstrained.  At least one of those policies has to be
>> wrong. Like Andres and Robert, I pick the second one.
>
> Ditto for me.

+1

In fact, I would say that is slightly understated.  The grace
period for active backends after unclean exit of one of their peers
is low, milliseconds to seconds, *unless the postmaster has also
crashed* -- in which case it is unconstrained.  Why is the crash of
a backend less serious if the postmaster has also crashed?
Certainly it can't be considered to be surprising that if the
postmaster is crashing that other backends might be also crashing
around the same time?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: geohas
Date:
Subject: ProcessUtilityHook DropStmt RenameStmt
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: nulls in GIN index