Re: [HACKERS] PID of backend

Bruce Momjian <maillist@candle.pha.pa.us> writes:
>> I need to restart backend because (as written  above) 
>> every 300 000 "open cursor" query completly loose it's mind.

> I hope 6.5 due on June 7 will fix your problems.

It might.  Looking back at the original gripe, I notice it mentions
doing rollbacks:

>>>>> Jun  2 00:12:32 mail popper[17585]: PgSQL:ROLLBACK failed:

If Dmitry is doing a whole lot of rollbacks, he might be running into
that aborted-transactions-leak-memory bug that we fixed a few weeks ago.

Meanwhile, I still say that getting rid of a backend via kill() is a
dangerous and unnecessary "recovery" mechanism.  What's wrong with
just closing and reopening the connection instead?
        regards, tom lane