Re: Humor me: Postgresql vs. MySql (esp. licensing) - Mailing list pgsql-general

From Tom Lane
Subject Re: Humor me: Postgresql vs. MySql (esp. licensing)
Date
Msg-id 12539.1069429920@sss.pgh.pa.us
Whole thread Raw
In response to Re: Humor me: Postgresql vs. MySql (esp. licensing)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Humor me: Postgresql vs. MySql (esp. licensing)  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> The one problem with the signal approach is how long does the system
> wait before giving up on the app shutdown?  Seems that should be
> something controllable by the admin, but without shutdown scripts, it
> isn't.

I believe 20 seconds is the standard number --- that's plenty for
Postgres.  (I know that it is about 20 seconds on OS X, because
that's how much time tended to get added to the shutdown procedure
back when OS X 10.0 had that shutdown bug that prevented the postmaster
from forking a shutdown subprocess.)

The fact that the number isn't readily configurable is indeed a PITA.
In a previous lifetime I ran a data-collection application that needed
more than 20 seconds to shut down, and so would not exit cleanly if
you didn't have a shutdown script step that would wait for it.  But
I don't see it as a problem for Postgres.

            regards, tom lane

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Postgresql vs. MySql - need feature matrix for
Next
From: Denis Gasparin
Date:
Subject: Re: Bug in pg_dumpall