Re: Add client connection check during the execution of the query - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Add client connection check during the execution of the query
Date
Msg-id CA+hUKGJtJM91cWqTby=EX=63ERjB5PumdSWKKmamLBE-QLXE+w@mail.gmail.com
Whole thread Raw
In response to Re: Add client connection check during the execution of the query  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Responses Re: Add client connection check during the execution of the query  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
On Thu, Jul 18, 2019 at 3:19 PM Tatsuo Ishii <ishii@sraoss.co.jp> wrote:
> So the performance is about 5% down with the feature enabled in this
> case.  For me, 5% down is not subtle. Probably we should warn this in
> the doc.

Yeah, the timer logic is wrong.  I didn't have time to look into it
but with truss/strace for some reason I see 3 setitimer() syscalls for
every query, but I think this doesn't even need to set the timer for
every query.


--
Thomas Munro
https://enterprisedb.com



pgsql-hackers by date:

Previous
From: Asim R P
Date:
Subject: Re: ERROR after writing PREPARE WAL record
Next
From: Tatsuo Ishii
Date:
Subject: Re: Add client connection check during the execution of the query