Re: Humor me: Postgresql vs. MySql (esp. licensing)

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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