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