Re: pg_terminate_backend

Thanks.  Good plan.

---------------------------------------------------------------------------

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Tom Lane wrote:
> >> What I'm looking for is some concentrated testing.  The fact that some
> >> people once in a while SIGTERM a backend doesn't give me any confidence
> >> in it.
> 
> > OK, here is an opportunity for someone to run tests to get this into
> > 8.2.  The code already exists in CVS, but we need testing to enable it.
> > I would think running a huge workload and killing it over and over again
> > would be a good test.
> 
> Big multiprocess workload and you kill individual processes at random
> while letting the rest run.  It probably needs to be something that
> stresses more of the code than pgbench would, too.  (For instance,
> it'd be a good idea if some of the workload involved having a few 2PC
> transactions getting prepared and then either committed or rolled
> back ... SIGTERM during a COMMIT PREPARED strikes me as the sort of
> corner case that's probably never been exercised.)
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +