Re: kill -KILL: What happens?

Alvaro Herrera <alvherre@commandprompt.com> wrote:
 
> If postmaster dies, and then another backend crashes, then your
> backend running "your honking big query" could run across
> corrupted state and then you'd be in serious trouble.
 
Worst of all, it could give bogus results without error.  I really
don't see a production use case for letting backends continue after
postmaster failure -- unless you only kinda, sorta care whether
committed data is actually retrievable or reported data is actually
accurate.
 
-Kevin