Horton

Re: Statement timeout behavior in extended queries

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tatsuo Ishii <ishii@sraoss.co.jp>
Cc: tsunakawa.takay@jp.fujitsu.com, david@fetter.org, pgsql-hackers@postgresql.org
Date: 2017-04-03T14:05:16Z
Lists: pgsql-hackers 
Tatsuo Ishii <ishii@sraoss.co.jp> writes:
>> * The difference is that the Execute message stops the statement_timeout timer, 

> No. Parse, bind and Execute message indivually stops and starts the
> statement_timeout timer with the patch.

That seems like it could represent quite a lot of added overhead,
on machines where gettimeofday() is slow ... which is still a lot
of them, unfortunately.

			regards, tom lane

Commits

  1. Rearm statement_timeout after each executed query.