Re: pg_terminate_backend

Thanks. Good plan.

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

Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)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(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +