Re: [HACKERS] PID of backend - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] PID of backend
Date
Msg-id 25755.928350863@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] PID of backend  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "Brent Waldrop"
Date:
Subject: XOpenDisplay problems?
Next
From: "Nat Howard"
Date:
Subject: RE: [HACKERS] Re: [SQL] Column name's length