Re: High CPU with 7.4.1 after running for about 2 weeks - Mailing list pgsql-performance

From Tom Lane
Subject Re: High CPU with 7.4.1 after running for about 2 weeks
Date
Msg-id 7887.1079387214@sss.pgh.pa.us
Whole thread Raw
In response to Re: High CPU with 7.4.1 after running for about 2 weeks  (Mike Bridge <mike@bridgecanada.com>)
List pgsql-performance
Mike Bridge <mike@bridgecanada.com> writes:
> But if the client dies, doesn't postgresql normally terminate the
> query that that client initiated?  Or do I need to set
> statement_timeout?

The backend generally won't notice that the connection is dead until
it next tries to fetch a command from the client.  So if the client
launches a long-running query and then goes away, the query will
normally complete.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Aaron Werman"
Date:
Subject: Re: atrocious update performance
Next
From: Rod Taylor
Date:
Subject: Re: atrocious update performance