Default client_connection_check_interval to 10s on supported systems
В списке pgsql-hackers по дате отправления:
| От | Tristan Partin |
|---|---|
| Тема | Default client_connection_check_interval to 10s on supported systems |
| Дата | |
| Msg-id | CTEB8LNLOHKR.3I6NK8QVBAGSQ@gonk обсуждение исходный текст |
| Ответы |
Re: Default client_connection_check_interval to 10s on supported systems
|
| Список | pgsql-hackers |
Hi, I am proposing that the default value of client_connection_check_interval be moved to a non-zero value on systems where it is supported. I think it would be a nice quality of life improvement. I have run into a problem where this would have been useful before with regard to pgbench not currently handling SIGINT corrently[0]. I basically picked 10s out of thin air and am happy to change it to what others feel would be more appropriate. This doesn't need to be a check that happens often because it should just be a backstop for unusual scenarios or poorly programmed clients. The original thread where Thomas committed these changes seemed to indicate no performance impact[1]. The only reason that I can think of this being turned off by default is that it isn't available on all systems that Postgres supports. When this was committed however, the only system that seemed to support EPOLLRDHUP was Linux. Seems like in recent years this story has changed given the description of the parameter. > This option relies on kernel events exposed by Linux, macOS, illumos and > the BSD family of operating systems, and is not currently available on > other systems. [0]: https://www.postgresql.org/message-id/CSSWBAX56CVY.291H6ZNNHK7EO@c3po [1]: https://www.postgresql.org/message-id/CA+hUKG++KitzNUOxW2-koB1pKWD2cyUqA9vLj5bf0g_i7L1M0w@mail.gmail.com -- Tristan Partin Neon (https://neon.tech)
В списке pgsql-hackers по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера