Re: Add client connection check during the execution of the query

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Add client connection check during the execution of the query
Дата
Msg-id CA+hUKGJtJM91cWqTby=EX=63ERjB5PumdSWKKmamLBE-QLXE+w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add client connection check during the execution of the query  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Ответы Re: Add client connection check during the execution of the query  (Tatsuo Ishii <ishii@sraoss.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Asim R P
Дата:
Сообщение: Re: ERROR after writing PREPARE WAL record
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Add client connection check during the execution of the query