Re: [SQL] zombie postmasters

"Hamid Khoshnevis" <hamid(at)emarq(dot)com> writes:
> In a web environment, a user can repeatedly starts and abort large queries
> which create a large number of zombie postmasters.

It shouldn't be possible for there to be zombie postgres processes ---
the postmaster process should reap dead backends more or less instantly.
Either your postmaster is getting wedged somehow, or there is a
configure/install problem that has broken the postmaster's handling
of child-process exit. What platform are you using, exactly? What
if anything shows up in the postmaster log when this happens?

regards, tom lane